Home » Developer & Programmer » Forms » Dynamic SQL
Dynamic SQL [message #270257] Wed, 26 September 2007 06:06 Go to next message
sinida1984
Messages: 83
Registered: September 2007
Location: India
Member
Hi,
I have a simple dynamic SQL like the below which is changing everytime in my oracle forms,,
eg... 'Select ''B'' from dual';
How can i return that value into a variable in form..
i used name_in('Select ''B'' from dual')..but it is returning the string inside it..wt to do if i need to get 'B' instead...?

Regards,
Sinida
Re: Dynamic SQL [message #270434 is a reply to message #270257] Wed, 26 September 2007 21:39 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Try 'Select ''B'' into :my_blk.my_itm from dual'

David
Previous Topic: Change title of a separate window
Next Topic: how to export or import data to excel from database
Goto Forum:
  


Current Time: Thu Dec 08 23:56:56 CST 2016

Total time taken to generate the page: 0.09538 seconds