Oracle Apps Gurus
Showing posts with label
How to get the create statement of sql view
.
Show all posts
Showing posts with label
How to get the create statement of sql view
.
Show all posts
Monday, August 25, 2008
How to get the create statement of sql view
SELECT owner "view owner name", view_name "view name"
FROM all_views
WHERE view_name = '<< YOURVIEW >>'
SELECT DBMS_METADATA.get_ddl ('VIEW', '<< view name >>',
'<< view owner name >>')
FROM DUAL
Older Posts
Home
Subscribe to:
Posts (Atom)