Interested to Buy Any Domain ? << Click Here >> for more details...
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN
WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
- 1 Answers
- 5337 Views
- ESS, I also Faced
- E-Mail Answers
can you call insert/update/delete in select statements. If yes how? If no what is the other way?
Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
How to define a variable of a specific record type?
Write a trigger example in oracle?
How to write a left outer join with the where clause in oracle?
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.
How many file formats are supported to export data?
Which is better Oracle or MS SQL? Why?
What is an anonymous block?
What is an oracle tablespace?
How to retrieve values from data fields in record variables?
Oracle General 
