Skip to content
October 19, 2015 / doganay

EXPAND SELECT *

variable x clob
begin
dbms_utility.expand_sql_text(
input_sql_text => 'select * from t1',
output_sql_text => :x
);
end;
/

set long 2000 longc 2000 pages 1000
print x

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: