Home » SQL & PL/SQL » SQL & PL/SQL » View Text
View Text [message #18763] Wed, 13 February 2002 09:29 Go to next message
Arpit
Messages: 99
Registered: March 2001
Member
Hello All,

I had created a view long way back and need to know what were the criterias i'had defined while creating the view.

Can someone please help me as to how i can view the "text" of the view.

If i do a select on the text field from the "user_views" table, I do not get the complete text.

Your help on this at the earliest would be higly appreciated.

Thanks!
Alpesh

Report message to a moderator

Re: View Text [message #18764 is a reply to message #18763] Wed, 13 February 2002 09:47 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
Use the USER_SOURCE view.

Report message to a moderator

Previous Topic: HOST() command in PL/SQL ?
Next Topic: How can you keep your SQL Session active?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 17:20:33 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.