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

Oracle×Ö·û¼¯²âÊÔ

ÒÔÏ»شðÊôÓÚתÔØ£º
¾­³£¿´µ½Ò»Ð©ÅóÓÑÎÊORACLE×Ö·û¼¯·½ÃæµÄÎÊÌ⣬ÎÒÏëÒÔµü´úµÄ·½Ê½À´½éÉÜһϡ£
µÚÒ»´Îµü´ú£ºÕÆÎÕ×Ö·û¼¯·½ÃæµÄ»ù±¾¸ÅÄî¡£
ÓÐЩÅóÓÑ¿ÉÄÜ»áÈÏΪÕâÊǶà´ËÒ»¾Ù£¬µ«Êµ¼ÊÉÏÕýÊÇÓÉÓÚ¶ÔÏà¹Ø»ù±¾¸ÅÄî°ÑÎÕ²»Ç壬²Åµ¼ÖÂÁËÖî¶àÎÊÌâºÍÒÉÎÊ¡£
Ê×ÏÈÊÇ×Ö·û¼¯µÄ¸ÅÄî¡£
ÎÒÃÇÖªµÀ£¬µç×Ó¼ÆËã»ú×î³õÊÇÓÃÀ´½øÐпÆѧ¼ÆËãµÄ£¨ËùÒÔ½Ð×ö"¼ÆËã»ú"£©£¬µ«Ëæ׿¼ÊõµÄ·¢Õ¹£¬»¹ÐèÒª¼ÆËã»ú½øÐÐÆäËü·½ÃæµÄÓ¦Óô¦Àí¡£Õâ¾ÍÒªÇó¼ÆËã»ú²»½öÄÜ´¦ÀíÊýÖµ£¬»¹ÄÜ´¦ÀíÖîÈçÎÄ×Ö¡¢ÌØÊâ·ûºÅµÈÆäËüÐÅÏ¢£¬¶ø¼ÆËã»ú±¾ÉíÄÜÖ±½Ó´¦ÀíµÄÖ»ÓÐÊýÖµÐÅÏ¢£¬ËùÒÔ¾ÍÒªÇó¶ÔÕâЩÎÄ×Ö¡¢·ûºÅÐÅÏ¢½øÐÐÊýÖµ±àÂ룬×î³õµÄ×Ö·û¼¯ÊÇÎÒÃǶ¼·Ç³£ÊìϤµÄASCII£¬ËüÊÇÓÃ7¸ö¶þ½øÖÆλÀ´±íʾ128¸ö×Ö·û£¬¶øºóÀ´Ëæ×Ų»Í¬¹ú¼Ò¡¢×éÖ¯µÄÐèÒª£¬³öÏÖÁËÐíÐí¶à¶àµÄ×Ö·û¼¯£¬Èç±íʾÎ÷Å·×Ö·ûµÄISO8859ϵÁеÄ×Ö·û¼¯£¬±íʾºº×ÖµÄGB2312-80¡¢GBKµÈ×Ö·û¼¯¡£
×Ö·û¼¯µÄʵÖʾÍÊǶÔÒ»×éÌض¨µÄ·ûºÅ£¬·Ö±ð¸³Ó費ͬµÄÊýÖµ±àÂ룬ÒÔ±ãÓÚ¼ÆËã»úµÄ´¦Àí¡£
×Ö·û¼¯Ö®¼äµÄת»»¡£×Ö·û¼¯¶àÁË£¬¾Í»á´øÀ´Ò»¸öÎÊÌ⣬±ÈÈçÒ»¸ö×Ö·û£¬ÔÚijһ×Ö·û¼¯Öб»±àÂëΪһ¸öÊýÖµ£¬¶øÔÚÁíÒ»¸ö×Ö·û¼¯Öб»±àÂëΪÁíÒ»¸öÊýÖµ£¬±ÈÈçÎÒÀ´´´ÔìÁ½¸ö×Ö·û¼¯demo_charset1Óëdemo_charset2£¬ÔÚdemo_charset1ÖУ¬Îҹ涨ÁËÈý¸ö·ûºÅµÄ±àÂëΪ£ºA£¨0001£©£¬B£¨0010£©£¬£¿£¨1111£©£»¶øÔÚdemo_charset2ÖУ¬ÎÒÒ²¹æ¶¨ÁËÈý¸ö·ûºÅµÄ±àÂëΪ£ºA£¨1001£©£¬C£¨1011£©£¬£¿£¨1111£©£¬ÕâʱÎÒ½Óµ½Ò»¸öÈÎÎñ£¬Òª±àдһ¸ö³ÌÐò£¬¸ºÔðÔÚdemo_charset1Óëdemo_charset2Ö®¼ä½øÐÐת»»¡£ÓÉÓÚÖªµÀÁ½¸ö×Ö·û¼¯µÄ±àÂë¹æÔò£¬¶ÔÓÚdemo_charset1ÖеÄ0001£¬ÔÚת»»Îªdemo_charset2ʱ£¬Òª½«Æä±àÂë¸ÄΪ1001£»¶ÔÓÚdemo_charset1ÖеÄ1111£¬×ª»»Îªdemo_charset2ʱ£¬ÆäÊýÖµ²»±ä£»¶ø¶ÔÓÚdemo_charset1ÖеÄ0010£¬Æä¶ÔÓ¦µÄ×Ö·ûΪB£¬µ«ÔÚdemo_charset2ûÓжÔÓ¦µÄ×Ö·û£¬ËùÒÔ´ÓÀíÂÛÉÏÎÞ·¨×ª»»£¬¶ÔÓÚËùÓÐÕâÀàÎÞ·¨×ª»»µÄÇé¿ö£¬ÎÒÃÇ¿ÉÒÔ½«ËüÃÇͳһת»»ÎªÄ¿±ê×Ö·û¼¯ÖеÄÒ»¸öÌØÊâ×Ö·û£¨³ÆΪ"Ìæ»»×Ö·û"£©£¬±ÈÈçÔÚÕâÀïÎÒÃÇ¿ÉÒÔ½«£¿×÷ΪÌæ»»×Ö·û£¬ËùÒÔB¾Íת»»ÎªÁË£¿£¬³öÏÖÁËÐÅÏ¢µÄ¶ªÊ§£»Í¬ÑùµÀÀí£¬½«demo_charset2µÄC×Ö·ûת»»µ½demo_charset1ʱ£¬Ò²»á³öÏÖÐÅÏ¢¶ªÊ§¡£
ËùÒÔ˵£¬ÔÚ×Ö·û¼¯×ª»»¹ý³ÌÖУ¬Èç¹ûÔ´×Ö·û¼¯ÖеÄij¸ö×Ö·ûÔÚÄ¿±ê×Ö·û¼¯ÖÐûÓж¨Ò壬½«»á³öÏÖÐÅÏ¢¶ªÊ§¡£
Êý¾Ý¿â×Ö·û¼¯µÄÑ¡Ôñ¡£
ÎÒÃÇÔÚ´´½¨Êý¾Ý¿âʱ£¬ÐèÒª¿¼ÂǵÄÒ»¸öÎÊÌâ¾ÍÊÇÑ¡Ôñʲô×Ö·û¼¯Óë¹ú¼Ò×Ö·û¼¯£¨Í¨¹ýcreate databaseÖеÄCHARACTER SETÓëNATIONAL C


Ïà¹ØÎĵµ£º

Çø±ðoracleµÄµ¥ÒýºÅºÍË«ÒýºÅ

      ¶ÔÓÚÎÒÃǸÕÈëÃŵÄoracle³õѧÕßÀ´Ëµ£¬Ñ§Ï°sqlÓïÑÔÊÇÈëÃŵĵÚÒ»²½£¬Ãæ¶Ôµ¥ÒýºÅºÍË«ÒýºÅ£¬ÎÒÃÇ¿ÉÄÜ»áÀ§»ó£¬Ê²Ã´Ê±ºòÓõ¥ÒýºÅ£¬Ê²Ã´Ê±ºòÓÃË«ÒýºÅÄØ£¿
    µ¥ÒýºÅ------  ֵΪ×Ö·ûºÍÈÕÆÚµÄʱºò Èç  'you'  '06-june'   »¹ÓÐʹÓÃÁ¬½Ó·û||£¬²åÈë¿Õ¸ñ||' ......

Oracle LongÐÍ

Oracle LongÐÍ
 
1¡¢LONG Êý¾ÝÀàÐÍÖд洢µÄÊǿɱ䳤×Ö·û´®£¬×î´ó³¤¶ÈÏÞÖÆÊÇ2GB¡£
2¡¢¶ÔÓÚ³¬³öÒ»¶¨³¤¶ÈµÄÎı¾£¬»ù±¾Ö»ÄÜÓÃLONGÀàÐÍÀ´´æ´¢£¬Êý¾Ý×ÖµäÖкܶà¶ÔÏóµÄ¶¨Òå¾ÍÊÇÓÃLONGÀ´´æ´¢µÄ¡£
3¡¢LONGÀàÐÍÖ÷ÒªÓÃÓÚ²»ÐèÒª×÷×Ö·û´®ËÑË÷µÄ³¤´®Êý¾Ý£¬Èç¹ûÒª½øÐÐ×Ö·ûËÑË÷¾ÍÒªÓÃvarchar2ÀàÐÍ¡£
4¡¢ºÜ¶à¹¤¾ß£¬°üÀ¨SQL*Plus£¬´ ......

Oracle´æ´¢¹ý³Ì×ܽá(Ò»¡¢»ù±¾Ó¦ÓÃ)

1¡¢´´½¨´æ´¢¹ý³Ì
create or replace procedure test(var_name_1 in type,var_name_2 out type) as
--ÉùÃ÷±äÁ¿(±äÁ¿Ãû ±äÁ¿ÀàÐÍ)
begin
--´æ´¢¹ý³ÌµÄÖ´ÐÐÌå
end test;
´òÓ¡³öÊäÈëµÄʱ¼äÐÅÏ¢
E.g:
create or replace procedure test(workDate in Date) is
begin
dbms_output.putline('The input date is: ......

ͿĨOracle——Èý˼±Ê¼ÇÖ®Ò»²½Ò»²½Ñ§Oracle

¡¡¡¡
¡¡¡¡±¾Êé×÷Ϊһ±¾´´×÷Ö®³õ¾Í¶¨Î»ÓÚ¼¼ÊõÓ¦ÓõÄʵ¼ù²Î¿¼Ê飬ËäȻǰǰºóºó´®ÁªÁËOracleÊý¾Ý¿âÖÐÊ®Óà¸ö³£ÓÃÌØÐÔ»ò¹¤¾ß£¬µ«ÔÚÕ½ڵÄÉè¼ÆÉÏÍêÈ«×ñÑ­ÕâÒ»ÀíÄî¡£ÔÚÉæ¼°ÌØÐÔ»ò¹¤¾ßÓ¦ÓõÄÿһ¸öÕ½ڣ¬¾ùÓÐÏà¹ØʵÀýÑÝʾÈçºÎÓ¦Óã¬ËùÓÐʾÀýµÄ×îÖÕÄ¿µÄ£¬¾ÍÊÇÏ£ÍûÔĶÁ±¾ÊéµÄÅóÓÑ£¬Äܹ»½«Ë«ÊÖ½â·Å³öÀ´£¬×ÔÐÅÁé»îµØʹÓÃÊéÖнéÉܵĸ÷Ï ......

Oracle »µ¿é ×ܽá


OracleÊý¾Ý¿â³öÏÖ»µ¿éÏÖÏóÊÇÖ¸£ºÔÚOracleÊý¾Ý¿âµÄÒ»¸ö»ò¶à¸öÊý¾Ý¿é£¨Ò»¸öÊý¾Ý¿éµÄÈÝÁ¿ÔÚ´´½¨Êý¾Ý¿âʱÓÉdb_block_size²ÎÊýÖ¸¶¨£¬È±Ê¡Îª8K£©ÄÚ³öÏÖÄÚÈÝ»ìÂÒµÄÏÖÏó¡£ÓÉÓÚÕý³£µÄÊý¾Ý¿é¶¼Óй̶¨µÄºÏ·¨ÄÚÈݸñʽ£¬»µ¿éµÄ³öÏÖ£¬µ¼ÖÂÊý¾Ý¿â½ø³ÌÎÞ·¨Õý³£½âÎöÊý¾Ý¿éµÄÄÚÈÝ£¬½ø¶øʹÊý¾Ý¿â½ø³Ì±¨´íÄËÖÁ¹ÒÆ𣬲¢¼¶Áªµ¼ÖÂÕû¸öÊý¾Ý¿âʵÀý³ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ