web analytics
Skip to primary content
Skip to secondary content

MemoSoup

Mix of the things I always forget

MemoSoup

Main menu

  • Home
  • About
  • Links

Tag Archives: long

Oracle: convert LONG to VARCHAR2

Posted on 20/09/2009 by bigspoon
Reply


set serveroutput on

declare
s_sql varchar2(2000);
s_rez varchar2(32767);
begin
s_sql := 'select LONG_COLUMN from SOME_TABLE where ID_COLUMN = 123' ;
execute immediate s_sql into s_rez;

-- print it on the screen or convert/transform/search...
dbms_output.put_line ( s_rez ) ;

end;

Posted in Oracle | Tagged convert, long, Oracle, varchar2 | Leave a reply

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Proudly powered by WordPress