
(1)t@CSQLs
@file_name

: c:\sql\a.sqls
@c:\sql\a.sql


(2)IuWFNg̃\[X擾
!get_source <owner> <object_type> <object_name|all>

:
!get_source ogawa package pkg_aaa   -- pkg_aaa擾
!get_source ogawa table all         -- e[uS擾


(3)oChϐ
!bind set a = 'abc'    -- oChϐaɁCabcݒ
!bind unset a          -- oChϐa폜
!bind print a          -- oChϐa̓e\
!bind print            -- SẴoChϐXg\
!bind clear all        -- SẴoChϐ폜

:
!bind set tname = 'DUAL'
select * from all_tables
where table_name = :tname;

(3)e[u`\
describe <table_name>
describe <schema>.<table_name>
(*)ȗ`(desc)p\B


(4)dbms_output̐
!dmbs_output enable         -- dbms_output̏o͂M
!dmbs_output enable	<size>  -- dbms_output̏o͂M(obt@TCYw)
!dmbs_output disable        -- dbms_output̏o͂MȂ


(5)f[^x[Xւ̃OCCOAEg
connect <user>/<passwd>@<tns> -- OC
disconnect                    -- OAEg


(6)PL/SQLvV[W̎s
execute <procedure>        -- <procedure>s


(7)sʗ̃NA
!clear_result_view


(8)GfB^̐FύX
!option editor_bk_color #ffeeee		-- GfB^̔wiFύX
!option editor_text_color #0000dd	-- GfB^̃eLXgFύX

F̎whtml`: #rrggbb


(9)ڑ悪vCR}hs
!if session = '<user>@<tns>' then <command>
!if session = '*@<tns>' then <command>

(1)usertns`FbN
!if session = 'user@server' then option editor_bk_color #ffeeee

(2)tnŝ݃`FbN
!if session = '*@server' then option editor_bk_color #ffeeee

(3)ڑ悪vCt@Cs
!if session = 'user@server' then @c:\tmp\test.sql


(10)ʕ\ۑ
!save_grid_data <file_name> <column_name_flg> <double_quote_flg>

<file_name> t@C
<column_name_flg> 0:Jo͂ȂC1:Jo͂
<double_quote_flg> 0:_uNH[go͂ȂC1:_uNH[go͂

()Obhɕ\̃f[^t@Cɕۑ
!save_grid_data c:\tmp\zzz.csv 1 1


(11)SQL̎sʂۑ(_E[h@\Ɠ̃R}h)
!save_file <file_name> <column_name_flg> <double_quote_flg> <select_only_flg>

<file_name> t@C
<column_name_flg> 0:Jo͂ȂC1:Jo͂
<double_quote_flg> 0:_uNH[go͂ȂC1:_uNH[go͂
<select_only_flg> 0:sʂSQL⃁bZ[W܂߂ĕۑC1:ʂ̂ݕۑ

E
  ̃R}hśCSQL̎sʂt@CɕۑB
  t@C1SQLsI邽тcloseB
  t@CopenɎsCSQL̎s𒆎~B

()select * from obǰʂt@Cɕۑ
!save_file c:\tmp\zzz.csv 1 1 1
select * from obj;


(12)vOI
!exit_program


(13)f[^GNX|[g
!data_export <table_name> [table_name...]

<table_name> e[u
e[ũf[^GNX|[gꍇ́AXy[Xŋ؂ăe[u
񋓂

() table1table2̃f[^GNX|[g
!data_export table1 table2


(14)^uɖOt
!set_tabname <name>

()
!set_tabname test
!set_tabname "test data"
