Collections:
Define a Variable to Match Column Data Type in Oracle
How To Define a Variable to Match a Table Column Data Type in Oracle?
✍: FYIcenter.com
If you have a table, and want to define some variables to have exactly the same data types as some columns in that table, you can use table_name.column_name%TYPE as data types to define those variables. The tutorial sample below shows you how to do this:
CREATE OR REPLACE PROCEDURE FYI_CENTER AS my_email employees.email%TYPE; my_salary employees.salary%TYPE; BEGIN SELECT email, salary INTO my_email, my_salary FROM employees WHERE employee_id = 101; DBMS_OUTPUT.PUT_LINE('My email = ' || my_email); DBMS_OUTPUT.PUT_LINE('My salary = ' || my_salary); END; / My email = NKOCHHAR My salary = 17000
⇒ Working with Cursors in Oracle PL/SQL
⇐ Update a Table Row with a RECORD in Oracle
2018-08-14, 1550🔥, 0💬
Popular Posts:
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...