Answer / gourvendra singh

if you need to take tha backup of the database on ur hard
disk then u can use the following query:

exp userid=system/manager@orcl file=location\abc.dmp full=y
log= abc

Answer / k.l.rajesh babu

BACKUP DATABASE DATABASE_NAME TO DISK='C:\BackupDB\DB.bak'

Answer / suresh

BACKUP DATABASE DATABASE_NAME TO DISK='C:\BackupDB\DB.bak'

Answer / vikneswaran

SELECT column_name(s)
INTO new_table_name
FROM old_tablename

Answer / rk

we can do it from user_tables

like

select table_name,tablespace_name from user_tables;

Answer / ganesh

create table backup as select * from user_tables;

create table backup1 as select * from user_source;

Answer / manojbatra071

create table backuptablename as select * from originaltablename;

Write a sql query to get the third highest salary of an employee from employee_table?

0 Answers  

Why is a trigger used?

0 Answers  

how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 Answers  

How do sql databases work?

0 Answers  

How to use boolean type in select statement?

0 Answers  

What is window clause?

1 Answers   TCS,

What is a stored procedure ?

9 Answers  

What is Difference Between delete and Truncate?

9 Answers  

How pl/sql source code can be protected?

3 Answers  

What is audit logout in sql profiler?

0 Answers  

how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

5 Answers   Honeywell, Interact,

if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 Answers