How to define a variable of a specific record type?
What is DTS and purpose of DTS ?
How to calculate date and time differences in oracle?
how to use sequence and what use of sequence cache
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
what happened to the global index when I truncate the data in one of the partition?
SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me
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 are the different pseudo commands? Explain in general?
What are the benefits of ordbms?
How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10
i want department wise maxmum salary and empolyee name
what is the difference between functional dependecy and multilevel dependency?