How to check the server version in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
Where is the export dump file located?
How to retrieve first and last records from a table?
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 7 2 4 NULL NULL 5 NULL 3 NULL NULL
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?
why can't we assign not null constraint as table level constraint
How to delete a column in an existing table in oracle?
how to retrive xml data for using sql query?
Please explain compound trigger in oracle?
What do you mean by a deadlock?
How do you tell what your machine name is and what is its IP address?
Explain table?