Wednesday Feb 18, 2015

SQL Developerのもっさり感解消

WindowsだけかもしれませんがSQL Developerをしばらく触らずに放置しておいた後、使い始めると反応が少し遅くなる場合があります。
これは "ツール" -> "プレファレンス" -> "環境" -> "ルック・アンド・フィール" の変更で改善する場合があることが知られています。

» Oracle SQL Developer Look and Feels

SQL Developer is a Java Swing desktop application

バージョンによって違うかもしれませんが日本語ダイアローグはこんな感じです。

どうぞお試しください。

Friday Feb 13, 2015

Java version of sqlplus. Checking compatibility...

I felt stupid when I found a small tip for using sqlplus.
If you have a file containing SQL statements and SQL*Plus commands, you can specify this filename on command line after '@'.
What I learned is that it's OK to have space betwen '@' and filename.

$ sqlplus test/oracle @ blah.sql
SQL*Plus: Release 12.1.0.2.0 Production on Fri Feb 13 02:00:10 2015
SYSDATE
---------
13-FEB-15

This enables using filename completion function (Hit TAB) in shells like bash,PowerShell.
Had I learned this 10 years ago, I could have saved probably 1 hour cumulative.

Anyway, I thought this is a good opportunity to try 'Java' version of sqlplus and check
'tip-for-tip compatibility' with native version of sqlplus.

» SQLcl Commands: Info & Info+ – The New DESC?

new SQL*Plus-style command line interface

So, I just untar the stuff on Exadata and ran it. And my 1st compatibility test passed!

$ sqlcl/bin/sql test/oracle @ blah.sql
SQLcl: Release 4.1.0 Beta on Fri Feb 13 02:13:25 2015
Copyright (c) 1982, 2015, Oracle.  All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
SYSDATE
-------------------------------
13-FEB-15

My next compatibility check would be screen size or WINCH signal or STDIN handling
and I expect Java version will behave differently.

About

The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

Search

Categories
Archives
« April 2015
SunMonTueWedThuFriSat
   
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
21
22
23
24
25
26
27
28
29
30
  
       
Today