Answer / anji

create table table_name as ( select * from old_table where 1=2)

from this query we can create a new table structure from old
table structure with out data

Answer / suresh babu

create table new_tn as select * from source_tn where 1=2;

This query will create a new table,which take structure of
the source table with out values.

Answer / tejas wajge

create table emp as select * from project where rownum <1;

Answer / srinivas

create table emp1
as
select * from scott.emp where rownum=0

Answer / atul verma

SELECT *
INTO emp1
from scott.emp where rownum=0

Answer / ram

In oracle

Create table newtablename as select * from oldtablename
where 1=2
(any false condition if condition true it copies data from
table it applicable for both oracle & sqlserver)

In Sql server

select * into newtablename from oldtablename where 1=2

Answer / sunil panghal

create table sunil as select *from hr.employees

Answer / shabana

Use the describe command to display the table structure
then use the create table command and copy the table
structure in your command.

What is pl sql package?

0 Answers  

.  have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 Answers  

In a table only one column how to update rows

5 Answers   Microsoft,

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

When is a declare statement required?

0 Answers  

what is a database lock ? : Sql dba

0 Answers  

Is vs as in pl sql?

0 Answers  

What does sign mean sql?

0 Answers  

what is csv? : Sql dba

0 Answers  

What is inner join in sql?

0 Answers  

How to get list of all tables from a database?

0 Answers  

Can you join a table to itself?

0 Answers