How to count duplicated values in a column in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
How do I escape a reserved word in oracle?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?
What is the relationship among database, tablespace and data file?
How to create id with auto_increment on oracle?
What is flashback in Oracle?
What is a nested table?
How to use "in" parameter properly?
What is a deadlock in SQL? How can you prevent it?
WHT ARE THE AGGREATE FUNCTIONS?
Explain the difference between a procedure and a function?
In oracle there is column command, how will you explain that?