Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

È«ÃæÑ§Ï°ORACLE SchedulerÌØÐÔ(4)´´½¨ºÍ¹ÜÀíSchedule

Èý¡¢Ê¹ÓÃSchedules
¡¡¡¡10g ÖÐÐÂÍÆ³öµÄSCHEDULER¿ÉÄÜȷʵ»áÈúܶà³õ½Ó´¥µÄÅóÓѸоõÔÎÍ·ÔÎÄÔ£¬Ïà±È֮ǰµÄjobs£¬SCHEDULERÖÐÐÂÔöµÄ¸ÅÄîÌ«¶à¡£±ÈÈç˵jobs£¬ÈÔÈ»¿ÉÒÔÀí½â³É֮ǰ°æ±¾ÖеÄjobs£¬²»¹ý¹¦Äܸü¼ÓÇ¿´ó(×¢Òâ10gÖÐÒ²ÈÔÈ»¿ÉÒÔʹÓÃÆÕͨjobs£¬ÕâÊÇ·Ï»°£¬ÏàÐÅ¿´±¾ÆªÎÄÕµÄÅóÓÑĿǰӦ¸Ã»¹ÊÇÕâÑùÔÚÓÃ)£¬±ÈÈç˵program£¬Ö¸µÄÊÇÔ ......

ORACLE¼Æ»®(schedule)Ïê½â

´´½¨job
jobÊÇÊ²Ã´ÄØ? ¼òµ¥µÄ˵¾ÍÊǼƻ®(schedule)¼ÓÉÏÈÎÎñ˵Ã÷. ÁíÍ⻹ÓÐһЩ±ØÐëµÄ²ÎÊý.
ÕâÀïÌáµ½µÄ"ÈÎÎñ"¿ÉÒÔÊÇÊý¾Ý¿âÄÚ²¿µÄ´æ´¢¹ý³Ì,ÄäÃûµÄPL/SQL¿é,Ò²¿ÉÒÔÊDzÙ×÷ϵͳ¼¶±ðµÄ½Å±¾.
¿ÉÒÔÓÐÁ½ÖÖ·½Ê½À´¶¨Òå"¼Æ»®":
1) ʹÓÃDBMS_SCHDULER.CREATE_SCHEDULE ¶¨ÒåÒ»¸ö¼Æ»®;
2) µ÷ÓÃDBMS_SCHDULER.CREATE_JOBE¹ý³ÌÖ±½ÓÖ¸¶¨ ......

ORACLEÎﻯÊÓͼ ÎﻯÊÓͼµÄ¿ìËÙË¢ÐÂ


´øUNION ALLÎﻯÊÓͼµÄ¿ìËÙË¢ÐÂ
1.   ¶¨ÒåµÄ²éѯµÄunion all²Ù×÷±ØÐëÔÚ×î¶¥µÈ¼¶£¨²éÑ¯ÖØÐ´ºó£©
2.   ÎﻯÊÓͼÈÕÖ¾Ö¸¶¨rowidºÍincluding new values
3.   Èç¹û±íÉèÉæ¼°µ½Ò»¸ö´óÁ¿µÄinsert»òÕßÖ±½Ó·¾¶¼ÓÔØ£¬deletes,update£¬Ö¸¶¨sequencea
4.   fromÁбí ......

һЩ»ù±¾µÄSQLÃüÁî

--ÏÔʾ°æ±¾ºÅ£¬µ±Ç°ÈÕÆÚ
SELECT VERSION(),CURRENT_DATE(),NOW();
--Ãâ·ÑµÄ¼ÆËãÆ÷
SELECT (20+5)*4 AS RESULT,SIN(PI()/3);
--´´½¨Êý¾Ý¿â
CREATE DATABASE databasename;
--ɾ³ýÊý¾Ý¿â
DROP DATABASE databasename;
--ÏÔʾµ±Ç°´æÔÚµÄÊý¾Ý¿â
SHOW DATABASES;
--Ñ¡ÔñÊý¾Ý¿â
USE ......

SQL Server µÃµ½ÐкŵÄSQL

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ