| September 09, 2007 07:09:16 |
#1 |
| hemangi.savaliya |
Member Since: Visitor Total Comments: N/A |
RE: How to write a query or procedure or function to r...
|
DECLARE
vtname VARCHAR2(100);
CURSOR cur_tablename IS
SELECT tname
FROM tab;
BEGIN
OPEN cur_tablename;
FOR i IN 1 .. 100
LOOP
FETCH cur_tablename
INTO vtname;
EXIT WHEN cur_tablename%NOTFOUND;
dbms_output.put_line(' table name' || vtname);
BEGIN
EXECUTE IMMEDIATE ' select 1 from ' || vtname; --||' where rownum<2';
EXCEPTION
WHEN no_data_found THEN
dbms_output.put_line(' doesn''t have data' || vtname);
END;
END LOOP;
CLOSE cur_tablename;
END; |
| |
