Date:12.10.2016, 18:31 Put_line Name: 'v_fname' 'v_lname 13 end; 14 / Name: minnie mee A single row of column values is loaded into the list of variables when multiple columns are selected. The order of the columns and the order of the variables must match when using the SELECT INTO clause. SELECT clause to retrieve all the columns. SQL declare 2 v_author authorrowtype; 3 begin 4 select 5 into v_author 6 from 7 author 8 where 9 author_key 'A103 10 11 dbms_output. Put_line Name: ' v_totalName 11 end; 12 / Name: Withers, Lester The query above is returning a string value created from multiple table columns. The variable v_totalname must be defined as a datatype that can hold the composite string returned by the query. Oracle Database Tips by Burleson Consulting. The SELECT INTO Clause The SELECT INTO clause of SQL is used to retrieve one row or set of columns from the Oracle database. The SELECT INTO is actually a standard SQL query where the SELECT INTO clause is used to place the returned data into predefined variables. Here the author_key was used to retrieve one author's last name and place it in the variable called v_authName. The query can also retrieve an entire row as a record with SELECT INTO.