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

Legato±¸·ÝoracleµÄÎĵµÕûÀí

http://inthirties.com:90/viewthread.jsp?tid=1394
1 ÎÒÃÇÒѾ­ÔÚ±¸·Ý·þÎñÆ÷ÉϽ¨Á¢ÁËÒ»¸öcatalog¿â£¬¾ßÌåµÄ²Ù×÷¹ý³ÌÈçÏ£º
1£©²éѯÏÖÔÚµÄÊý¾Ý¿â
# sqlplus /nolog.
SQL>connect / as sysdba;
Connected.
SQL>select * from v$tablespace;
TS# NAME INC
———- ——————- —
0 SYSTEM YES
1 UNDOTBS1 YES
2 TEMP YES
3 CWMLITE YES
4 INDX YES
5 TOOLS YES
6 USERS YES
7 XDB YES
8 rows selected.
SQL>; sellect name,bytes,status from v$datafile;
NAME————-BYTES STATUS———-
/oracle/product/10g/oradata/legato/system01.dbf 5242880 SYSTEM
/oracle/oradata/legato/system01.dbf 262144000 SYSTEM
/oracle/product/10g/oradata/legato/undotbs01.dbf 5242880 ONLINE
NAME———— BYTES STATUS———-
/oracle/oradata/legato/undotbs01.dbf 209715200 ONLINE
/oracle/product/10g/oradata/legato/cwmlite01.dbf 5242880 ONLINE
/oracle/oradata/legato/cwmlite01.dbf 20971520 ONLINE
NAME————–BYTES STATUS- ——-
/oracle/product/10g/oradata/legato/indx01.dbf 5242880 ONLINE
/oracle/oradata/legato/indx01.dbf 26214400 ONLINE
/oracle/product/10g/oradata/legato/tools01.dbf 5242880 ONLINE
NAME————- BYTES STATUS——-
/oracle/oradata/legato/tools01.dbf 10485760 ONLINE
/oracle/product/10g/oradata/legato/users01.dbf 5242880 ONLINE
/oracle/oradata/legato/users01.dbf 26214400 ONLINE
NAME—————BYTES STATUS———-
/oracle/product/10g/oradata/legato/xdb01.dbf 5242880 ONLINE
/oracle/oradata/legato/xdb01.dbf 20971520 ONLINE
14 rows selected.
SQL>select INSTANCE_NAME,HOST_NAME,VERSION from v$instance;
INSTANCE_NAME———HOST_NAME——–VERSION——-
legato
linthdb
10.2.0.1.0
SQL>select username from dba_users;
USERNAME————–
SYS
SYSTEM
DBSNMP
OUTLN
OLAPSYS
WMSYS
6 rows select


Ïà¹ØÎĵµ£º

oracleÖÐÈ¥ÖØ¸´¼Ç¼,²»ÓÃdistinct

ÓÃdistinct¹Ø¼ü×ÖÖ»ÄܹýÂ˲éѯ×Ö¶ÎÖÐËùÓмǼÏàͬµÄ£¨¼Ç¼¼¯Ïàͬ£©£¬¶øÈç¹ûÒªÖ¸¶¨Ò»¸ö×Ö¶ÎȴûÓÐЧ¹û£¬ÁíÍâdistinct¹Ø¼ü×Ö»áÅÅÐò£¬Ð§Âʺܵ͡£
select distinct name from t1 ÄÜÏû³ýÖØ¸´¼Ç¼£¬µ«Ö»ÄÜȡһ¸ö×ֶΣ¬ÏÖÔÚҪͬʱȡid,nameÕâ2¸ö×ֶεÄÖµ¡£
select distinct id,name from t1 ¿ÉÒÔÈ¡¶à¸ö×ֶΣ¬µ«Ö»ÄÜÏû³ýÕâ2¸ö×Ö¶ ......

Oracle ·ÖÒ³´æ´¢¹ý³Ì ¼¸Ê®ÍòÌõ¼Ç¼

ºÃ³¤Ê±¼äûд¶«¶«ÁË£¬½ñÌìдÁËÒ»¸öoracleµÄ·ÖÒ³´æ´¢¹ý³Ì£¬Ìù³öÀ´Óë´ó¼Ò·ÖÏí¡£
ÓÉÓÚ¡£net¿ò¼ÜÖеÄgridviewµÈ¿Ø¼þµÄ·ÖÒ³¹¦ÄÜÌ«Èõ£¬ËùÒԴ󲿷ֳÌÐòÔ±¶¼»á×Ô¼ºÐ´·ÖÒ³¹¦ÄÜ£¬¶øµ÷Ó÷ÖÒ³´æ´¢¹ý³ÌÊDZØÐëµÄ¡£
ǰ̨aspxÒ³Ãæ²»¹ÜÊÇÓÃÏÂÔØµÄdll»¹ÊÇÓÃ×Ô¼ºÐ´µÄÓû§¿Ø¼þ£¬¶¼ÄÜʵÏÖ×Ô¼ºµÄ¹¦ÄÜ£¬È»¶ø·ÖÒ³µÄ´æ´¢¹ý³Ì¾ÍÐèÒªºÃºÃµÄ¿¼ÂÇÁË£¬Ï ......

Oracle Approvals Management Actions

Actions
Every action belongs to an action type. An action type is a collection of actions having similar functionality. For example, actions in the absolute-job-level action type all require approvals up to a certain job level in the HR supervisory hierarchy.
ÿ¸öÐÐΪ¶¼ÊôÓÚÒ»ÖÖÐÐΪÀàÐÍ¡£Ã¿ÖÖÐÐΪÀà ......

Oracleº¯Êý

º¯Êý:
 ×Ö·ûº¯Êý 
  ×ª»¯³ÉСдLOWER(<C>)  ת»¯³É´óдUPPER(<C>) select lower('aAbBcC') from dual;
 
 --------
 ÈÕÆÚº¯Êý
  add_months(D,<I>)·µ»ØÈÕÆÚD¼ÓÉÏi¸öÔºóµÄ½á¹û
   select add_month(sysdate,3)from dual;
&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ