How to use subqueries with the exists operator in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
When do I need to use a semicolon vs a slash in oracle sql?
what is the syntax of SELECT command?
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?
What are the factors causing the reparsing of SQL statements in SGA?
what is the difference between dbms and rdbms?
why pl sql doesn't support retrieving multiple records
What is the difference between substr and instr?
What is a materialised view?
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
What is a package in oracle?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
How do you ensure database security?