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?



October 10, 2009 02:05:56 #6
 Rabindra_Kumar   Member Since: October 2009    Total Comments: 6 

RE: can we insert a record in dual?
 

You can perform any DML operations in dual table provided that you have been given the privilege to do so.
However never try to perform any DML operations (delete/insert/update) in dual table because dual is basically used to work with scalar query. If you insert any record into dual table it may stop many running applications

     

 

Back To Question