oracle large query text [message #670146] |
Mon, 11 June 2018 09:48 |
dba4oracle
Messages: 100 Registered: June 2010
|
Senior Member |
|
|
Hi Guys,
I want to test one query,i have sql id,using it i exracted query text its large query may be 65000 + lines
after spooling or extracting text i am not able to run it due to formatting issues like on one line part of column name on next line
as below column department is half up and half on next line (this is just for example ,query which i am using is very large
(select name,id,depart
ment from dept))
I tried using many options like used v$sqlarea,v$sqltext,v$sqltext_on_new_line
tried plsql dbms_output code
but nothing worked
in simple words i want to spool this large query text and run it
or i want to run and check execution of query manually
If you guys faced this please share
Thanks
|
|
|
|
|
|
Re: oracle large query text [message #670150 is a reply to message #670149] |
Mon, 11 June 2018 11:03 |
dba4oracle
Messages: 100 Registered: June 2010
|
Senior Member |
|
|
i used clob,used sql developer,line size 32767 but no option working getting one or other formatting issue like line break
even tried using plsql and - sql line continution character
|
|
|
|
|
|
Re: oracle large query text [message #670156 is a reply to message #670155] |
Tue, 12 June 2018 03:17 |
cookiemonster
Messages: 13943 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
If you are using SQL Developer you really shouldn't have a problem. When the results come up in the grid you should be able to click on the pencil icon on the right of the column and that'll bring up a dialogue box with the full query without line breaks in weird places.
|
|
|
|