MSSQL TSQL to Oracle PL/SQL

From: Mio-Nino P. Marquez <mio.marquez_at_mailcity.com.nospam>
Date: Fri, 07 May 1999 10:31:58 +0800
Message-ID: <3732509E.7E6B455_at_mailcity.com.nospam>



Hi.

[Quoted] Can somebody please give me the equivalent of these MSSQL TSQL in Oracle PL/SQL:  DECLARE
_at_TableName VarChar(30),
_at_CustomerKey VarChar(20)

 SELECT _at_TableName = 'CUSTOMER'
 SELECT _at_CustomerKey = 'Oracle'

 EXECUTE('INSERT INTO ' + _at_TableName + ' VALUES (' + @CustomerKey + ')')

Basically, all I wanted to do is to dynamically create the SQL statement, with variables replacing what's supposed to be an object (i.e. Table's name, Column's Name)....

Please help.

Thanks.

Mio Marquez
Delphi Developer Received on Fri May 07 1999 - 04:31:58 CEST

Original text of this message