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: 25578
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: 65154
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: Is it possible?
Next Topic: Execute Immediate Statement with the procedure that contain OUT Mode parameter
Goto Forum:
  


Current Time: Wed Aug 23 03:14:34 CDT 2017

Total time taken to generate the page: 0.04948 seconds