随笔分类 -  Oracle

Oracle：简单SQL程序、存储过程、触发器
摘要：/* 以下代码是对emp表进行显示宽度设置 */ col empno for 9999; col ename for a10; col job for a10; col mgr for 9999; col hiredate for a12; col sal for 9999; col comm fo 阅读全文
posted @ 2017-05-12 12:55 花醉红尘 阅读(531) 评论(0) 推荐(0)
Oracle：批量操作、视图、序列、简单SQL程序
摘要：/* 以下代码是对emp表进行显示宽度设置 */ col empno for 9999; col ename for a10; col job for a10; col mgr for 9999; col hiredate for a12; col sal for 999999; col comm 阅读全文
posted @ 2017-05-12 12:49 花醉红尘 阅读(1527) 评论(0) 推荐(0)
Oracle：函数、表连接、子查询、集合
摘要：/* 以下代码是对emp表/dept表/salgrade表进行显示宽度设置 */ col empno for 9999; col ename for a10; col job for a10; col mgr for 9999; col hiredate for a12; col sal for 9 阅读全文
posted @ 2017-05-12 12:37 花醉红尘 阅读(621) 评论(0) 推荐(0)
Oracle：基本SQL
摘要：/* --以下代码是对emp表进行显示宽度设置 col empno for 9999; col ename for a10; col job for a10; col mgr for 9999; col hiredate for a12; col sal for 9999; col comm for 阅读全文
posted @ 2017-05-12 12:21 花醉红尘 阅读(4117) 评论(0) 推荐(0)