Explain the difference between a procedure and a function?
No Answer is Posted For this Question
Be the First to Post Answer
What is a Database instance ? Explain?
How to connect to the server with user account: sys?
Is truncate autocommit in oracle?
How to loop through data rows in the implicit cursor?
What is oracle and what are its different editions?
How to restrict the duplicate records in table valuesets
How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example
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 need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?
what is the use of system.effective.date variable in oracle?
What is raw datatype in oracle?
What is the use of Control File ?