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, 1615🔥, 0💬
Popular Posts:
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...