Mega Code Archive
Set long 999
<![CDATA[
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>
]]>