3. Adapt your query in (2) above so that only post codes
with more than twenty orders are displayed.
No Answer is Posted For this Question
Be the First to Post Answer
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
What does ROLLBACK do ?
how to clone 9i Database on to 10g Database.
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 truncate date and get only time part 9:20:00
what is null value?
How to start an oracle instance?
How to define default values for formal parameters?
what is unique key?
14 Answers Amazon, Cap Gemini, Infosys, Wipro,
How view is different from a table?
What is a user account in oracle?
What is oracle rownum?