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 |
Maximum how many triggers can be updated in table ?
5 Answers Accenture, Cap Gemini,
How to get a list of all background sessions in the database?
How to call a trigger inside a stored procedure?Give an example.
how to use sequence and what use of sequence cache
You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
Can we create more than one index on particular column?
how to i write the query 'NISHI' TO N I S H I
4 Answers Attra, Metric Stream,
What are the data types in oracle?
How to return top 5 rows in oracle?
How do I know if oracle client is installed on windows?
select statement does not retrieve any records. what exception is raised?
what is the syntax of update command?