Home » Developer & Programmer » Forms » Dynamic SQL
Dynamic SQL [message #270257] Wed, 26 September 2007 06:06 Go to next message
Messages: 83
Registered: September 2007
Location: India
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...?

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

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

Current Time: Mon Oct 24 11:23:13 CDT 2016

Total time taken to generate the page: 0.11913 seconds