SQLcl - the SQL*Plus summation a summation ...
"euphoric: intensely happy or confident", @thatjeffsmith, https://youtu.be/ecgijS76jvw ...
Just watched the video from @thatjeffsmith most SQLcl - together with it is, indeed, worth the time. After looking that video, I'm pretty certain that SQLcl volition supersede SQL*Plus inside months (if unopen to to a greater extent than people 'spread the word').
Just a few keywords to brand you lot curious:
And in that place is a lot more - repeat for example, which repeats a disceptation n times, sleeping t seconds betwixt each execution. Watch the video together with therefore effort SQLcl!
"euphoric: intensely happy or confident" - Yes, I am :-)
Just watched the video from @thatjeffsmith most SQLcl - together with it is, indeed, worth the time. After looking that video, I'm pretty certain that SQLcl volition supersede SQL*Plus inside months (if unopen to to a greater extent than people 'spread the word').
Just a few keywords to brand you lot curious:
- SQLcl is available every bit 'standalone' download, but it is also already part of the latest SQLDeveloper 17.2.0
- SQLcl needs an JRE to run
- To start SQLcl use 'sql' - non 'sqlcl'
- SQLcl has almost all features included, SQL*Plus has (simply piece of employment Your sql scripts inward SQLcl instead of SQL*Plus)
- Once started, type assist together with You'll meet all the novel commands available. For example:
- alias - define aliases for frequently used SQL-Commands
- cd - modify directory when inside SQLcl
- ctas - exactly type 'ctas <table> <new-table>' together with You'll become the consummate syntax for a 'Create Table As Select'. The ctas is loaded into the SQLcl buffer, therefore You could exactly number a '/' together with the code is executed. Ok - You accept to edit the result, because of ORA-02264 errors (Constraint already exists - but thats tardily done past times typing ed to kickoff the editor
- SQLcl eases typing of statements. It tin sack autocomplete column together with tabular array names. Example: Type 'select * from hr.empl<tab>' together with it automatically autocompletes to hr.employees. If to a greater extent than than 1 possibility is available, it lists all ...
- DDL - a ascendency to extract the ddl for a given object
- info - a 'verbose' desc which displays agency to a greater extent than data most an object
- info+ - yes, info+! An fifty-fifty to a greater extent than informational thought on an object. Interestingly, neither information nor info+ are shown when issuing an assist command. But 'help information' volition present how to purpose it.
- history - present the terminal 100 ascendency You'd issued inward SQLcl (customizable to whatever value). Even more: You tin sack purpose history <index> (where index is the number of a sql disceptation inward the history) to charge a sql disceptation inward buffer - execute it past times typing / , edit it (ed) or modify values using the proficient one-time 'c/<old value>/<new value>
And in that place is a lot more - repeat for example, which repeats a disceptation n times, sleeping t seconds betwixt each execution. Watch the video together with therefore effort SQLcl!
"euphoric: intensely happy or confident" - Yes, I am :-)