Give an example of any procedure.
- 5 Answers
- 14871 Views
- Accenture, iFlex, Wipro, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
Is sql workbench free?
What will you get by the cursor attribute sql%found?
Is left join faster than join?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Is left join and outer join same?
What is difference between procedure and trigger?
Can a trigger call a stored procedure?
how to create a new view in mysql? : Sql dba
Is sql difficult?
What are the different datatypes available in PL/SQL?
How do I save the results of sql query in a file?
What are all the different types of indexes?
what is difference between delete and truncate commands? : Sql dba
What is linq to sql?
What does stand for in sql?
