set long 999 : Long « SQL PLUS Session Environment « Oracle PL/SQL Tutorial






SQL>
SQL> set    long 999
SQL>
SQL> select view_name, text
  2  from   user_views
  3  where rownum < 50;

VIEW_NAME                      TEXT
------------------------------ ------------------------------------------
APPLICATION_USERS              select "UNAME","PW","ROLE_TO_GRANT" from a
                               pplication_users_tbl

AUTHOR_PUBLICATION             SELECT author.id,
                                      author.name,
                                      publication.title,
                                      publication.written_date
                               FROM   author,
                                      publication
                               WHERE  author.id = publication.id

AVG_EVALUATIONS                select course
                               ,      avg(evaluation) as avg_eval
                               from   registrations
                               group  by course

COURSE_DAYS                    select   e.empno
                               ,        e.ename
                               ,        sum(c.duration) as days

VIEW_NAME                      TEXT
------------------------------ ------------------------------------------
                               from     registrations  r
                                        join courses   c on (c.code  = r.
                               course)
                                        join employees e on (e.empno = r.
                               attendee)
                               group by e.empno
                               ,        e.ename

CRS_COURSE_SCHEDULE            select o.course as course_code, c.descript
                               ion, o.begindate
                               from   course_schedule o
                                      join
                                      courses   c
                                      on (o.course = c.code)

CRS_OFFERINGS                  select o.course as course_code, c.descript
                               ion, o.begindate
                               from   offerings o
                                      join

VIEW_NAME                      TEXT
------------------------------ ------------------------------------------
                                      courses   c
                                      on (o.course = c.code)

DEPT20_V                       select "EMPNO","ENAME","INIT","JOB","MGR",
                               "BDATE","MSAL","COMM","DEPTNO" from employ
                               ees where deptno=20

DEPT_OR                        select deptno, dname, loc,
                                      cast ( multiset (
                                              select empno, ename, job, m
                               gr, hiredate, sal, comm
                                                from emp
                                               where emp.deptno = dept.de
                               ptno )
                                             as emp_tab_type )
                                 from dept

EMP_V                          select empno , ename, job,mgr,
                                      audit_trail_pkg.record( empno, 'sal

VIEW_NAME                      TEXT
------------------------------ ------------------------------------------
                               ', sal ) sal,
                                      audit_trail_pkg.record( empno, 'com
                               m', comm ) comm,
                                      audit_trail_pkg.record( empno, 'hir
                               edate', hiredate ) hiredate,
                                      deptno
                                 from emp

EMP_VIEW                       select ename, empno from emp
                               where ename = sys_context( 'userenv', 'cli
                               ent_info')

HRC_ORG_SITE                   SELECT h.hrc_code,hrc_descr,
                                        o.org_id,org_short_name,org_long_
                               name,
                                        os.site_no,site_descr
                                 FROM org_site_tab os,org_tab o,hrc_tab h
                               ,site_tab s
                                 WHERE os.org_id =o.org_id

VIEW_NAME                      TEXT
------------------------------ ------------------------------------------
                                 AND o.hrc_code =h.hrc_code
                                 AND os.site_no =s.site_no

SALES_BY_ATLAS_V               SELECT "PRODUCT_NAME","SALESPERSON","ORDER
                               _DATE","QUANTITY" FROM   product_order WHE
                               RE  salesperson = 'CA'

SALES_PER_PERSON_V             SELECT pers.first_name || ' ' || pers.last
                               _name SALESPERSON,
                                      purc.product_name,
                                      purc.order_date,
                                      purc.quantity
                               FROM   person   pers,
                                      product_order purc
                               WHERE  pers.person_code = purc.salesperson
                                (+)

USER_AVAIL_TRACE_FILES         select "USERNAME","FILENAME","DT" from ava
                               il_trace_files where username = user

VIEW_NAME                      TEXT
------------------------------ ------------------------------------------


14 rows selected.

SQL>








29.13.Long
29.13.1.LONG controls how much of a LONG or CLOB sqlplus displays by default
29.13.2.Set long
29.13.3.set long 999
29.13.4.set long 50000