Home » RDBMS Server » Server Administration » package for object desc
package for object desc [message #55025] Fri, 27 December 2002 05:45 Go to next message
Raja
Messages: 57
Registered: March 2000
Member
Hi
is there any package for desc DB objects.Thanx
Re: package for object desc [message #55026 is a reply to message #55025] Fri, 27 December 2002 06:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
what is your exact requirement?
what kind of db objects are u looking intO?
is that in one schema or all the schema?
Re: package for object desc [message #55046 is a reply to message #55025] Mon, 30 December 2002 05:47 Go to previous messageGo to next message
Raja
Messages: 57
Registered: March 2000
Member
if i get the cols and datatype that will do.
do u have diff pack for diff db objects pls explain
thanx
Re: package for object desc [message #55051 is a reply to message #55046] Mon, 30 December 2002 07:28 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
no big deal.
you can easily create a custom package by altering the
foloowing sql as ur need.!~

SQL> show user
USER is "SYS"
SQL> desc mag.emp
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ------------------------------------
 EMPNO                                                 NOT NULL NUMBER(4)
 ENAME                                                          VARCHAR2(10)
 JOB                                                            VARCHAR2(9)
 MGR                                                            NUMBER(4)
 HIREDATE                                                       VARCHAR2(9)
 SAL                                                            NUMBER(7,2)
 COMM                                                           NUMBER(7,2)
 DEPTNO                                                         NUMBER(2)

SQL> ed
Wrote file afiedt.buf

  1  select     column_name "name" ,
  2     decode(nullable,'N','NOT NULL',
  3                          'Y','') "NULL?",
  4     data_type
  5  from dbA_taB_COLUMnS
  6* where owner='MAG' and TABLE_NAME='EMP'
SQL> /

name       NULL?      DATA_TYPE
---------- ---------- ----------
EMPNO      NOT NULL   NUMBER
ENAME                 VARCHAR2
JOB                   VARCHAR2
MGR                   NUMBER
HIREDATE              VARCHAR2
SAL                   NUMBER
COMM                  NUMBER
DEPTNO                NUMBER

8 rows selected.

Previous Topic: ORA-12154 : TNS : Could Not Resolve Sevice Name
Next Topic: Make Oracle Server compatible with citrix server
Goto Forum:
  


Current Time: Thu Sep 19 21:28:26 CDT 2024