Re: SELECT * in PRO-C...

David Mallarme wrote:
>
> Hello,
>
> Is there a way to make a generice request like
> Select * INTO array? from table_name where table_key=number;
> without using dynamics queries in PRO-C/PL-SQL ?
>

OCI (Oracle Call Interface) supports dynamic SQL statements to be formed and executed, but it's even more involved than Pro*C or PL/SQL. One way to make dynamic SQL is to have one SQL script (main.sql) which spools to another file (dynam.sql). The main.sql script writes the dynam.sql script by making selections from the data dictionary, dual, etc.

Example:

set heading off
spool dynam.sql

SELECT
  'SELECT count(*) FROM '||owner||'.'||table_name||';' FROM
  sys.dba_tables;

SELECT
  'exit'
FROM
  DUAL; spool off

This would write a script to count all the rows of all the tables in the database.

• TRW -- ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| | Tim Witort || He is not silent. He is not | | trwATmedicalertDOTorg || whispering. We are not quiet | | || we are not listening. | | Pin: TZ, only one :^( || - Out of the Grey | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||