Create a table in Oracle stored procedure or function

Use the following:

EXECUTE IMMEDIATE 'CREATE TABLE MyTable (id NUMBER)';

ab95f3c4-8c66-4f4d-9ae4-54b5588a7bc9|0|.0

Categories: Databases

Posted by wizgod on Thursday, August 26, 2010 7:58 PM

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (0) | Post RSS RSS comment feed

Insert into table using a stored procedure.Insert into table using a stored procedure.Creating stored procedures in Oracle/PLSQLThe syntax for a procedure is: CREATE [OR REPLACE] PROCEDURE procedure_name [ (parameter [,par...How to find all tables with a specific column name in OracleSimple and effective: SELECT TABLE_NAME FROM USER_TAB_COLUMNS WHERE COLUMN_NAME='PARTNO'

Comments

Add comment

Name*
E-mail*
Website
Country Country flag

b i u quote

Notify me when new comments are added

Byte My Data