Results 1 to 2 of 2

Thread: Using DDL

  1. #1
    Join Date
    Jan 2003
    Location
    China
    Posts
    38

    Unanswered: Using DDL

    Hi all,
    We know that we can do everything by DML in procedure,function and trigger.But how can we use DDL in this DBObject?
    At least I'm sure that we can't use DDL directly in these DBObject to do something such as drop table.

    Any discusstion will be appreciated.Thanks!
    Fan Yi

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    You can't do it directly, but you can using dynamic SQL:

    BEGIN
    EXECUTE IMMEDIATE 'DROP TABLE xxx';
    END;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •