Script output to file when using SQL-Developer

Posted by Laurent K on Stack Overflow See other posts from Stack Overflow or by Laurent K
Published on 2010-02-10T08:32:53Z Indexed on 2010/05/14 19:54 UTC
Read the original article Hit count: 544

Filed under:

sql-developer

|

sqldeveloper

|

script

|

file

I have a select query producing a big output and I want to execute it in sqldeveloper, and get all the results into a file.

Sql-developer does not allow a result bigger than 5000 lines, and I have 100 000 lines to fetch...

I know i could use SQL+, but let's assume I want to do this in sqldeveloper.

© Stack Overflow or respective owner

Related posts about sql-developer

can't run sqldeveloper on Ubuntu

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I tried to install sqldeveloper by following way: Download SQL Developer from Oracle website (I chose Other Platforms download). Extract file to /opt: sudo unzip sqldeveloper-*-no-jre.zip -d /opt/ sudo chmod +x /opt/sqldeveloper/sqldeveloper.sh Linking over an in-path launcher for Oracle SQL Developer: sudo… >>> More
Oracle Open World 2012: SQL Developer Recap

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Last week was the ‘big show’ in San Francisco. I was very happy to meet many of you in person. And many of you had questions – lots of questions! We had full or overflowing rooms for our sessions and hands-on-labs. The SQL Developer ‘booths’ were also slammed several… >>> More
????????SQL Developer?Data Modeler?????????????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
????? ??:2010/05/18 ??:?????? Oracle ?GUI?????????···??????????????????SQL Developer ? Data Modeler ???????GUI???????????????????????????SQL Developer ? Data Modeler ?????????????????? ????Oracle SQL Developer Data Modeler ??Oracle SQL Developer Data Modeler ????Oracle SQL Developer ???Oracle… >>> More
Ubuntu Launcher doesn't launch [closed]

as seen on Server Fault - Search for 'Server Fault'
I use Ubuntu 11.04 and Gnome 2.32.1. I want to create a new launcher for Sql Developer on the desktop with the following value : Name : SqlDeveloper Command : /bin/sh /opt/sqldeveloper/sqldeveloper.sh Icon : A icon in the directory of sql developer When I click or double-click on the launcher… >>> More
Java????????????????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
????????Java ?????????????? (INOUE Katsumi @ Tokyo)?????????????java.exe???????????? jvm.dll ??????????????????????? ?????????????????4??OOW????????????????????????????????Environment Variables and System Properties - Troubleshooting Guide for HotSpot VMIn many environments the command… >>> More

Related posts about sqldeveloper

can't run sqldeveloper on Ubuntu

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I tried to install sqldeveloper by following way: Download SQL Developer from Oracle website (I chose Other Platforms download). Extract file to /opt: sudo unzip sqldeveloper-*-no-jre.zip -d /opt/ sudo chmod +x /opt/sqldeveloper/sqldeveloper.sh Linking over an in-path launcher for Oracle SQL Developer: sudo… >>> More
Ubuntu Launcher doesn't launch [closed]

as seen on Server Fault - Search for 'Server Fault'
I use Ubuntu 11.04 and Gnome 2.32.1. I want to create a new launcher for Sql Developer on the desktop with the following value : Name : SqlDeveloper Command : /bin/sh /opt/sqldeveloper/sqldeveloper.sh Icon : A icon in the directory of sql developer When I click or double-click on the launcher… >>> More
Getting results in a result set from dynamic SQL in Oracle

as seen on Stack Overflow - Search for 'Stack Overflow'
This question is similar to a couple others I have found on StackOverflow, but the differences are signficant enough to me to warrant a new question, so here it is: I want to obtain a result set from dynamic SQL in Oracle and then display it as a result set in a SqlDeveloper-like tool, just as if… >>> More
Oracle TNS names not showing when adding new connection to sqldeveloper

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I'm trying to connect to an oracle database with sqldeveloper. I've installed the .Net oracle drivers and placed the tnsnames.ora file at C:\Oracle\product\11.1.0\client_1\Network\Admin. I'm using the following format in tnsnames.ora. dev = (DESCRIPTION = (ADDRESS = (PROTOCOL =… >>> More
SQLDeveloper using over 100MB of PGA

as seen on Stack Overflow - Search for 'Stack Overflow'
Perhaps this is normal, but in my Oracle 11g database I am seeing programmers using Oracle's SQL Developer regularly consume more than 100MB of combined UGA and PGA memory. I'd like to know if this is normal and what can be done about it. Our database is on the 32 bit version of Windows 2008, so… >>> More