Create a copy of an Oracle table without copying the data? By Shadab Mohammad • Dec 3, 2012 • 1 comment Do a "create table" as command without selecting any rows create table abc_new as select * from abc where 1=0; Share this:Click to share on Twitter (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Facebook (Opens in new window)Click to share on Tumblr (Opens in new window)Click to share on WhatsApp (Opens in new window) Category: Database • SQL Tags: copy • no data • oracle • table • Tables • without data
Reblogged this on ???? ??????? and commented: Nice and simple idea to create a table from another table without copying any values to the new table. Reply
One comment
Reblogged this on ???? ??????? and commented:
Nice and simple idea to create a table from another table without copying any values to the new table.