ORACLE SQLÓÅ»¯ ORACLEÖ´Ðмƻ®
Last login: Mon Feb 8 14:13:19 2010 from 192.168.1.249
ipnet
-bash-3.00$
-bash-3.00$ ipnet
-bash: ipnet: command not found
-bash-3.00$ su - oracle
Password:
eastcsu: incorrect password
-bash-3.00$ eastcom
-bash: eastcom: command not found
-bash-3.00$ su - oracle
Password:
[oracle@ipnet-td2 ~]$
[oracle@ipnet-td2 ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Feb 8 14:14:08 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> su^H^H^H
SP2-0042: unknown command " - rest of line ignored.
SQL> conn ipnet/ipnet1234@ORAC^H^H^H
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
SQL> ^[[A^H " - rest of line ignored.
SQL> 042: unknown command "
SQL> conn ipnet/ipnet1234@ORCL
Connected.
SQL> set timn^H
SP2-0158: unknown SET option "tim"
SQL> set timing on
SQL> set autot traceonly
SQL> select v.NAME_CN from vendor v, vendordevicetype vt, devicetype t where t.name = vt.device_type_name and v.name = vt.vendor_name and t.name_cn = '·À»ðǽ';
Elapsed: 00:00:00.01
Execution Plan
----------------------------------------------------------
Plan hash value: 497066359
--------------------------------------------------------------------------------
------------------
| Id | Operation | Name | Rows | Bytes | Cost
(%CPU)| Time |
--------------------------------------------------------------------------------
------------------
| 0 | SELECT STATEMENT | | &n
Ïà¹ØÎĵµ£º
Èý¡¢Ê¹ÓÃSchedules
¡¡¡¡10g ÖÐÐÂÍƳöµÄSCHEDULER¿ÉÄÜȷʵ»áÈúܶà³õ½Ó´¥µÄÅóÓѸоõÔÎÍ·ÔÎÄÔ£¬Ïà±È֮ǰµÄjobs£¬SCHEDULERÖÐÐÂÔöµÄ¸ÅÄîÌ«¶à¡£±ÈÈç˵jobs£¬ÈÔÈ»¿ÉÒÔÀí½â³É֮ǰ°æ±¾ÖеÄjobs£¬²»¹ý¹¦Äܸü¼ÓÇ¿´ó(×¢Òâ10gÖÐÒ²ÈÔÈ»¿ÉÒÔʹÓÃÆÕͨjobs£¬ÕâÊÇ·Ï»°£¬ÏàÐÅ¿´±¾ÆªÎÄÕµÄÅóÓÑÄ¿Ç°Ó¦¸Ã»¹ÊÇÕâÑùÔÚÓÃ)£¬±ÈÈç˵program£¬Ö¸µÄÊÇÔ ......
´øUNION ALLÎﻯÊÓͼµÄ¿ìËÙË¢ÐÂ
1. ¶¨ÒåµÄ²éѯµÄunion all²Ù×÷±ØÐëÔÚ×µÈ¼¶£¨²éѯÖØдºó£©
2. ÎﻯÊÓͼÈÕÖ¾Ö¸¶¨rowidºÍincluding new values
3. Èç¹û±íÉèÉæ¼°µ½Ò»¸ö´óÁ¿µÄinsert»òÕßÖ±½Ó·¾¶¼ÓÔØ£¬deletes,update£¬Ö¸¶¨sequencea
4. fromÁбí ......
select s.username,
decode(l.type,'TM','TABLE LOCK',
'TX','ROW LOCK',
& ......
SQL Server µÃµ½ÐкŵÄSQL
ʹÓÃÁÙʱ±í£º
select id=identity(int,1,1),value into #temp from YourTable
select * from #temp
drop table #temp
È¡µÃµÚ11µ½20ÐмǼ£º
select IDENTITY(in ......
DB2 SQL PL
SQL PLÊÇDB2ËùÖ§³ÖµÄ¹ý³Ì»¯ÓïÑÔ£¬ËüÊÇSQL/PSM±ê×¼µÄÒ»¸ö×Ó¼¯¡£Æä¸ù¾ÝÓ¦Ó÷¶Î§²»Í¬£¬ÓÖ·ÖΪInline SQL PL£¬Embeded SQL PLºÍCompiled SQL PL¡£
Inline SQL PL
ÊÊÓ÷¶Î§£º´¥·¢Æ÷¡¢º¯ÊýºÍ·½·¨£¬Ö§³Ö²¿·ÖSQL PL£¬Ê¹ÓÃʱҪעÒâһЩÏÞÖÆ
Óï·¨¹æÔò£ºBEGIN ATOMIC ... END
Embeded SQL PL
ÊÊÓ÷¶Î§£ºÇ¶Èëʽ£¬Åäº ......