ichc_11203.sql - tigerのうぃき
tered' col last_ddl_time Heading 'Last DDL|Time' select SYSDATE Current_time, substr(c.capture_name,9,8) extract_name,c.captur
tered' col last_ddl_time Heading 'Last DDL|Time' select SYSDATE Current_time, substr(c.capture_name,9,8) extract_name,c.captur
Function sendMail(ByVal 送信先アドレス As String, ByVal 仕入先名称 As String, ByVal 工事名称 As String, _ ByVal 申請者ユーザー名 As String, ByVal 申請者ユー
納用テーブルにデータを入れるSQLinsert into sysdba.wk_t_vsgastat select TO_CHAR(SYSDATE,'YYYY.MM.DD HH24:MI:SS') as NOW_TIME ,pool ,case n
ol /tmp/55Po_Awr.log col now_time new_value v_now_time SELECT TO_CHAR(SYSDATE,'YYYYMMDD_HH24MISS') NOW_TIME FROM DUAL ; spool out_&a
pool /tmp/55Po_Awr.logcol now_time new_value v_now_timeSELECT TO_CHAR(SYSDATE,'YYYYMMDD_HH24MISS') NOW_TIME FROM DUAL ;--spool out_&
pool /tmp/55Po_Awr.logcol now_time new_value v_now_timeSELECT TO_CHAR(SYSDATE,'YYYYMMDD_HH24MISS') NOW_TIME FROM DUAL ;--spool out_&
インスタンス、SID、サービス名--SQLPLUSshow parameter service_namesshow parameter db_nameshow parameters db_domain--ディクショナリで引く--インスタンス名select instance_nam