Collections:
Create a Stored Procedure Interactively in Oracle
How To Create a Procedure Interactively in Oracle?
✍: 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.
⇒ Run Stored Procedures Interactively in Oracle
⇐ Export Data to an XML File in Oracle
2019-01-12, 3076🔥, 0💬
Popular Posts:
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...