输入如下命令:
SQL> select tablespace_name,status,contents
2 from dba_tablespaces;TABLESPACE_NAME STATUS CONTENTS
------------------------------ --------- ---------
SYSTEM ONLINE PERMANENT
UNDOTBS1 ONLINE UNDO
TEMP ONLINE TEMPORARY
DRSYS ONLINE PERMANENT
EXAMPLE ONLINE PERMANENT
INDX ONLINE PERMANENT
ODM ONLINE PERMANENT
TOOLS ONLINE PERMANENT
USERS ONLINE PERMANENT
XDB ONLINE PERMANENT
JINLIAN ONLINE PERMANENTTABLESPACE_NAME STATUS CONTENTS
------------------------------ --------- ---------
JINLIAN_UNDO ONLINE UNDO
JINLIAN_TEMP ONLINE TEMPORARY已选择13行。
再执行如下命令:SQL> select tablespace_name,status,contents
2 from dba_tablespaces
3 where tablespace_name like 'jin%';未选定行
这是怎么回事啊?
SQL> select tablespace_name,status,contents
2 from dba_tablespaces;TABLESPACE_NAME STATUS CONTENTS
------------------------------ --------- ---------
SYSTEM ONLINE PERMANENT
UNDOTBS1 ONLINE UNDO
TEMP ONLINE TEMPORARY
DRSYS ONLINE PERMANENT
EXAMPLE ONLINE PERMANENT
INDX ONLINE PERMANENT
ODM ONLINE PERMANENT
TOOLS ONLINE PERMANENT
USERS ONLINE PERMANENT
XDB ONLINE PERMANENT
JINLIAN ONLINE PERMANENTTABLESPACE_NAME STATUS CONTENTS
------------------------------ --------- ---------
JINLIAN_UNDO ONLINE UNDO
JINLIAN_TEMP ONLINE TEMPORARY已选择13行。
再执行如下命令:SQL> select tablespace_name,status,contents
2 from dba_tablespaces
3 where tablespace_name like 'jin%';未选定行
这是怎么回事啊?
SQL> select tablespace_name,status,contents
2 from dba_tablespaces
3 where tablespace_name like 'JIN%';
那么ORACLE会默认以大写的形式进行存储而在你查询的时候是在单引号内 这个时候就是大小写敏感的了