Home » RDBMS Server » Server Administration » How can I to select long column with sql*plus
How can I to select long column with sql*plus [message #375083] Tue, 24 July 2001 22:37 Go to next message
mhy
Messages: 15
Registered: March 2001
Junior Member
sir,
I want to find the definition of a view,when I use the clause "select text from user_views where ..." because the type of column text is LONG ,
I can't see the full content of the definition.can you help me?

Report message to a moderator

Re: How can I to select long column with sql*plus [message #375085 is a reply to message #375083] Wed, 25 July 2001 02:35 Go to previous messageGo to next message
Cindy
Messages: 88
Registered: November 1999
Member
Use spool to pull data into a file then ftp to your local PC and convert/open the file with excel, then save the files as excel.

Report message to a moderator

Re: How can I to select long column with sql*plus [message #375086 is a reply to message #375083] Wed, 25 July 2001 02:38 Go to previous message
GIRIDHAR KODAKALLA
Messages: 92
Registered: May 2001
Member
Hai,
just type
SET LONG 100000.
we change the long default value in sqlplus.
and re run the query.
Giridhar
==

Report message to a moderator

Previous Topic: Re: SQLPLUS On Linux, Command to quit from its Buffer i.e. go through 'ed'
Next Topic: case studies
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 10:08:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.