Search results for query: *

Hi, Never done this before, what do I need to do in order to pass a parameter from FORM_A to FORM_B. TIA

Hi, People I need some of assistance... I have been asked to find all tables that may have the data = 'DATA' and then to update this with some new 'DATA'. As you may appreciate there are thousands of tables on the system and the column may be called anything. I have read some of the...

Hi I have got around 53 SQL statments similar to: SELECT * FROM 'VARIOUS_TABLE' WHERE 'CHANGING_COLUMN_NAME' = 'CONSISTANT_VALUE' I NEED TO EXECUTE THESE TO SEE IF THEY BRING BACK ANYTHING DISREGARDING ANY THAT DONT. I'M JUST WONDERING IF THERE IS A FAST AND EFFICIENT WAY TO THIS. TIA

Hi all, Is it possible for me to insert a ‘.jpg’ photo into the table that holds photos in BLOB format? Any suggestions are appreciated. TIA

Hi, I have a query as below; select A.Value from TABLE_A A, TABLE_B B where A.code in (select C.code from TABLE_C C where C.code = A.code and C.Value !=A.Value) and A.Value = B.Value Can someone please suggest how I may update the C.Value on TABLE_C with...

Hi Can someone tell me how I can get the £ sign to display because at the moment its returning #. I have tried chr(163) but the same thing. Some details form the db if helps are: NLS_LANGUAGE = AMERICAN NLS_TERRITORY = AMERICA NLS_CURRENCY = $ NLS_CHARACTERSET = US7ASCII

Hi experts, Just a quicky, I am doing... Select field_1, field_2 from table_A a, table_B b where a.identity = b.identity; However, table_B has duplicates but I just want the one record from the table because they are exactly the same so the fist one it comes across will do. Any suggestions ? TIA

Hi, Please can you help... I'm new to reports from a forms background... I am amending a report which always had one date that it brought back to be displayed however now there is a potential for two dates depending on the parameter the user chooses from a drop down option. For example, if...

Hi Please can you help...it is a forms thing but i will appreciate anything... I am bringing back images from a table that may have more than one so I need to give the user the choice to select. Please bear in mind that I am amending the form to implement this change that already brings one...

Trying to do an update - but i run out of userspace. Any suggestions / advice / help appreciated. TIA

Hi, If I have a table 'INPUT' made of the cols ex. ID, FLAG, FLAG2, DATE1, DATE2, DATE3, DATE4, TRIGGAR etc etc. then how can I update the TRIGGAR col to produce a resultant table 'OUTPUT' based on some criteria on the other 'INPUT' cols. Ex. if DATE1 > DATE2 then TRIGGAR = 1, but the triky...

Hi ! Does anyone know of a query on progress ex. physical reads, writes, in / outs etc. that I could use to keep an eye on a query that I am running that can take a long time and sometimes collapse without me ever knowing about it. TIA

we have recently installed a new remote server named "TWOCOOL", can some one please help me set up all that is requred to link up to this server for use for my PC bearing in mind I already use "ONECOOL" and want to continue using this server aswell as the new one.