| jayesh |
Posted: Jan 07, 2008 10:16:55 AM |
Total Post: 60
Joined: Jan, 2008
|
can i use DDL statement in procedure like create table or alter table.
Pls reply me in detail. |
|
|
 Mohammed Taj |
| Posted: Jan 07, 2008 10:38:36 AM |  |
|
Total Post: 746
Joined: Jul, 2007
|
Yes, you can use it through "execute immediate"
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/executeimmediate_statement.htm#LNPLS01317
|
|
|
|
|
| pammi |
| Posted: Feb 29, 2008 06:02:48 AM | |
|
Total Post: 21
Joined: Feb, 2008
|
Please see the following example
CREATE OR REPLACE PROCEDURE del_rows
(p_table_name IN VARCHAR2)
IS BEGIN
EXECUTE IMMEDIATE ‘drop table ‘ || p_table_name;
END;
|
|
|
|
|
| Vish |
| Posted: Jul 28, 2008 01:57:45 AM | |
|
Total Post: 84
Joined: Jan, 2007
|
you can use DBMS_SQL package for it
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
