Interested to Buy Any Domain ? << Click Here >> for more details...
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*/
- 2 Answers
- 7242 Views
- iFlex, I also Faced
- E-Mail Answers
Answer Posted / amit kumar(patna)
We have to create procedure for print and called the SP for print any message
create or replace procedure print(n varchar)
as
begin
dbms_output.put_line(n) ;
end ;
set serveroutput on
declare
a number;
begin
a:=20;
print(a);
end;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is java sql connection?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
When should I use nosql database?
What is primary key and foreign key with example?
How do I create a memory optimized filegroup?
What are the constraints available in sql?
What is indexes?
What are the benefits of pl/sql packages?
What is the difference between having clause and where clause?
How do I truncate a word?
what is the difference between sql and t-sql? : Transact sql
Explain the insert into statements in sql?
Is sql the best database?
What is a pragma statement?
What is assignment operator in pl sql?
