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

ORACLE´ø²ÎÈ«Á¬½Ó

    
  select * from (
  select cw2.NO WHOLENO,sp1.ARGUMENTNAME TYPENAME,sp2.ARGUMENTNAME BRANDNAME,sp3.ARGUMENTNAME STYLENAME,sp4.ARGUMENTNAME DEPART,so.OPERATORNAME USERNAME
  from COM_WHOLE_INFO cw2,SYS_OPERATOR so, SYS_PUBLICARGUMENT sp1, SYS_PUBLICARGUMENT sp2, SYS_PUBLICARGUMENT sp3, SYS_PUBLICARGUMENT sp4
  where cw2.C_CURDEPTNO='00020104' and cw2.C_TYPE=sp1.ARGUMENTID(+) and cw2.C_BRAND=sp2.ARGUMENTID(+)
  and cw2.C_STYLE=sp3.ARGUMENTID(+) and cw2.C_URUSER=so.OPERATORID(+) and cw2.C_CURDEPTNO=sp4.ARGUMENTID(+)) cc
  full join  (select * from COM_INVENTORY ci2 where ci2.parent='6') tab1 on tab1.no=cc.WHOLENO


Ïà¹ØÎĵµ£º

oracleǶÌ×

Ò»¡¢Ç¶Ì×±íµÄ¶¨Ò壺
    ǶÌ×±íÊDZíÖÐÖ®±í¡£Ò»¸öǶÌ×±íÊÇijЩÐеļ¯ºÏ£¬ËüÔÚÖ÷±íÖбíʾΪÆäÖеÄÒ»ÁС£¶ÔÖ÷±íÖеÄÿһÌõ¼Ç¼£¬Ç¶Ì×±í¿ÉÒÔ°üº¬¶à¸öÐС£ÔÚijÖÖÒâÒåÉÏ£¬ËüÊÇÔÚÒ»¸ö±íÖд洢һ¶Ô¶à¹ØϵµÄÒ»ÖÖ·½·¨¡£¿¼²éÒ»¸ö°üº¬²¿ÃÅÐÅÏ¢µÄ±í£¬ÔÚÈκÎʱ¼äÄÚÿ¸ö²¿ÃÅ»áÓкܶàÏîÄ¿ÕýÔÚʵʩ¡£ÔÚÒ»¸öÑϸñµÄ¹ØϵģÐÍÖУ ......

Ò»´ÎÏÖ³¡oracle 9i ÐÔÄܵ÷ÓÅ

µÚÒ»²½
   ¶ÔÊý¾Ý¿âÕûÌå×öÁËÒ»¸öÁ˽â
$ORACLE_HOME/bin/sqlplus "sys/sys061201 as sysdba" << EOF
spool peiyz_healthcheck_info.txt
set linesize 200
set pagesize 1000
set time on
set timing on
col owner for a10
col segment_name for a30
col index_name for a30
col table_name for a ......

´«ÖDz¥¿Í——Êý¾Ý¿âÖ®ORACLE£¨Ò»£©


Ò» Oracle¹«Ë¾¼ò½é 
OracleÊÇÒóÐæ³öÍÁµÄ¼×¹ÇÎÄ(oracle bone inscriptions)µÄÓ¢ÎÄ·­ÒëµÄµÚÒ»¸öµ¥´Ê
Oracle¹«Ë¾ÊÇÈ«Çò×î´óµÄÐÅÏ¢¹ÜÀíÈí¼þ¼°·þÎñ¹©Ó¦ÉÌ£¬³ÉÁ¢ÓÚ1977Ä꣬×ܲ¿Î»ÓÚÃÀ¹ú¼ÓÖÝ Redwood shore
Oracle¹«Ë¾ÒòÆ临ÔӵĹØϵÊý¾Ý¿â²úÆ·¶øÎÅÃû¡£OracleµÄ¹ØϵÊý¾Ý¿âÊÇÊÀ½çµÚÒ»¸öÖ§³ÖSQLÓïÑÔµÄÊý¾Ý¿â
OracleÔÚ³¬¹ý ......

SQLServerºÍOracleµÄ³£Óú¯Êý¶Ô±È

1.¾ø¶ÔÖµ 
S:select abs(-1) value
O:select abs(-1)  value from dual
2.È¡Õû(´ó) 
S:select ceiling(-1.001) value  
O:select ceil(-1.001)  value from dual
3.È¡Õû£¨Ð¡£© 
S:select floor(-1.001) value  
O:select floor(-1.001)  value from dual
4.È ......

¶ÔoracleÊý¾Ý¿âÖÐCLOB×ֶεÄÏà¹Ø²Ù×÷


import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
 * ´Ë´¦²åÈëÀàÐÍ˵Ã÷¡£
 * ´´½¨ÈÕÆÚ£º(2001/11/30 14:55 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ