https://blog.youkuaiyun.com/imshangzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/imshang/article/details/6674384https://blog.youkuaiyun.com/imshang/article/details/6674384imshangWed, 10 Aug 2011 03:57:11 +0800https://blog.youkuaiyun.com/imshang/article/details/5935652https://blog.youkuaiyun.com/imshang/article/details/5935652imshangTue, 12 Oct 2010 14:24:00 +0800https://blog.youkuaiyun.com/imshang/article/details/5643112https://blog.youkuaiyun.com/imshang/article/details/5643112imshangWed, 02 Jun 2010 19:18:00 +0800https://blog.youkuaiyun.com/imshang/article/details/5613482https://blog.youkuaiyun.com/imshang/article/details/5613482imshangFri, 21 May 2010 11:04:00 +0800https://blog.youkuaiyun.com/imshang/article/details/5600554https://blog.youkuaiyun.com/imshang/article/details/5600554imshangMon, 17 May 2010 14:48:00 +0800 SELECT UPPER(last_name) || earns ||     2   TO_CHAR(salary, fm$99,999) ||     3   monthly but wants ||     4   TO_CHAR(salary * 3, fm$99,999) ||]]>https://blog.youkuaiyun.com/imshang/article/details/5588398https://blog.youkuaiyun.com/imshang/article/details/5588398imshangThu, 13 May 2010 21:02:00 +0800 SELECT first_name || || last_name "Employees", dept_id      2  FROM s_emp      3  WHERE dept_id IN (10, 50)      4  ORDER BY last_name; //WHERE ... LIKE ...%.]]>https://blog.youkuaiyun.com/imshang/article/details/5586361https://blog.youkuaiyun.com/imshang/article/details/5586361imshangThu, 13 May 2010 11:46:00 +0800https://blog.youkuaiyun.com/imshang/article/details/5566316https://blog.youkuaiyun.com/imshang/article/details/5566316imshangFri, 07 May 2010 11:47:00 +0800 CREATE TABLE s_dept(     2  ID NUMBER(7) NOT NULL,     3  NAME VARCHAR2(35) NOT NULL,     4  REGION_ID NUMBER(7),     5  CONSTRAINT pk_s_dept PRIMARY KEY (ID)); Table created. SQL> INSERT ]]>https://blog.youkuaiyun.com/imshang/article/details/5522158https://blog.youkuaiyun.com/imshang/article/details/5522158imshangFri, 23 Apr 2010 20:18:00 +0800https://blog.youkuaiyun.com/imshang/article/details/5513202https://blog.youkuaiyun.com/imshang/article/details/5513202imshangWed, 21 Apr 2010 20:57:00 +0800sqlplus [system/orcl@127.0.0.]]>https://blog.youkuaiyun.com/imshang/article/details/5496052https://blog.youkuaiyun.com/imshang/article/details/5496052imshangSat, 17 Apr 2010 10:52:00 +0800 SELECT name FROM master..sysdatabases;2> go  2. 获取所有表名   1> USE master2> go1> SELECT name FROM sysobjects WHERE type=U;2> g]]>https://blog.youkuaiyun.com/imshang/article/details/5495941https://blog.youkuaiyun.com/imshang/article/details/5495941imshangSat, 17 Apr 2010 10:21:00 +0800