Search results for query: *

Ah... I take your point. But I keep stumbling across PARAMTER_LIST though I only want to pass a employee number to FORM_B. So how do I set up PARAMETER_LIST? Any suggestions are appreciated.

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

Carp Thank you for your interest. Unfortunately the team I am working with is very new and do not have experience of Oracle Forms 3 which is what the procedure has been coded in. Though I will give your data dictionary idea a whiz. Thanks

Mufasa, I don't have an example as such, but if I explain the process I currently have to do then it may clarify what it is I am trying to achieve. So here goes... I am searching for a programme code = 'XXX' that was populated by an automated process. I don't have access to the source code...

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...

Wellster, How would execute the sql statements from within a loop. Thankyou.

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, I have the images saved on my C drive. Can you please explain how I can insert them into the table. 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 Mufasa, Sorry, a case of me being silly, I just tried the "ALTER SESS.." command in sqlPlus (previously I was using TOAD!) it works great. Taking this opportunity of thanking you for all your help. Cheers.

Hi Mufasa, Unfortunately I only have access to the current and one other DB and that also is US7ASCII.

Mufasa... Checked that but mine also says 1252...

Mustafa, No, it returns #12,345.67. Is there anything else I could try ? Thanks

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

just as long ive got only got one record from each match I dont mind which one of the duplicates is extracted. So I was thinking along the lines of max(b.rowid)...

sorry no, the duplicates are on table_B which also contains the image field i need to extract.

yes

Thanks, Tried that but unfortunately I can't use distinct because my field_2 is a blob.

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