Oracle
-
编辑 删除
sqlplus 与 shell 结合的方法
sqlplus跟shell结合的方法#!/bin/bashSqlplus -s scott/tiger<<EOF |Awk ‘$2<=1000{print}’Set head offSet feed offselect name from emp where deptno = 30;exitEOFExample:Sqlplus -s scott/tiger <<EOF> x...
-
编辑 删除
oracle
SQL> select * from t1 where x like'A_B';X----------A%BABA_BSQL> select * from t1 where x like 'A\_B' escape '\';SQL> select * from t1 where x like 'A!_B' escape '!';sel...
