ALTER USER USER1 IDENTIFIED BY "PASS%WORD";

export TWO_TASK=REMOTEDB1
sqlplus USER1/PASS1

sqlplus USER1/PASS1@REMOTEDB1

SELECT DISTINCT ORDER_NO||'-'||LINE_NO, ITEM_NAME
  FROM ORDERS WHERE BUYER_NAME = 'TARO' ORDER BY ORDER_NO, LINE_NO

SELECT DISTINCT ORDER_NO||'-'||LINE_NO, ORDER_NO, LINE_NO, ITEM_NAME
  FROM ORDERS WHERE BUYER_NAME = 'TARO' ORDER BY ORDER_NO, LINE_NO

SELECT DISTINCT ORDER_NO||'-'||LINE_NO, ITEM_NAME
  FROM ORDERS WHERE BUYER_NAME = 'TARO' ORDER BY ORDER_NO||'-'||LINE_NO

CREATE SYNONYM KUDAMONO FOR FRUITS;
GRANT SELECT ON FRUITS TO USER2;

CREATE SYNONYM KUDAMONO FOR USER1.KUDAMONO;
SELECT * FROM KUDAMONO;

SELECT TO_CHAR(255,'FMXXXX') FROM DUAL;

SELECT RTRIM(TO_CHAR(6,'FM999990.999'), '.') FROM DUAL;

SELECT ORDER_NO, LINE_NO
  FROM ORDERS
 ORDER BY ORDER_NO, CONVERT(LINE_NO, 'JA16EBCDIC930');

SELECT ID, NAME, AGE FROM EMPS
 WHERE AGE = (SELECT MIN(AGE) FROM EMPS)

SELECT ID, NAME, AGE FROM (
  SELECT ID, NAME, AGE, ROW_NUMBER() OVER (ORDER BY AGE) RN FROM EMPS
) WHERE RN = 1

SELECT ID, NAME, AGE FROM EMPS WHERE ROWNUM = 1;

SELECT ID, NAME, AGE FROM
 (SELECT ID, NAME, AGE FROM EMPS ORDER BY AGE) WHERE ROWNUM = 1;

SELECT ID, NAME, AGE,
       ROW_NUMBER() OVER (PARTITION BY DEPT_NO ORDER BY AGE) RN FROM EMPS

ORDER_NO | OTODOKESAKI
-----------------------------------
00012345 | 横浜市西区南幸z-z-zz
00012345 | 新潟市中央区柳島町z-z-zz
00034567 | 横浜市西区南幸z-z-zz
00034567 | 新潟市中央区柳島町z-z-zz
00034567 | 大阪市淀川区西中島z-z-zz
...

ORDER_NO | お届け先1            | お届け先2                | お届け先3
------------------------------------------------------------------------------------
00012345 | 横浜市西区南幸z-z-zz | 新潟市中央区柳島町z-z-zz | 
00034567 | 横浜市西区南幸z-z-zz | 新潟市中央区柳島町z-z-zz | 大阪市淀川区西中島z-z-zz

SELECT a.ORDER_NO,
       MAX(CASE WHEN a.RN = 1 THEN a.OTODOKESAKI ELSE NULL END) AS OTO1,
       MAX(CASE WHEN a.RN = 2 THEN a.OTODOKESAKI ELSE NULL END) AS OTO2,
       MAX(CASE WHEN a.RN = 3 THEN a.OTODOKESAKI ELSE NULL END) AS OTO3,
       MAX(CASE WHEN a.RN = 4 THEN '他' ELSE NULL END)          AS OTO4
  FROM
(SELECT ORDER_NO, OTODOKESAKI,
        ROW_NUMBER() OVER (
          PARTITION BY ORDER_NO ORDER BY DELIVERY_DATE ) AS RN
   FROM DELIVERY_DB) a
 GROUP BY a.ORDER_NO

DECODE(COL1, '1', NULL, '2', 100, 200)

SELECT b.NAME, b.TYPE, MAX(TO_CHAR(a.LAST_DDL_TIME, 'YYYY/MM/DD HH24:MI:SS')),
       MAX(b.LINE), SUM(LENGTHB(b.TEXT))
  FROM USER_OBJECTS a, USER_SOURCE b
 WHERE a.OBJECT_NAME = b.NAME
   AND a.OBJECT_TYPE = b.TYPE
 GROUP BY b.NAME, b.TYPE
 ORDER BY b.NAME, b.TYPE

SELECT DISTINCT NAME, TYPE FROM USER_SOURCE
 WHERE TYPE IN ('PROCEDURE', 'FUNCTION', 'PACKAGE') AND TEXT LIKE '%TARGET_STRING%';

SELECT ITEM_CODE FROM TABLE_A a
 WHERE NOT EXISTS (SELECT 1 FROM TABLE_B WHERE ORDER_NUMBER = a.ORDER_NUMBER)

DBMS_OBFUSCATION_TOOLKIT.DESENCRYPT(
    input_string => lv_plain_pass,
    key_string => lv_key,
    encrypted_string => lv_enc_pass
);

SELECT REGEXP_REPLACE(REGEXP_REPLACE('1.3.4',  '(\.|\A)(\d)', '.0\2'), '\d(\d\d)', '\1') FROM DUAL;
.01.03.04
SELECT REGEXP_REPLACE(REGEXP_REPLACE('1.23.4', '(\.|\A)(\d)', '.0\2'), '\d(\d\d)', '\1') FROM DUAL;
.01.23.04

UPDATE ITEMS a
   SET PRICE = (SELECT PRICE FROM NEW_ITEMS b WHERE b.PRICE = a.PRICE)
 WHERE EXISTS  (SELECT 1     FROM NEW_ITEMS b WHERE b.PRICE = a.PRICE)

UPDATE ORDERS
   SET (UPDATED_USER_ID, UPDATED_USER_NAME, UPDATED_USER_SEC_ID, UPDATED_USER_SEC_NAME) =
       (SELECT USER_ID, USER_NAME, USER_SEC_ID, USER_SEC_NAME FROM EMP_DB WHERE USER_ID = 'U0001')
 WHERE ORDER_ID = "A123"

SQLNET.AUTHENTICATION_SERVICES= (NTS)

SQLNET.AUTHENTICATION_SERVICES= (BEQ)

SET PAGESIZE 50
SET HEADING OFF
SELECT NAME || ' ' || SEQUENCE# || ' ' || NEXT_CHANGE#
  FROM V$ARCHIVED_LOG
 WHERE NEXT_CHANGE# >= (SELECT MIN(CHANGE#) FROM V$BACKUP
                       WHERE CHANGE# > 0);

SELECT A.SEGMENT_NAME, A.EXTENT_ID, A.FILE_ID
  FROM DBA_EXTENTS A
 WHERE A.OWNER = 'PO' AND A.TABLESPACE_NAME = 'POX'
   AND A.FILE_ID = 22
 ORDER BY A.SEGMENT_NAME

1. お勧めは「Basic」と「SQLPlus」です。この2つをダウンロードし、同じディレクトリで展開します。 「Basic Lite」は、日本語のNLS_LANGをサポートしておらず、 sqlplus.exeを使うと「NLS Initialization Error」というエラーになり、 PHPでも「OCIEnvNlsCreate() failed:なんとか」というエラーになり使えません。まったく使えないと思ってよいでしょう。
2. 特にインストーラなどでシステムに書き込んだりしないので、展開したディレクトリは好きな場所に移動、改名できます。 ここではC:\oracle\instantclient11という名前にしたとします。
3. 自分でテキストエディタなどを使ってtnsnames.oraを作り、C:\oracle\instantclient11に配置します。
4. システム環境変数を設定します。
   1.PATHにC:\oracle\instantclient11を追加
   2.TNS_ADMIN=C:\oracle\instantclient11と定義
   3.ORACLE_HOME=C:\oracle\instantclient11と定義
   4.NLS_LANGに「JAPANESE_JAPAN.JA16SJIS」など適切な値を設定
   
5. これでsqlplus.exeを起動して、接続を試します。「sqlplus taro/taropass@remote_db」問題なく接続できればokです。