Display or show sql statement creater view in Oracle 10g

Posted on 2008-11-08
Last Modified: 2013-12-19
I created a view with Sql statement but I want to see again this sql statement for that view from Sql Plus

Can any body help me ?

Give me a correct answer amf get 500 point from me
Question by:interbus
    LVL 15

    Accepted Solution

    SELECT dbms_metadata.get_ddl('VIEW', 'VIEW_NAME')
    FROM dual;


    Author Comment


    Thank you for answer but there a problem

    When I using dbms_metadata this is not display the full create statement only part, therefore how I can display the all create statement ?
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    >When I using dbms_metadata this is not display the full create statement only part
    AFAIK, it does return the full create  statement. can you show us how you used it?

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now