List view text from user_views : USER_VIEWS « System Tables Views « Oracle PL / SQL






List view text from user_views

  
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>

   
    
  








Related examples in the same category

1.Query user_views
2.Query user-defined view info from USER_VIEWS table
3.Get all views
4.If view exists, drop view