Home » SQL & PL/SQL » SQL & PL/SQL » How to get source code for the materalized view created (Oracle 9i)
How to get source code for the materalized view created [message #325521] Fri, 06 June 2008 08:41 Go to next message
VEDDETA
Messages: 54
Registered: May 2008
Member
Can anyone tell me how can I get the source code of materialized view created in database using SQL *PLUS?


Regards,
Veddeta


Re: How to get source code for the materalized view created [message #325522 is a reply to message #325521] Fri, 06 June 2008 08:45 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
VEDDETA wrote on Fri, 06 June 2008 06:41
Can anyone tell me how can I get the source code of materialized view created in database using SQL *PLUS?


Regards,
Veddeta




use DBMS_METADATA
Re: How to get source code for the materalized view created [message #325524 is a reply to message #325521] Fri, 06 June 2008 08:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> create materialized view mv as select * from emp;

Materialized view created.

SQL> select query from user_mviews where mview_name='MV';
QUERY
----------------------------------------------------------
select * from emp

1 row selected.

Regards
Michel
Re: How to get source code for the materalized view created [message #325845 is a reply to message #325524] Mon, 09 June 2008 03:19 Go to previous message
VEDDETA
Messages: 54
Registered: May 2008
Member
This worked fine. Thank you very much Michel.
Previous Topic: Oracle to Excel - Display problem!
Next Topic: Insert data in diff schema
Goto Forum:
  


Current Time: Sun Dec 04 04:48:44 CST 2016

Total time taken to generate the page: 0.16518 seconds