I have query like this.
select dept_id, max_mark from stude_dept where min_mark=
(select min(mini_mark) from stud_dept);
How can i optimize this query.
Can anyone help me with it
Answer Posted / sudhakar
hi
it gives mini_mark record of max_mark,dept_id
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is Data Dictionary Cache in Oracle?
How to create a stored program unit?
How to unlock the sample user account in oracle?
How to define a specific record type?
how to join query for one source type is oracle another source type is sql server ?
What is the difference between online and offline backups?
What is the difference between I and G in Oracle?
How to loop through data rows in the implicit cursor?
Differentiate between translate and replace?
What is recycle bin in Oracle?
What is define in oracle?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
What are transaction isolation levels supported by oracle?
How to create a new table by selecting rows from another table?
How to define an oracle cursor variable?