oracle¿ª·¢µÄÏà¹ØÎÊÌâ - Oracle / ¿ª·¢
×öOracleÊý¾Ý¿â¿ª·¢µÄ´óÏÀÄÜ˵˵Oracle¿ª·¢µÄÖ÷Òª¹¤×÷ÒÔ¼°Ïà¹Ø¹¤¾ßÂð£¿
ÒªÊÇÏë×öºÃOracle¿ª·¢Ó¦¸Ã¾ß±¸Ê²Ã´ÄÜÁ¦ÄØ£¿
лл£¬Ï£Íû´ó¼ÒÓ»Ô¾ÌÖÂÛ£¡
Õâ¸öÎÊÌâºÃÏñÖ»ÄÜ×öÕâ¸öµÄ²ÅÖªµÀÁË¡£¡£¡£°ïlz¶¥¡£¡£¡£ºÙºÙ¡£¡£
˳±ãת¸öÐÁ¿à·Ö¡£¡£¡£¡£ºÇºÇ¡£¡£
ÓëÊý¾Ý¿âÏà¹ØµÄ¹¤×÷£º³ÌÐòÔ±¡¢dbaµÈ
Ïà¹Ø¹¤¾ß£ºsqlplus¡¢pl/sql developer¡¢toad¡¢powerdesigner......
ÄÜÁ¦£ºÐèÒªÒ»¶¨µÄ×ÔѧÄÜÁ¦£¬¼á³Ö²»Ð¸
ÎҵŤ×÷Ò»°ã¾ÍÊÇд´æ´¢¹ý³Ì£¬ÓÅ»¯SQL£¬ºÍÊý¾ÝЧÑéÖ®ÀàµÄ¡£
ÎÒÓõÄÊÇPL/SQL DEV£¬ÓÐЩÈËϲ»¶ÓÃTOAD¡£
Òª»ù±¾¾ß±¸µÄÄÜÁ¦¾ÍÊÇÄÜдƯÁÁµÄSQLÓï¾ä£¬»¹Òª»á¿´Ö´Ðмƻ®µÈµÈ¡£
ÔÚÉϰ࣬û¶àÏ룬ÏÂÃæ¼ÌÐø²¹³ä
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......