Luise, Marco (1976). "A global theory of visual signals: Part I". Vision Research 16, pp. 267–278. .
Luise, Marco (1977). "A global theory of visual signals: Part II". Vision Research 17, pp. 895–902. .
Luise, Marco (1977). "A global theory of visual signals: Part III". Vision Research 17, pp. 1467–1476. .
Category:1936 births
Category:Living people
Category:German physicistsQ:
Oracle SQL Procedure get value from table
How to get selected value from sql procedure
I have table Table1 with column COLUMN1, COLUMN2 and COLUMN3
How to get the value in the COLUMN1 when I select it?
Code example (table and procedure):
CREATE TABLE table1 (
COLUMN1 VARCHAR2(20),
COLUMN2 VARCHAR2(20),
COLUMN3 VARCHAR2(20)
);
CREATE OR REPLACE PROCEDURE MyProc()
AS
CURSOR MyCursor IS
SELECT * FROM table1;
var_myCursor MyCursor;
BEGIN
OPEN var_myCursor FOR
SELECT * FROM table1;
FETCH var_myCursor INTO
var_Column1, var_Column2, var_Column3;
CLOSE var_myCursor;
END;
So I need to get the value of COLUMN1 from procedure when I get it.
A:
Create a collection of the data that you need.
DECLARE
l_cursor be359ba680
Related links: