-
SELECT Statement in CASE
How to use select statement in Case?
-
Handle Multiple Rows Without Loops
How can we handle multiple rows without using loops in PL SQL?
-
Multi Row Sub-Queries
Query 1. SELECT sal FROM emp e WHERE sal < any (SELECT sal FROM empWHERE empno=e.mgr) (o/p:11 row) Query 2. SELECT SAL FROM emp e WHERE sal < any (SELECT sal FROM empWHERE mgr=e.empno) (o/p:1 row) What is the difference between the above 2 queries.
-
AND - OR Operators
In the combination of Logical Operators - AND, OR (more than 2) operators which one gets 1st preference.
-
Function return more than one value
Hi,My questions is " Can function return more than one value".I have gone through the all answers relevant to my question was been posted earlier. But all answers are confusing me.Few people said directly that function can't return more than one value and few are telling that function can return more that one value using OUT parameter or ref cursor.My understanding is if out can't use as a parameter...
-
How to find the Foreign keys of all child tables when pass the Parent Table name.
I developed like below.Any experts query ....please send.selecttable_name,constraint_namefrom user_cons_columns where column_name=(select a.COLUMN_NAME from user_cons_columns a,user_constraints bwhere a.TABLE_NAME=b.TABLE_NAME and b.constraint_type in ('P')and a.TABLE_NAME='DEPT')and constraint_name like '%FK%'
-