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.

E.G.

tnm := 'tempdata'

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

Can any body help...

UMESH
Re: Dynamic Table Names... [message #78906 is a reply to message #78893] Thu, 28 March 2002 17:14 Go to previous message
Imran
Messages: 56
Registered: November 2001
Member
Hi.
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.

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


Current Time: Fri Mar 29 10:14:27 CDT 2024