Home » Other » Training & Certification » Where it stored
Where it stored [message #265910] Fri, 07 September 2007 17:02 Go to next message
devswami
Messages: 4
Registered: September 2007
Location: Schaumburg
Junior Member

Hi,everybody

I want to know when you create procedure,sequence,trigger,constraints then where acxtuly they stores means in which table in database.

Please give answer A.S.A.P.

Thanks in advance.

Regards

Dev

[Updated on: Fri, 07 September 2007 17:02]

Report message to a moderator

Re: Where it stored [message #265915 is a reply to message #265910] Fri, 07 September 2007 17:53 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>Please give answer A.S.A.P.

You can have your answer good, fast, or cheap.
Pick any 2 from above list.
Re: Where it stored [message #265944 is a reply to message #265910] Sat, 08 September 2007 01:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DICT contains the list of dictionary views:
SQL> desc dict
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 TABLE_NAME                                VARCHAR2(30)
 COMMENTS                                  VARCHAR2(4000)

DBA_VIEWS contains the TEXT of the views:
SQL> desc dba_views
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 OWNER                            NOT NULL VARCHAR2(30)
 VIEW_NAME                        NOT NULL VARCHAR2(30)
 TEXT_LENGTH                               NUMBER
 TEXT                                      LONG
 TYPE_TEXT_LENGTH                          NUMBER
 TYPE_TEXT                                 VARCHAR2(4000)
 OID_TEXT_LENGTH                           NUMBER
 OID_TEXT                                  VARCHAR2(4000)
 VIEW_TYPE_OWNER                           VARCHAR2(30)
 VIEW_TYPE                                 VARCHAR2(30)
 SUPERVIEW_NAME                            VARCHAR2(30)

Now you have all the elements necessary to answer your question.

You can also read:
OracleŽ Database Reference
Part II Static Data Dictionary Views

Regards
Michel
Re: Where it stored [message #266096 is a reply to message #265910] Sun, 09 September 2007 12:46 Go to previous messageGo to next message
marcosbr
Messages: 24
Registered: April 2007
Location: Argentina
Junior Member
I had the same question when I stared with Oracle9i, but the concepts are the same now for oracle9i or oracle10g.

You have to learn about schema and schema object concepts, please review you administrator guide.

So, if you have login with Sys user and you have created a table “MyNewTable”, you have to go to the administration console and enter in Sys schema in table, and you will find it.

Otherwise, if you have created a table when you were login with SH user, you have to find your table using the administration console inside the SH schema, in tables.

I guess it explain your doubt, let me know.

Cheers

Marcos
Re: Where it stored [message #266097 is a reply to message #265910] Sun, 09 September 2007 13:00 Go to previous messageGo to next message
marcosbr
Messages: 24
Registered: April 2007
Location: Argentina
Junior Member
me again..,
i guess my response was wrong.., follow the Michel's answer.

Marcos
Re: Where it stored [message #266123 is a reply to message #265910] Sun, 09 September 2007 22:19 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

About Constratints,
dba_constraints.
About procedure,
dba_procedures
About triggers,
dba_triggers

Suppose You can get trigger_body by ,


SQL> select trigger_body from dba_triggers where rownum=1;

TRIGGER_BODY
---------------------------------------------------------

-----------------------
DECLARE
  prop_count  NUMBER;
BEGIN
  SELECT count(*) into prop_count
    FROM s

Re: Where it stored [message #266422 is a reply to message #265910] Mon, 10 September 2007 18:46 Go to previous message
devswami
Messages: 4
Registered: September 2007
Location: Schaumburg
Junior Member

Hi,Everyone

Thank you very much for your response.

Take Care.

Bye....

regards
Dev

[Updated on: Mon, 10 September 2007 18:47]

Report message to a moderator

Previous Topic: 147 Study Material
Next Topic: Doubts in trigger (merged by LF and MC)
Goto Forum:
  


Current Time: Sun Dec 04 18:57:21 CST 2016

Total time taken to generate the page: 0.08286 seconds