Mega Code Archive
List view text from user_views
<![CDATA[
SQL>
SQL> set long 999
SQL> column text format a42 word wrapped
SQL>
SQL> select view_name, text
2 from user_views;
VIEW_NAME TEXT
------------------------------ ------------------------------------------
EMP_HQ select "ID","FNAME","LNAME","START_DATE","
END_DATE","SALARY","CITY","DESCRIPTION" fr
om emp
where id = '2'
V select "X" from t
AVG_SAL select trunc(avg(salary)) avg_sal
from emp
EMPDEPT_V select e.empno
, e.ENAME
, e.init
, d.dname
, d.location
, m.ENAME as MANAGER
from employees e
join
departments d using (deptno)
join
VIEW_NAME TEXT
------------------------------ ------------------------------------------
employees m on (m.empno = d.mgr)
DEPT_SAL select dname,round(avg(sal),2) avgSalary
from emp,dept
where emp.deptno = dept.deptno
group by dname
ALL_ORACLE_ERRORS SELECT "ERRNUMBER","MESSAGE" FROM TABLE(Or
acleErrorTable())
INVENTORY_VIE SELECT i.item_id, i.reorder_status, i.pric
e
FROM inventory_tbl i
TOP_EMP SELECT empno, ename, sal
FROM emp
WHERE sal > 2999
EMP_BONUS SELECT dname, empno, ename, sal, sal * .15
VIEW_NAME TEXT
------------------------------ ------------------------------------------
bonus
FROM emp a, dept b
WHERE a.deptno = b.deptno
SHARED SELECT shared_id
, shared_text
FROM shared_all
WHERE NVL(striping_id,0) =
NVL(TO_NUMBER(SUBSTR(USERENV(
'CLIENT_INFO'),1,10)),0)
PHONE_LIST select emp_id, firstname || ' ' || midinit
|| '. ' || lastname as name,'(' || area_c
ode || ')' || phone as telephone#
from emp
11 rows selected.
SQL>
]]>