Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by teknikalbody

  1. teknikalbody

    [b]PASSING PARAMETER BETWEEN FORMS[/b]

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

    [b]PASSING PARAMETER BETWEEN FORMS[/b]

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

    [b}UPDATING UNKNOWN TABLE OR COLUMN [/b]

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

    [b}UPDATING UNKNOWN TABLE OR COLUMN [/b]

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

    [b}UPDATING UNKNOWN TABLE OR COLUMN [/b]

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

    SQL scripts

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

    SQL scripts

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

    Inserting photo into BLOB data type

    Hi, I have the images saved on my C drive. Can you please explain how I can insert them into the table. TIA
  9. teknikalbody

    Inserting photo into BLOB data type

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

    Quick Update question

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

    Cant get the '£' sign

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

    Cant get the '£' sign

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

    Cant get the '£' sign

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

    Cant get the '£' sign

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

    Cant get the '£' sign

    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
See more

Part and Inventory Search

Back
Top