IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    Oracle SQL,转义特殊字符

    Adamhuan发表于 2016-12-26 09:46:25
    love 0

    具体如下:

    SYS@dbaplus --> select table_name from dba_tables where table_name like '%\_O%' escape '\' and rownum<13;
    
    TABLE_NAME
    ------------------------------
    FIXED_OBJ$
    IND_ONLINE$
    MAP_OBJECT
    DIR$MIGRATE_OPERATIONS
    DIR$SERVICE_OPERATIONS
    DIR$ESCALATE_OPERATIONS
    DIR$QUIESCE_OPERATIONS
    DIR$RESONATE_OPERATIONS
    STMT_AUDIT_OPTION_MAP
    WRI$_OPTSTAT_TAB_HISTORY
    WRI$_OPTSTAT_IND_HISTORY
    
    TABLE_NAME
    ------------------------------
    WRI$_OPTSTAT_HISTHEAD_HISTORY
    
    12 rows selected.
    
    SYS@dbaplus --> 
    SYS@dbaplus --> select table_name from dba_tables where table_name like '%_O%' and rownum<13;
    
    TABLE_NAME
    ------------------------------
    ICOL$
    CON$
    UNDO$
    PROXY_ROLE_DATA$
    COL$
    PROXY_DATA$
    BOOTSTRAP$
    CCOL$
    OBJERROR$
    UGROUP$
    SUPEROBJ$
    
    TABLE_NAME
    ------------------------------
    LOB$
    
    12 rows selected.
    
    SYS@dbaplus -->

    ————————
    Done



沪ICP备19023445号-2号
友情链接