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

how to run 'mysql' commands from a batch file? : Sql dba

1110

What is cursor and its types?

1064

How do I edit a stored procedure?

988

What is dynamic sql in pl sql?

1031

What is sqlca in db2?

949

What are string functions in sql?

1238

How to call a javascript function from pl sql?

1134

what is a composite primary key ? : Sql dba

1049

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1147

What is the purpose of primary key?

1017

What are the parts of a basic sql query?

963

Can we change the table name in sql?

937

What are operators available in sql?

1041

How to use transactions efficiently : transact sql

1054

What is set serveroutput on?

1129