Re: sqlplus

If you're executing from SQL Plus and have used the 'VARIABLE' command to declare a variable, use 'PRINT' to display it.

e.g.

SQL> variable my_cur refcursor
SQL> begin
  2 open :my_cur for select * from scott.emp;   3 end;
  4 /

PL/SQL procedure successfully completed.

SQL> print my_cur

    EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
--------- ---------- --------- --------- --------- --------- --------- -----

     7369 SMITH CLERK 7902 17-DEC-80 800 20

     7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30

     7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30

     7566 JONES MANAGER 7839 02-APR-81 2975 20

     7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30

     7698 BLAKE MANAGER 7839 01-MAY-81 2850 30

     7782 CLARK MANAGER 7839 09-JUN-81 2450 10

     7788 SCOTT ANALYST 7566 19-APR-87 3000 20

     7839 KING PRESIDENT 17-NOV-81 5000 10

     7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30

     7876 ADAMS CLERK 7788 23-MAY-87 1100 20

     7900 JAMES CLERK 7698 03-DEC-81 950 30

     7902 FORD ANALYST 7566 03-DEC-81 3000 20

     7934 MILLER CLERK 7782 23-JAN-82 1300 10

14 rows selected.

SQL> xyric <xyric_at_wanadoo.fr> wrote in message news:8alf7d$7pt$1_at_wanadoo.fr...
> Hi,
>
> I would like to know if we have to use cursors ( variables cursors) in all
> queries and if there is any way to display theses variables. I tried with
> dbms_output.put_line and it didn't work.
> If using PL/SQL is the same as using a programming language with the SQL
> statements there must be something to display theses variables.
>
>
> Thanks
>
> Dali T.
>
>
>
>
Received on Tue Mar 14 2000 - 00:00:00 CST