what is correlated subquery
- 3 Answers
- 4384 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / g.v.prasad
It is Another Way of Performing queries upon the data with a
simulation of joins
in this the information from the OUTER SELECT statement
participates as a condition in the INNER SELECT statement
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ruba
outer query is first executed and then outerquery was used
by the inner query
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / naveen
Inner Query refers outer query refers inner Query
we can take an example of Inline View
| Is This Answer Correct ? | 0 Yes | 2 No |
In my table i'm having the duplicate records with sequence number and my requirement is when in new record is coming i want to delete existing old record(onlyone i.e maintaing the partial duplicate date )and add new record
Can we get the deleted Record again if the delete transaction has been committed.
Explain an ORA-01555
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
Name three advisory statistics you can collect.
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
Explain prerequisites and post activities of oracle database installation
How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views
what is domain in database and its benefits?
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
as a technical developer in oracle applications which type errors feced in your experience sofar
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
Oracle General 
