GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Oracle  >  SQL

 Print  |  
Question:  can we insert a record in dual?



June 06, 2008 01:36:58 #1
 ashish88   Member Since: June 2008    Total Comments: 6 

RE: can we insert a record in dual?
 
yes i can insert a record in dual
to use this command
CREATE TABLE DUAL(COL1 VARCHAR(1));
select sysdate from dual
insert into dual values('X')
commit
insert into dual values('X')

to use and show the result


 hope this Help You
Ashish Sharma
     

 

Back To Question