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

What is over () in sql?

965

What is sql and explain its components?

1067

What are the ddl commands?

1012

What is procedure function?

1063

What is difference between hql and sql?

1078

What is the difference between in and between in sql?

1061

how to get a list of indexes of an existing table? : Sql dba

960

What is rank dense_rank and partition in sql?

1042

Compare sql & pl/sql

1142

What is pessimistic concurrency control? : Transact sql

1089

how to use 'mysql' to run sql statements? : Sql dba

1053

How to run pl sql program in mysql?

1021

What is the difference between nvl function, ifnull function, and isnull function?

1113

How do I order by ascending in sql?

1023

What are the disadvantages of file system?

1267