Answer / ashu_deepu

2 NULL value can not b equal.

i just want to remind some imp. point about primary key.
d condition is
1) not null n
2) unique.
since 2 null value r unique dats why we require the 1st point of not null.

Answer / nhajare

Hi,
If you comapare null=null then it return 0 rows selected.
Check the result of this query...

select * from table_name where null=null;

Answer / sandeep kumar

select * from dual where null=null

no row return

Answer / naidu

NOT EQUAL AND AGAIN ANSWER IS NULL

Answer / kishore vakiti

select * from emp where null is null;

Answer / abhishek jaiswal

Decode will return true if we compare null to null value.
select decode(commission_pct,null,0) from employees

Answer / divi

Null is not equal to Null
Nor
Null is equal to Null

Answer / sureka

set serveroutput on;
DECLARE
D INTEGER :=NULL;
E INTEGER :=NULL;
BEGIN
IF (D = E) THEN
dbms_output.put_line('PASS');
ELSIF (D <> E) THEN
dbms_output.put_line('FAIL');
ELSE
dbms_output.put_line('NA');
END IF;
END;

will return NA

Answer / archana

begin
if null is null then
dbms_output.put_line('null');
else
dbms_output.put_line('not null');
end if
end;

now it will return null
it is recommended to use 'is' with null not ' ='

Answer / kuldeep123

DECLARE
v1 NUMBER;
v2 NUMBER;
BEGIN
IF v1 = v2
THEN
DBMS_OUTPUT.put_line ('Null comapred successfully');
ELSE
DBMS_OUTPUT.put_line ('oops u have to use ISNULL opeartor');
END IF;
END;


output : oops u have to use ISNULL opeartor

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  

Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL

1 Answers   Societe Generale,

What are the advantages of pl sql over sql?

0 Answers  

Explain the difference in execution of triggers and stored procedures?

0 Answers  

What is PL/SQL table ?

6 Answers  

what is SCALAR Queries?

2 Answers   ITC Infotech,

Is there any restriction on the use of union in embedded sql?

0 Answers  

Can we perform dml in function?

0 Answers  

how to select unique records from a table? : Sql dba

0 Answers  

Do prepared statements prevent sql injection?

0 Answers  

How to execute a stored procedure?

0 Answers  

what is the difference between binary_integer and pls_integer

2 Answers   TCS,