kuldeep gupta


{ City } mumbai
< Country > india
* Profession *
User No # 125209
Total Questions Posted # 0
Total Answers Posted # 4

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 3
Users Marked my Answers as Wrong # 1
Questions / { kuldeep gupta }
Questions Answers Category Views Company eMail




Answers / { kuldeep gupta }

Question { 9726 }

How pl/sql source code can be protected?


Answer

take procedure or function that u want to wrap
e.g proc_out_data

step 1:- create a sql file and save into a directory.

step 2: go to file location through cmd

step 3: wrap iname=file_name_to_be_wrapped.sql


step4: check a new file is created with same name but extension

file_name_to_be_wrapped.plb

step5:- compile this nely created file's text

step6: your code is now wrapped.

Is This Answer Correct ?    0 Yes 0 No

Question { TCS, 45001 }

What is the result, when NULL is compared with NULL?


Answer

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

Is This Answer Correct ?    0 Yes 0 No


Question { HP, 6232 }

How to find the count of letter "L" in HELLO


Answer

select regexp_count('HEllO','L') from dual;

Is This Answer Correct ?    0 Yes 0 No

Question { Fintellix, 7287 }

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A
Full outer join ( select 1 B from dual Union select 2 B from dual)B
On A.A=B.B


Answer

it will gives result as 1 and null

Is This Answer Correct ?    3 Yes 1 No