Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

Use select into clause to assign value to a varchar2 type variable and output with dbms_output put_line

SQL> -- create demo table SQL> create table emp(   2    ID                 VARCHAR2(4 BYTE)         NOT NULL,   3    fname         VARCHAR2(10 BYTE),   4    lname          VARCHAR2(10 BYTE),   5    Start_Date         DATE,   6    End_Date           DATE,   7    Salary             Number(8,2),   8    City               VARCHAR2(10 BYTE),   9    Description        VARCHAR2(15 BYTE)  10  )  11  / Table created. SQL> SQL> -- prepare data SQL> insert into emp(ID,  fname, lname, Start_Date,                     End_Date ,                       Salary,  City,       Description)   2               values ('01','Jason',    'Martin',  to_date('19960725','YYYYMM DD'), to_date('20060725','YYYYMMDD'), 1234.56, 'Toronto',  'Programmer')   3  / 1 row created. SQL> insert into emp(ID,  fname, lname, Start_Date,                     End_Date ,                       Salary,  City,       Description)   2                values('02','Alison',   'Mathews', to_date('19760321','YYYYMM DD'), to_date('19860221','YYYYMMDD'), 6661.78, 'Vancouver','Tester')   3  / 1 row created. SQL> SQL> SQL> declare   2    empName varchar2(80);   3  begin   4         select fname into empName from emp where rownum = 1;   5         dbms_output.put_line(empName);   6  end;   7  / Jason PL/SQL procedure successfully completed. SQL> SQL> SQL> drop table emp; Table dropped.