Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> dynamic table name
I would like to be able to write a generic select statement where I can pass in data elements and a tablename. Example:
IS
tableName varchar2(10);
dataElements varchar2(60);
tableName := getTableName(arg);
dataElements := getDataElements(args);
// dataElements could have "element1,element2,element3,element4".
//tableName could have "msgType"
select dataElements from tableName where ...
Can this be done??? If so, how???
-- R. Chuck Matthews Associate BOOZ-ALLEN & HAMILTON INC. Office: (703) 908-4322 Fax: (703) 908-4344 email: matthews_chuck_at_bah.comReceived on Fri Aug 04 2000 - 00:00:00 CDT
![]() |
![]() |