Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to check Syntax Checking for Create Table Statement?

953165Oct 10 2012 — edited Oct 10 2012
Hello,

I got requirement to add query in one field and validate the entered query. To validate , I used EXEC_SQL.PARSE command for simple query and it works fine but If apply EXEC_SQL with DDL command like 'Create table' statement it creating the table on back end. I don't want to create table,just want to check syntax for Create Statement. Please suggest other way to check syntax for create Table statement.

Thanks
Kapil

Edited by: Kapil Mistry on Oct 9, 2012 10:39 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 7 2012
Added on Oct 10 2012
3 comments
235 views