Skip to Main Content

SQL & PL/SQL

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!

Create Table and Insert Statement

Orcl ApexAug 25 2017 — edited Aug 25 2017

Hi All,

Many times when a question is asked on OTN then experts wants to provide create table and insert scripts but some time tables are of more then 200 columns and column used in queries where help is required are very less.

DBA's are not giving execute access on database but read only for selects so is there any way to get CREATE table statement and insert statement using only select statement to post data required for posted question support ?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 22 2017
Added on Aug 25 2017
6 comments
1,389 views