Neeraj yadav

• Oct 3rd, 2011

Code
SELECT   *  INTO 
tablename_2 FROM tablename_1

OR can pass clause also........................

Code
SELECT   *  INTO 
tablename_2 FROM tablename_1
WHERE  VNO='CV/2011/12'

gsmanvi

 Profile Answers by gsmanvi Questions by gsmanvi

• Jun 27th, 2008

declarecursor cursor_name isselect col1,col2,col3from tab_name;ab_record cursor_name%rowtype;beginopen cursor_name;loopfetch ab_record into cursor_name;exit when cursor_name%notfound;insert into tab_n...

Answer Question  Select Best Answer

The Primary function of the redo log is to record all changes made to data.

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• May 21st, 2008

Oracle maintains logs of all transactions against the databse. These transactions are recorded in files called Online Redo log files.These logs are used to recover the database's transaction in their ...

sujeshm

 Profile Answers by sujeshm Questions by sujeshm

• Feb 27th, 2006

Redo log is a part of physical structure of oracle. its basic function is to record all the changesmade to daatabase information. wheneveer an abnormal shutdown take place preventing system to update the database, changes can be obtained from redolog and hence the changes are not lost.

Answer Question  Select Best Answer

Every ORACLE database has one or more physical data files. A database's data files contain all the database data. The data of logical database structures such as tables and indexes is physically stored in the data files allocated for a database.

sendhur

• Mar 15th, 2007

The data of logical database, say tables,indeses etc are stored in datafile.they can be associated with only one database. once created their size can not be altered. but we can add new data file to the table space.

Priya

• Sep 25th, 2006

Actually we can alter the size of the datafile by using the below syntaxSyntax :ALTER DATABASE DATAFILE RESIZE ;

Answer Question  Select Best Answer