How to specify default values in insert statement using oracle?
how to delete all duplicate records from a table using subquery?
How to define a procedure inside another procedure?
Without giving condition how to retrieve the unmatched records from table.
diff between DELETE and TRUNCATE?.
14 Answers HCL, Yalamanchili Software,
What is the difference between alert log file and tarce file ?
1.display list of all users from ur data base.what is the query?
Why we choose emp number as primarykey?
how to use sequence and what use of sequence cache
what are the advantages of running a database in NO archive log mode?
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?
How to create a new user account in oracle?
Explain joins in oracle?