write a procedure to print a statement or number not
using "dbms_output.put_line" package.write a procedure
instead of it using procdure name as "print"
ex:-
declare
a number:=2;
begin
print(a);
end;
/* when U type above procedure 2 have to should be printed*/
Answer
Is This Answer Correct ? | 3 Yes | 2 No |
What are the attributes of SQL*PLUS ?
Answer
Is This Answer Correct ? | 11 Yes | 0 No |
cursor types? explain with example programs?
Answer
Is This Answer Correct ? | 4 Yes | 1 No |
Question { Cap Gemini, 13991 }
How will you delete a particular row from a Table?
Answer
Is This Answer Correct ? | 2 Yes | 5 No |
how to eliminate null values in a column i.e
table vlaues
1 2 3
NULL 3 4
1 5 NULL
i want output like this
1 2 3
3 4
1 5
i dnt want to use nvl is null and i dnt want replace the
NULL value with any value i.e nvl(col,o);
Answer
Is This Answer Correct ? | 3 Yes | 1 No |
how to find the fifth highest salary?
Answer
Is This Answer Correct ? | 11 Yes | 5 No |