ѧϰORACLEÒ²¿ìÒ»ÄêÁË£¬µ½ÏÖÔÚ¶¼¶ÔORACLEµÄϵͳ֪ʶÁ˽âµÃºÜÉÙ£¬Ò»Ö±ÏëÌá¸ß×Ô¼ºµÄ¼¼Êõˮƽ£¬Æ½Ê±¶¼ÊÇÔÚ¿´±ðÈ˵ÄBLOBÖÐѧϰ£¬»¹ÊÇѧµ½Á˲»ÉÙ֪ʶ£¬µ«ÎÒ×Ô¼ºÓ¢ÓïÕæµÄºÜ²îºÜ²î£¬ORACLEµÄ¹Ù·½ÎĵµÒ»µãÒ²¿´²»¶®¡£ÎÒÊÇÒ»µã»ùÓï»ù´¡¶¼Ã»Óе쬰¥£¬ÒÔǰ¶ÁÊéµÄʱºò²»ÈÏÕæ¡£¡£¡£¡£ÏÖÔÚÎÒ²»ÖªÓÃʲô·½Ê½À´²¹ÎÒµÄÓ¢ÓÏÖÔÚÓÐÁ½¸öÏë·¨£¬ ......
Ò»¸ö´¢´æÐÅÓÿ¨½»Ò׼ǼµÄ±ítable1,Ò»¸öÖ÷¼ü£¬Ò»¸ö¿¨ºÅµÄÍâ¼ü£¬»¹ÓÐ3ÁÐÊôÐÔ£¬·Ö±ðÊÇ ÐÅÓÿ¨¾ÉµÄÓà¶î£¬½»Ò×½ð¶î£¬¿¨µÄеÄÓà¶î£º
transactionID PK£¬
card ID FK,
old_value,
transaction_amount,
new_value
ÎÒÏÖÔÚµÄÎÊÌâÊÇ£ºÐèÒªÕÒ³öÓÐÆÛÕ©¿ÉÄܵÄÄÇЩ¼Ç¼£¬±ÈÈç˵£¬¶ÔÓÚÒ»ÕÅÐÅÓÿ¨À´Ëµ£¬°ÑËüËùÓеÄÏû ......
ÐÂѧoracle£¬ÒÔǰÓõÄÊÇsql server,ºÜ¶àµØ·½²»¶®£¬Çë´ó¼Ò²»ÁßÖ¸½Ì
ÎÒÏëÓÃcrystal report 10¿ª·¢Ò»Ð©±¨±í£¬ÒÔǰÔÚsql server»·¾³ÏÂÊÇдºÃprocedureÈ»ºóÓÃcrystal reportsµ÷ÓþͿÉÒÔÁË¡£
ÏÖÔÚÎÒ²»ÖªµÀ£¬ÔÚoracleÏÂÓ¦¸ÃÔõô´ïµ½ÕâÖÖЧ¹û£¿
Çë¸ßÊÖ°ïæ£¬Ð»Ð»~~~
ÊÇÒ»Ñù
Òª²»crystal reportÔ ......
ÎҵķþÎñÆ÷ÊÇSolaris 5.8µÄ£¬oracle 9.2µÄ£¬perl 5.8µÄ£¬apache2.1µÄphp 5.1µÄ¡£mysql 5.0
³öÏÖÎÊÌâÊÇ£º
phpÁ¬½Óoracle ²åÈëÊý¾Ý£¬¶ÁÈ¡Êý¾ÝÒ»ÇÐÕý³£
perl Á¬½Ómysql ²åÈëÊý¾Ý£¬¶ÁÈ¡Êý¾ÝÒ»ÇÐÕý³£¡£
perlÁ¬½Óoracle ¶ÁÈ¡ÓÃphp²åÈëµ½oracleÖеÄÖÐÎÄÏÔʾΪ"??"
perlÁ¬½Óoracle¶ÁÈ¡ÓÃperl²åÈëµ ......
create tablespace data datafile '/opt/app/oracle/oradata/data.dbf'
size 50M EXTENT MANAGEMENT LOCAL;
CREATE TEMPORARY TABLESPACE TEMP
TEMPFILE '/opt/app/oracle/oradata/tmp.dbf' SIZE 5M
EXTENT MANAGEMENT LOCAL;
create tablespac ......
ÔÚÿ¸öÔÂÔµ׵ÄÍíÉÏ11£º00Ö´ÐУº
sqlplus / as sysdba set linesize 10000 rename tb_mt to tb_mt_200910;£¨µ±Ç°ÄêÔÂ)
-- Create table
create table TB_MT
(
MT_ID NUMBER(15) not null,
& ......