can you call insert/update/delete in select statements. If
yes how? If no what is the other way?
- 2 Answers
- 6453 Views
- I also Faced
- E-Mail Answers
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 |
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
what are views?
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
What is an Index ?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
How to use subqueries with the exists operator in oracle?
When system tablespace is created?
Describe an oracle table?
Explain view?
What is the scope of a local variable?
How do we get field detail of a table?
What is user managed backup in Oracle?
Oracle General 
