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
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 |
Answer / anonymous
you could use a select for update from a pl/sql or jdbc program
Is This Answer Correct ? | 0 Yes | 1 No |
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What is the difference between postgresql and oracle?
Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle
How to pass a cursor variable to a procedure?
what are the database links ?
how to do daily transactions with out sql* loader control file regesterd in apps?
How can Oracle users be audited?
What is Rollback Segment ?
I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.
In which language oracle has been developed?
does Oracle has only one table space?
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL