Home » SQL & PL/SQL » SQL & PL/SQL » Updating 'LONG' column
Updating 'LONG' column [message #387983] Sun, 22 February 2009 22:49 Go to next message
Derek N
Messages: 80
Registered: September 2002
Member
Hi

I have a table with a 'LONG' column. I now want to use PL/SQL developer or SQL*Plus to display the contents of this column and edit this column. Can this be done with PL/SQL Developer and SQL*PLUS.

If I select this column in PL/SQL Developer it just displays <Long>. If I select in SQL*Plus, it just displays the first few lines.

Thanks
Re: Updating 'LONG' column [message #387985 is a reply to message #387983] Sun, 22 February 2009 22:53 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
SQL> SET LONG 32768

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.

[Updated on: Sun, 22 February 2009 22:53]

Report message to a moderator

Re: Updating 'LONG' column [message #387986 is a reply to message #387985] Sun, 22 February 2009 22:59 Go to previous message
trivendra
Messages: 208
Registered: October 2007
Location: Noida, India
Senior Member
Just adding.

SET LONGCHUNKSIZE 100


complete list

http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch12040.htm#i2699146

Thanks
Trivendra
Previous Topic: Function for getting age in Years / Months / Days (merged)
Next Topic: writing qyery ouput on text file and saving at some specific location of local system
Goto Forum:
  


Current Time: Fri Dec 02 18:50:23 CST 2016

Total time taken to generate the page: 0.08446 seconds