UPDATE语句我们最常用UPDATE TABLE SET COL=VALUE WHERE CONDITION;如果UPDATE多个列呢UPDATE TABLE SET COL1=VALUE1,COL2=VALUE2，...  WHERE CONTITION;今天开发发过来语句要update多个列列中间没有使用“，”分割语句报错，添加“，”后问题解决。报错如下：ERROR

今天需要配合开发写一个触发器审计delete操作，很自然想到SYS_CONTEXT下面引用sql referenceACTION Identifies the position in the module (application name) and is set through theDBMS_APPLICATION_INFO package or OCI.AUDITED_C

create or replace procedure proc_check_table iscursor c_table is select table_name from check_table where status='Y';v_count number(10);v_table_name check_table.table_name%type;sql_str varch

create user ro_datagrp identified by "DDr8jCGOmT677Wbx";grant connect to ro_datagrp;declarev_sql varchar2(2000);CURSOR cur_grant IS select 'grant select,update,delete,insert on '||owner||'.'

create or replaceprocedure show_space( p_segname in varchar2, p_owner in varchar2 default user, p_type in varchar2 default 'TABLE', p_partition in varchar2 default NULL )authid current_u

1.单引号转义10g后的新方式：select q'()' from dual;写法类似perl中的q''2.查询ORACLE保留字SQL> help RESERVED WORDS (PL/SQL) RESERVED WORDS (PL/SQL) ----------------------- PL/SQL Reserved Words h

--CREATE LOG TABLE CREATE TABLE KILL_SESS_HIST AS SELECT S.*,T.START_TIME                                FROM V$TRANSACTION T,V$SESSION S                                 WHERE S.TADDR=T.ADDR AND