Logo 
Search:

oracle Interview FAQs

Submit Interview FAQ
Home » Interview FAQs » oracleRSS Feeds
Oracle
Comments: 0

How to create table?

SQL> create table serial_master 2 (serialno varchar2(3) primary key,serialname varchar2(10) check (serialname like 'K%'), director varchar2(10), timeinindia date);
Posted By:Shruti Sharma      Posted On: Dec 15

Oracle
Comments: 0

How to insert records into tables?

SQL> insert into serial_master (serialno,serialname,director,timeinindia)values('C4','Knkkh','Hemal',to_date('28-Jul-2002 12:59:59 p.m.','DD-MON-YYYY hh:mi:ss p.m.'));
Posted By:Shruti Sharma      Posted On: Dec 15

Oracle
Comments: 0

How to select records?

SQL> select serialno, serialname, director, to_char (timeinindia,'dd-mon-yyyy hh:mi:ss a.m.') from serial_master;
Posted By:Shruti Sharma      Posted On: Dec 15

Oracle
Comments: 0

Name of serial’s name which has been started two year ago.

SQL>select serialname from serial_master where to_char(timeinindia ,'DD-MON-YYYY hh:mi:ss a.m.') <= '05-aug-2000 12:59:59'

SERIALNAME
----------
Kundali
Kmg
Ksbkbthi
Posted By:Shruti Sharma      Posted On: Dec 15

Oracle
Comments: 0

Provide syntax to rename a table

RENAME TO ;
Posted By:Shruti Sharma      Posted On: Dec 17

Oracle
Comments: 0

Provide syntax to truncate a table

TRUNCATE TABLE ;
Posted By:Shruti Sharma      Posted On: Dec 17

1  2  3