| dynamically get the column names [message #466708] |
Tue, 20 July 2010 12:56  |
kalpataru
Messages: 72
Registered: January 2010
Location: INDIA
|
Member |
|
|
hi gurus,
i have listitem populated with many table names from a schema.
i have grid in oracle forms 10g and i want to fill the grid with at least four/more columns.
i want to fire the list change trigger when each time any one table name is selected.
how can i find the columns names dynamically
for filling the grid..
|
|
|
|
| Re: dynamically get the column names [message #466716 is a reply to message #466708] |
Tue, 20 July 2010 14:10  |
jenasatyabrata82
Messages: 21
Registered: July 2009
Location: INDIA
|
Junior Member |
|
|
Trying on your own is the best chance to learn a new thing.
Solving a problem by searching for "concepts",
and then trying to use those concepts,
improves our knowledge,but directly asking the questions ,
and taking answer from someone ,is not a good idea.
Hope you understand it.
And when we try to solve problem,our selves,
we also learn a lot of other things,and
it also increases our confidence level.
[Updated on: Tue, 20 July 2010 23:50] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: dynamically get the column names [message #467479 is a reply to message #467050] |
Sat, 24 July 2010 13:12 |
kalpataru
Messages: 72
Registered: January 2010
Location: INDIA
|
Member |
|
|
hi ,
by getting column names dynamically i am creating a record group
using this below query
SELECT COLUMN_NAME, DATA_TYPE FROM USER_TAB_COLUMNS WHERE TABLE_NAME = <table_name>
but when timestamp datatype is there then it is showing error cannot create group groupname
but the record group is running successful on varchar2,number,date dayatypes
if any alternative is there i mean to say without using record group then tell me or where is the problem
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
