3,490
社区成员
发帖
与我相关
我的任务
分享
Connected to Oracle Database 11g Enterprise Edition Release 11.1.0.7.0
Connected as abc
SQL> create table abc (id1 varchar2(100),id2 char(100));
Table created
SQL> insert into abc values('abcdef ','abcdef ');
1 row inserted
SQL> commit;
Commit complete
SQL> select * from abc;
ID1 ID2
-------------------------------------------------------------------------------- --------------------------------------------------------------------------------
abcdef abcdef
SQL> select * from abc where id1='abcdef';
ID1 ID2
-------------------------------------------------------------------------------- --------------------------------------------------------------------------------
SQL> select * from abc where id1='abcdef ';
ID1 ID2
-------------------------------------------------------------------------------- --------------------------------------------------------------------------------
abcdef abcdef
SQL> select * from abc where id2='abcdef';
ID1 ID2
-------------------------------------------------------------------------------- --------------------------------------------------------------------------------
abcdef abcdef
SQL> select * from abc where id2='abcdef ';
ID1 ID2
-------------------------------------------------------------------------------- --------------------------------------------------------------------------------
abcdef abcdef
SQL>
select * from user where regexp_like(username,'AdgTécnico')