Interested to Buy Any Domain ? << Click Here >> for more details...
How can I create a table from another table without copying
any values from the old table?
- 8 Answers
- 13177 Views
- I also Faced
- E-Mail Answers
Answer Posted / atul verma
SELECT *
INTO emp1
from scott.emp where rownum=0
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
Does truncate require commit?
what is a join? : Sql dba
What is sql*loader and what is it used for?
How delete all records from table in sql?
What is hibernate and its relation to sql?
Why do we use cursors?
How to process query result in pl/sql?
How do I pipe the output of one isql to another?
Can we call dml statement in function?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
How do I save the results of sql query in a file?
How can use stored procedures in sql?
What is sql and also describe types of sql statements?
What is data types in sql?
