select inside a procedure

nandinir · #1 (**permalink**) 07-02-09, 13:51

Will I be able to do a simple select inside a procedure like below-

procedure test
begin
select * from test_table;
end;

or should the select always have an into clause like below -

procedure test
begin
select abc from test_table
into abd;
end;

I'll appreciate any input on this.

Thanks,
Nandinir

LKBrwn_DBA · #2 (**permalink**) 07-02-09, 14:57

Inside a procedure you need the INTO clause.

Code:

abc varchar2(10);
BEGIN
  SELECT col1 INTO abc
     FROM MyTable;
END;
/

PS: I recommend you actually READ the fine Oracle® Database PL/SQL User's Guide and Reference manual.
.

anacedent · #3 (**permalink**) 07-02-09, 21:48

>SELECT col1 INTO abc FROM MyTable;
Use of syntax above limits rows returned to 1.

Internet Services

Web Development

Digital Marketing

Consumer Tech