Oracle SQL Developer

Main functionality

Installing

choco feature  enable -n=useRememberedArgumentsForUpgrades
choco install -y oracle-sql-developer --params "/Username:whoAmI /Password:andWhatIsMyPassword"

No Oracle Home required

Command line

Startup arguments

Code templates

Some keyboard shortcuts

Configuring SQL Developer

set serveroutput on

F5 vs F9

Column order

Snippets

Adminstering Oracle REST Data Services

java -jar ords.war user adminlistener "Listener Administrator"

SQLDEV:GAUGE

with params as (
   select
           0 min_ ,
         100 max_ ,
          33 low_ ,
          67 high_
    from dual
),
val as (
  select  80 ue from dual union all
  select  11 ue from dual union all
  select  42 ud from dual union all
  select  98 ue from dual union all
  select  27 ue from dual
)
select
  'SQLDEV:GAUGE:'  ||
    p.min_  || ':' ||
    p.max_  || ':' ||
    p.low_  || ':' ||
    p.high_ || ':' ||
    val.ue                 "Column name for a wide output."
from
  params p cross join
  val    val;

create table tq84_sqldev_gauge (
  vc varchar2(10),
  num number
);

insert into tq84_sqldev_gauge values('ABC',  66);
insert into tq84_sqldev_gauge values('DEF',  42);
insert into tq84_sqldev_gauge values('GHI',  17);
insert into tq84_sqldev_gauge values('JKL', 100);
insert into tq84_sqldev_gauge values('MNO',  24);

select
  vc,
  'SQLDEV:GAUGE:0:101:33:67:' || num 
from
  tq84_sqldev_gauge
order by
  vc;

User preference settings

Exporting data

select /*insert*/ col_1, col_2, col_3 from xyz;

select col_1, col_2, col_3 /*insert*/ from xyz;

Playing sound when statement or script is done

begin
   dbms_lock.sleep(10);
end;
/

host powershell -noProfile -c $sapi = new-object -com sapi.spVoice; $null = $sapi.speak('The script has finished')

TODO

info+ TABLE_NAME

include "std.arbori"

prelude: runOnce -> {

    print("Hello");

    var ConnectionResolver = Java.type('oracle.dbtools.db.ConnectionResolver');
    var connectionList     = ConnectionResolver.getConnectionNames();

    for (var i in connectionList ) {
       print(connectionList[i]);
    }

//  Connection conn = (Connection) DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORA19", "rene", "rene");
    var conn = ConnectionResolver.getConnection('IdeConnections%23Ora19');

    if (conn == null) {
       print("conn == null");
    }
    else {

        var stmt = conn.createStatement();
        var rs = stmt.executeQuery("select object_name, created from user_objects");
        while( rs.next() ) {
            print(rs.getString(1) + ": " + rs.getString(2));
        }
    }
}

See also