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 are indexes, and what are the different types?

3 Answers  

What is rtm stands for?

0 Answers  

i don't want the message as 14 rows updated just it should update what it will do

4 Answers  

How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE fashion pls help me , thanks in advance surendra

2 Answers   Zensar,

What is native sql query?

0 Answers  

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent

3 Answers  

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

What are sql data types?

0 Answers  

What is having clause in sql?

0 Answers  

what are the nonstandard string types? : Sql dba

0 Answers  

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F

6 Answers   IBM,

Is id a reserved word in sql?

0 Answers