How to omit columns with default values in insert statement in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
What is bulk collect in oracle?
How to grant create session privilege to a user in oracle?
What happens if you lost a data file?
What is the usage of control file in oracle?
Explain parameter file in oracle.
DBMS vs. RDBMS
Why do we use bulk collect in oracle?
How to rename an existing table?
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
What are a collation and state the different types of collation sensitivity?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6
What are the general rules on data consistency?