
(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

