Re: How to find the tablename an

From: <R.RASAL_at_ponl.com>
Date: Thu, 4 Jan 2001 13:56:00
Message-Id: <10731.125704@fatcity.com>

Dynamic SQL is again one of the options .

With NATIVE DYNAMIC SQL , the syntaxes are very much simplified , if you are using 8i .

Define a pl/sql table , in which each row contain a varchar2 field for tablename and an integer field for the rowcount .

Build a ref cursor with all table names in that .

Loop thru the cursor and populate the pl/sql table with table and count .

---

Rahul Rasal
UK Mobile No. : 07787824194

---

Received on Thu Jan 04 2001 - 13:56:00 CST