Improve company productivity with a Business Account.Sign Up

x
?
Solved

Using the User_Views Data Dictionary View

Posted on 2004-09-06
1
Medium Priority
?
853 Views
Last Modified: 2011-10-03
Hi Folks,

   Whenever views are created the select statement through which a particular view is created is saved in the user_views 'TEXT' field and one can always refer it for checking out the code. I have created a particluar view and whenever I query the user_views and try to look at the SELECT statement in the TEXT column, its not displayed fully and is always truncated. I have even changed the line size and page size parameters of SQL*Plus, but it does not work. Am I missing some basic point here?

TIA

Hassan
0
Comment
Question by:hayub
1 Comment
 
LVL 7

Accepted Solution

by:
BobMc earned 400 total points
ID: 11991661
The text column is a long field (at least in 0racle8 which is what I have in front of me) and sqlplus has its own parameter - LONG to tell it how much to display

try this
set linesize 132;
column text format a100 word_wrapped;
set long 4000;
select view_name, text from user_view;

HTH
Bob
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

606 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