oracle¿ª·¢¹¤×÷
ÒªÕÒרÃÅ×öoracle¿ª·¢µÄ£¬ÒªÕÆÎÕʲôÑùµÄ֪ʶ¡£
ÇëÏêϸ˵һÏ¡£·Ç³£¸Ðл¡£
¶¥Ò»Ï£¬ÎÒÒ²Ïë×öoracle¿ª·¢
ÎÒ¾õµÃ£¬´óÌåÉÏÐèҪʲô֪ʶ£¬¿´¼¸ÔòÕÐÆ¸¹ã¸æ¾Í²î²»¶àÁ˽â¸ö´ó¸Å
sql,pl/sqlÕâЩ»ù±¾¹¦
¿ª·¢µÄһЩËã·¨
¾Ñé
×îºÃ»¹»ájava
´óÖÂÕâЩ
·Ö¼¸Öֵģ¬
Èç¹ûÊÇ×öoracleÓ¦Óÿª·¢£¬ÕÆÎÕpl/sqlÊÇ»ù±¾µÄ£¬»¹ÐèÒª»áʹÓÃform builder,report builder,xml publisherÖ®ÀàµÄoracle¹¤¾ß¡£java·½ÃæÐèÒªÁ˽âoracleµÄoaf¿ò¼Ü£¬»¹ÐèҪһЩÁìÓò֪ʶ¡£
Èç¹ûÊÇoracleÊý¾Ý²Ö¿â·½ÃæµÄ¿ª·¢£¬´óÖ°´Êý¾Ýɸѡ£¬´¦Àí£¬Õ¹ÏÖ·ÖÈýÀ࣬×öÕ¹ÏÖµÄÐèÒª»á±¨±í¹¤¾ß£¬Èç¹ûÊÇÊý¾ÝɸѡºÍ´¦Àí£¬Ä¿Ç°´ó²¿·ÖÒ²ÊÇ¿¿¹¤¾ß£¬Ö»ÓÐÉÙ²¿·ÖÊÇ¿¿pl/sql±à³Ì£¬¹úÄÚ¾ÝÎÒËùÖª°¢Àï°Í°ÍµÄÊý¾Ý²Ö¿âÊÇÕâÑùµÄ£¬¹úÍâµÄ£¬ÎÒĿǰ×öµÄÏîĿҲÊÇÈç´Ë¡£
³ýÁËoracle·½ÃæµÄ¼¼Êõ£¬ÄãÖÁÉÙ»¹ÐèÒªÓÐunix·½ÃæµÄ֪ʶ£¬»ù±¾ÃüÁîÖÁÉÙÒªÊìÁ·£¬»áдshell»òÕßperl½Å±¾¡£ÎÒĿǰµÄÏîÄ¿Öл¹ÐèÒªsqr·½ÃæµÄ֪ʶ¡£
Èç¹ûÊǵ¥´¿µÄoracleϵͳ¿ª·¢£¬ÄÇô»ápl/sql»ù±¾¾Í¿ÉÒÔÁË£¬µ«ÊÇÐèÒª¶ÔÁìÓò֪ʶ£¬Ò²¾ÍÊÇÒµÎñ·Ç³£Çå³þ£¬¹úÄÚ×ö½ðÈÚ£¬ÆÚ»õ£¬¹ÉƱ»òÕßÒøÐеĻù±¾ÊôÓÚ´ËÀ࣬±ÈÈçÒÔǰµÄ½ðÊË´ïÏÖÔÚµÄʤ¿Æ£¬»¹ÓкãÉú¡£
up
³ýÁËÕÆÎÕ»ù±¾µÄPL/SQL֪ʶÍâ, »¹Òª¶®µÃдOracle¹ÜÀí·½ÃæµÄ֪ʶ, È籸·ÝºÍ»Ö¸´, ȨÏÞ¹ÜÀíµÈ
ÈçÄܶ®µÃµãJAVA»ò.net֪ʶ¾Í¸üºÃ.
ÐèÒªÕÆÎÕ
oracle»ù±¾¸ÅÄîÇåÎú£¬ÊìϤÆäÔËÐлúÖÆ
oracle½á¹¹ºÍ¹ÜÀí
oracleµÄpl/sql¿ª·¢¡¢
oralceÐÔÄܵ÷Õû¡¢ÓÅ»¯
ÕâЩÊÇÄã±ØÐëÒªÕÆÎÕµÄ.
Â¥ÉÏÕý½â£¬sqlÓÅ»¯Ò²ÊDZØÐëÒª¶®µÄ£¬»¹ÓоÍÊÇlinux/unixϵͳ£¬shell±à³Ì
Oracle
Ïà¹ØÎÊ´ð£º
ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......
<?php
getenv("ORACLE_HOME");
$conn=ocilogon("test","test","test_db");
if($conn)
echo success;
&nb ......
1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?
2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......
Ôõô½«·ûºÅµ¥ÒýºÅ²åÈëORACLEÊý¾Ý¿âµÄ±íÖÐÈ¥°¡£¿
лл¸÷λ.
SQL code:
SQL> insert into test values('''');
ÒÑ´´½¨ 1 ÐС£
SQL> select * from test;
ID
----------
'
¿ÉÒÔÓÃÁ½¸öµ¥ÒýºÅÀ´±íʾ ......