Howdy Jeff, informative and interesting video. Like many RDBMS videos connectivity is assumed. Most Java developers like myself are not Oracle DBAs and so debugging attempts to connect using something like sqlcl is a mystery. Case-in-point: you start off your video by starting sqlcl using your own script. It would be very beneficial to those of us the uninitiated what are the contents of your script discounting PWs. Apparently, sqlcl has a way of setting the TNS locations but no doco or examples of how to do this. Assuming your audience can connect is baffling to a very frustrated audience.
you would connect just like you would connect using SQL*Plus or SQL Developer. We look for the TNS locations just like SQL*Plus does. You can use > SHOW TNS to see where we're looking and what entries we find and thus are avail for a connection. Since you're a java developer, you might be more comfortable connecting with an Oracle jdbc URL. I usually connect with direct connect syntax, ./sql hr/oracle@localhost:1521/orcl
Holy hell, I did not not know about that /*csv*/ hint, I assume that's specific to SQL Developer? I hate how SQL*Plus always uses max column length by default and I have to format the column widths. Well this new formatting looks nice, just make the column header text black if it's gonna be on a white background. Some QoL changes for SQL*Plus have been long overdue, hello it's 2015, the command line can still be sexy :D Jeff, the one thing I would love for SQL Developer above all others is the ability to reconnect to an existing session if my SQL Developer/Java crashes. Say for example I started an update on 10mil rows, SQL Developer crashes midway for some reason, I could log back in using the same credentials, and a popup would say something like 'we found another existing session for that user, would you like to resume it?'
To download SQLcl, go here www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-41ea-2372780.html For step by step install instructions, go here www.thatjeffsmith.com/archive/2014/12/sdsql-installing-and-connecting-with-our-new-command-line-interface-to-oracle-database/ This is an early adopter release. If you have any questions or need help, please consult the OTN Community Space here community.oracle.com/community/database/developer-tools/sql_developer/
Jeff Thanks the sql syntax should be as stated below: sql id/pw@hostname:1521/SID the step by step install was great! please update it to the new sql.exe IF only putty was this easy!
I'm not able to reproduce your sql history recall issue +David D. Do you have this week's build? Please share your feedback to our SQL Developer OTN Community Forum.
Doesn't seem to be much documentation from what I can see, although that's not surprising given how new it is. I'm getting java errors when attempting to launch the sql.exe from cmd on my win7-64 machine. Do you have any suggestions on how to set the sql.bat to include a proper java_home...or if that isn't the issue, what would you suggest?
if you run java -version from a cmd window, what do you see? For now, all of the help is command related via the HELP command inside the application, the official docs are being worked on now.
@@JeffSmiththat so.. "oracle sql developer" can create Excel with "mouse click-click-click", but not in "automated mode"? does it have "macro recorder"? you know computers are for "automation"..
Thanks a lot Jeff , wanted something like this really bad. But what I really wanted is just a bat file when clicked would spool a report in .csv file . I am using the below command in a bat file to connect but how do I spool and write it directly to a file ?? Any help would be greatly helpful. cd C:\Users\username\Desktop\sqlcl\sqlcl\bin sql username/pwd@//hostname:1521/service_name
Howdy Jeff, informative and interesting video. Like many RDBMS videos connectivity is assumed. Most Java developers like myself are not Oracle DBAs and so debugging attempts to connect using something like sqlcl is a mystery. Case-in-point: you start off your video by starting sqlcl using your own script. It would be very beneficial to those of us the uninitiated what are the contents of your script discounting PWs. Apparently, sqlcl has a way of setting the TNS locations but no doco or examples of how to do this. Assuming your audience can connect is baffling to a very frustrated audience.
you would connect just like you would connect using SQL*Plus or SQL Developer. We look for the TNS locations just like SQL*Plus does. You can use > SHOW TNS to see where we're looking and what entries we find and thus are avail for a connection. Since you're a java developer, you might be more comfortable connecting with an Oracle jdbc URL. I usually connect with direct connect syntax, ./sql hr/oracle@localhost:1521/orcl
Holy hell, I did not not know about that /*csv*/ hint, I assume that's specific to SQL Developer? I hate how SQL*Plus always uses max column length by default and I have to format the column widths. Well this new formatting looks nice, just make the column header text black if it's gonna be on a white background. Some QoL changes for SQL*Plus have been long overdue, hello it's 2015, the command line can still be sexy :D
Jeff, the one thing I would love for SQL Developer above all others is the ability to reconnect to an existing session if my SQL Developer/Java crashes. Say for example I started an update on 10mil rows, SQL Developer crashes midway for some reason, I could log back in using the same credentials, and a popup would say something like 'we found another existing session for that user, would you like to resume it?'
To download SQLcl, go here
www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-41ea-2372780.html
For step by step install instructions, go here
www.thatjeffsmith.com/archive/2014/12/sdsql-installing-and-connecting-with-our-new-command-line-interface-to-oracle-database/
This is an early adopter release. If you have any questions or need help, please consult the OTN Community Space here
community.oracle.com/community/database/developer-tools/sql_developer/
Try downloading again. We just rev'd the tool.!
Jeff Thanks the sql syntax should be as stated below:
sql id/pw@hostname:1521/SID
the step by step install was great! please update it to the new sql.exe
IF only putty was this easy!
Yeah I need to!!
FYI, the download link is a 404 now.
Sorry Will, you can go here
www.oracle.com/technetwork/developer-tools/sqlcl/downloads/index.html
I'm not able to reproduce your sql history recall issue +David D. Do you have this week's build? Please share your feedback to our SQL Developer OTN Community Forum.
Doesn't seem to be much documentation from what I can see, although that's not surprising given how new it is. I'm getting java errors when attempting to launch the sql.exe from cmd on my win7-64 machine. Do you have any suggestions on how to set the sql.bat to include a proper java_home...or if that isn't the issue, what would you suggest?
if you run
java -version
from a cmd window, what do you see?
For now, all of the help is command related via the HELP command inside the application, the official docs are being worked on now.
may i run sql and export result to XLS? from command line? without mouse clicks?
Excel (XLSX) files, no. But CSV, which Excel can then easily open? Absolutely YES. And no mouse clicks required.
so the answer is NO. why they created this Bad Version of sqlplus ?
@@stalin200000 spooling a zipped/XML file - for what gain? CSV is just the beginning, we support json, inserts, xml, and more.
@@JeffSmiththat so.. "oracle sql developer" can create Excel with "mouse click-click-click", but not in "automated mode"? does it have "macro recorder"? you know computers are for "automation"..
@@stalin200000 consider your Enhancement Request filed, thanks for your input
I am using Putty, why are my column headings not displaying. The records are all displaying, but the not the column headings.
not sure, I don't use Putty. leave a note on the Community Forums and a dev can take a look at it
Thanks a lot Jeff , wanted something like this really bad. But what I really wanted is just a bat file when clicked would spool a report in .csv file . I am using the below command in a bat file to connect but how do I spool and write it directly to a file ?? Any help would be greatly helpful.
cd C:\Users\username\Desktop\sqlcl\sqlcl\bin
sql username/pwd@//hostname:1521/service_name
yeah you can do that, in your .bat file open sqlcl and pass it a script file that does what you want, it'll spool the the CSV
hey my name is lemuel and unable to unzip a zipped folder to install software.please could any one help
Jeff Smith
Any plans to introduce a linux client ?
how you mean, a linux client? SQLcl and SQL Developer both run great on Linux
wat you say?
ever heard about sqlplus?
so this is just another bad version of sqlplus?
No, it's what sqlplus would be if it were built today.