In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join.
Answers were Sorted based on User's Feedback
Answer / oracle enthusiastic
The optimizer automatically decides the driving table based on statistics. The join order is immaterial
Is This Answer Correct ? | 0 Yes | 0 No |
What is sequence in sql?
What is PL/SQL Records?
How to write pl sql program in mysql command prompt?
i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent
What is the basic difference between a sql and stored procedure ?
What is the max nvarchar size?
What is the difference between inner join and outer join?
What do you understand by pl/sql packages?
What are tables in sql?
Describe types of sql statements?
declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?
How do I order by ascending in sql?