Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Create a Procedure Interactively
How To Create a Procedure Interactively? - Oracle DBA FAQ - Introduction to Oracle SQL Developer
✍: FYIcenter.com
If you want to create a stored procedure interactively, you can use the following steps:
CREATE OR REPLACE PROCEDURE HR.HELLO AS BEGIN DBMS_OUTPUT.PUT_LINE('Hello world!'); DBMS_OUTPUT.PUT_LINE('Welcome to PL/SQL!'); END;
Click the Compile icon. The procedure is created.
2007-04-28, 4845👍, 0💬
Popular Posts:
I have 5 questions please give me the answer ,explanation,suggestions if any?? what is PMP(project m...
What is AL.EXE and RESGEN.EXE? In the previous question you have seen how we can use resource files ...
The following variable is available in file1.c, who can access it? static int average; Answer: all t...
What does a special set of tags <?= and ?> do in a PHP script page? <?= express...
How To Set session.gc_divisor Properly? - PHP Script Tips - Understanding and Using Sessions As you ...