Interested to Buy Any Domain ? << Click Here >> for more details...
what is different between inline query,subquery& corelated
query?
- 8 Answers
- 107002 Views
- Quest, I also Faced
- E-Mail Answers
Answer Posted / sharath
Can we use one subquery in another. I have got a situation
like this
select
(select date from t1) date,
((select date from t1 where t1.col1=table.col1)*7) week,
(((select date from t1) where t1.col1=table.col1)*7)
+start_date) transfer
from table;
Somewhat like this. I needed to know whether the first
subquery can be used in the second subquery and the next
subqueries??Or any hints as such just to make the query
faster??
| Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
What is the disk migration? what is the steps involved in oracle disk migration?
How do you create a credit note against an invoice? : oracle accounts receivable
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
What is auto invoicing? : oracle accounts receivable
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
What is the difference between oracle media recovery and crash recovery?
What is the mandatory setup in cyclecount ?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
