Explain joins in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between normal and corelated subqueries?
WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.
How to declare a local variable?
Define Normalization with example?
various types of joins
how to retrieve daily sal from emp table in oracle 10g
Explain what are synonyms used for?
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
What is the usage of merge statement?
Can a formula column referred to columns in higher group ?
How to change program global area (pga) in oracle?
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?