Home » Developer & Programmer » Forms » Dynamic Table Names...
Dynamic Table Names... [message #78893] Wed, 27 March 2002 20:42 Go to next message
Umesh Sharma
Messages: 14
Registered: February 2000
Junior Member
Dear Oracle Friends

I have an application in which I dynamically find the name of detail table. Now I want to count the number of records in this dynamically accuired table name.


tnm := 'tempdata'

select count(*) into cnt from tnm[[dynamic table name]];

Can any body help...

Re: Dynamic Table Names... [message #78906 is a reply to message #78893] Thu, 28 March 2002 17:14 Go to previous message
Messages: 56
Registered: November 2001
It is not possible like that b/c forms only accept a permanent table name after FROM clause. U should use DBMS_SQL package for that.

Previous Topic: Closing Forms MDI window
Next Topic: Dynamic tablename in the query for Reports
Goto Forum:

Current Time: Wed May 22 03:52:22 CDT 2024