写作前言:
记录一些我使用频繁次数很高的语句
1.查询表的列名
select COLUMN_NAME from user_tab_columns where
Table_Name=’SYS_P_USER’ order by column_name
2.查询10行数据
select * from tabke where rownum<11
3.远程连接
sqlplus user/passwd@//10.113.1.50:1521/orcl;
4.左连接
SELECT a.”NAME”,b.”id” FROM USERINFO a LEFT JOIN DECHEN b ON a.DWMC =
b.”name”
5.层次关系(见我的另一篇博文“组织关系”)
select ia.id,name,IA.PARENT_ID,level, CONNECT_BY_ISCYCLE “Cycle” from
SYS_P_DEPARTMENT ia CONNECT BY NOCYCLE prior ia.id=ia.parent_id ORDER
BY “Cycle” ;
6.删除check(顺便说一句,navicat提供了很友好的图形界面进行管理)
ALTER TABLE Persons DROP CONSTRAINT CHK_PersonAge
;