Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can I clone (copy) a table without copying the data (just the schema)?

April 26, 2017clone copy Data schema Table

0

Posted

How can I clone (copy) a table without copying the data (just the schema)?

1 Answer

0

Posted

create table city2 as select * from city where 1=2 ; OR create table brand2 as select * from brand where 1=2 ; Q: How can I load data into Oracle tables: A: 1. SQL Loader 2. TEXT_IO at FORM level, this package use to read from file 3. UTL_FILE, At PL/SQL level package for read text file.