What is the difference between count (*), count (expression), count (distinct expression)?
- 0 Answers
- 547 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What are the commands youd issue to show the explain plan for select
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)
can any one help me with import/export options in oracle............
What is a connect identifier?
What is bulk load in oracle?
What is clustered table in Oracle?
How are extents allocated to a segment?
What is the usage of analyze command in oracle?
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
6. Display the client name and order date for all orders using the traditional method.
How to view existing locks on the database?
Oracle General 
