can you call insert/update/delete in select statements. If
yes how? If no what is the other way?

Answers were Sorted based on User's Feedback



can you call insert/update/delete in select statements. If yes how? If no what is the other way?..

Answer / merly

I dont think so it is possible but we can use a select
statement in insert/update/delete(ie reverse is possible)

Is This Answer Correct ?    0 Yes 1 No

can you call insert/update/delete in select statements. If yes how? If no what is the other way?..

Answer / anonymous

you could use a select for update from a pl/sql or jdbc program

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle General Interview Questions

What is system global area (sga) in oracle?

0 Answers  


What is a Shared SQL pool ?

2 Answers  


How to define a procedure inside another procedure?

0 Answers  


How can we view last record added to a table?

0 Answers  


Explain integrity constraint?

0 Answers  






What is literal?

0 Answers  


Is it possible to split the print reviewer into more than one region ?

0 Answers   Oracle,


What happens if the imported table already exists?

0 Answers  


What is a subquery in oracle?

0 Answers  


How to create id with auto_increment on oracle?

0 Answers  


How do I connect to oracle database?

0 Answers  


Can a formula column be obtained through a select statement ?

0 Answers   Oracle,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)