CREATE OR REPLACE PROCEDURE pro_name AS --We cna write AS/IS BEGIN DBMS

Give an example of any procedure.

Question Posted / sharath

Answer Posted / sharath

CREATE OR REPLACE PROCEDURE pro_name
AS --We cna write AS/IS
BEGIN
DBMS_OUTPUT.PUT_LINE(’Hello World’);
END;

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

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

1100

Why join is faster than subquery?

1043

What is the difference between count 1 and count (*) in a sql query?

908

What is trigger in flip flop?

958

What is substitution variable?

1001

What will you get by the cursor attribute sql%found?

899

What is a common use of group by in sql?

995

What is use of trigger?

873

What is a sql profiler?

961

What is a native sql query?

973

What is right join sql?

920

give the syntax of grant and revoke commands? : Sql dba

1088

What is the starting oracle error number?

996

How do I run a script in sql developer?

899

Is subquery faster than join?

951