Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> dynamic sql question HELPPPPPPPPPP

dynamic sql question HELPPPPPPPPPP

From: gndiving <dwhite_at_vrinter.net>
Date: Wed, 5 Jan 2000 19:58:36 -0500
Message-ID: <850p9j0oss@enews4.newsguy.com>


HI all I have a DBMS_SQL question

I need to read the rowcount of a group of tables(275) into a variable = how can I do this dynamically

I have DBMS_SQL.PARSE(datCursor,SELECT COUNT(*) FROM ' || = datTableName,DBMS_SQL.NATIVE);
WHATS IAM HAVING PROBLEMS WITH IS THE DBMS_SQL.COLUMN_DEFINE STATEMENT IF SOME ONE COULD GIVE ME A SOLUTION TO THIS IT WOULD BE GREATLY = APPRECIATED SEND REPLY'S TO dwhite_at_mail.intracorp.com Received on Wed Jan 05 2000 - 18:58:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US