SQL code:
select rack_no,frm_no,slot_no,port_no,kdjc_get_ip_cou('221.9.120.254',2,null,null,rack_no,frm_no,slot_no,port_no)
port_sta,kdjc_get_inout_ter('ÆäËü_AL',rack_no,frm_no,slot_no,port_no) as in_out_ter from kdlc_devicejc_result where
kdjc_get_ip_cou('221.9.120.254',2,null,null,rack_no, ......
¿ì±ÏÒµÁË£¬×î½üæÓÚÃæÊÔ
Ä¿±êְλÊÇÊý¾Ý¿â¹¤³Ìʦ
ÔÚ´óѧ½×¶ÎÖ÷ҪѧSql Serve£¬·¢ÏÖÐí¶àÊý¾Ý¿âְλ¶¼ÒªÇóOracle
¶ÔûÓÐoracle»ù´¡µÄ£¬¹«Ë¾Ò»°ã»áÃæÊÔЩʲô£¿
лл
Ï£Íû±È½ÏÃìã..Ò»°ãµÄDBA¶¼ÊÇÒªÇóÓм¸Ä깤×ö¾ÑéµÄ
¶øÇÒÒ»°ãµÄDBA¶¼ÊÇÓÉ¿ª·¢ÈËԱת¹ýÀ´µÄ
¼òÀú¶¼²»·ûºÏ£¬»¹ÃæÊÔɶ°¡£¿
SQLÓï¾ä ......
ÎÒÐèÒªÓÃC++Á¬½ÓoracleÊý¾Ý¿â£¬ÓÐÄÄλ¸ßÈËÄÜÖ¸µãһϣ¬ÎÒÖ»ÐèÒªÁ¬½Ó³É¹¦£¬Íê³É»ù±¾µÄ²éѯÐÅÏ¢¾ÍºÃÁË¡£
Êý¾Ý¿âÊÇoracle9i£¬Êý¾Ý¿âÃû£ºshensuoyao£¬Êý¾Ý¿â±í£ºshensuoyao,×ֶΣºname varchar2(10),age number
Êý¾Ý¿âÓû§Ãû ssy,ÃÜÂ룺ssy
²»¹ÜÓÃʲô·½·¨£¬ÄÜÁ¬ÉÏoracle¾ÍºÃ¡£
×îºÃ¸ø³ö´úÂ룬ÓÃVC++6.0»òÕßVS2008» ......
ÔÚÓÃoracleÊý¾Ý¿âµÄʱºò£¬ÎÒÏëÅ׳öÒì³££¬µ«ÊÇ·µ»ØµÄÊý¾ÝûÓУ¬ÎÒÓÃNO_DATA_FOUND ûÓÐÒì³£Å׳ö£¬ÇëÎÊÊÇÓÃÕâ¸öô£¬Ð»Ð»
no_data_foundÊÇÓÃÓÚÓαêµÄ¡£¡£¡£
ÄÇÄã¿ÉÒÔÓÃselect count(*)À´²éѯ³ö½á¹û£¬È»ºó×öÅжϰ¡¡£¡£¡£
ʹÓô洢¹ý³Ì£¬¶¨ÒåÒ»¸öÊä³ö²ÎÊý£¬½«Êý¾Ý·µ»Ø£¡
Äã¿´¸öÀý×Ó°É¡£¡£¡£
SQL code:
declare
......
¸÷λ´óÏÀ:
СµÜÊÇoracle³õѧÕߣ¬ÔÚhp-unixÉϰ²×°oracleʱ³öÏÖÒ»¸ö´íÎó£¬Çë¸÷λ´óÏÀ°ïæ¡£
hp-unix B.11.23 U 64λ 16C 48GÄÚ´æ °²×°oracle 10.2.0.1.0°æ±¾Êý¾Ý¿â¡£
ÔÚ°²×°µ½configuragion assistantÒ³ÃæÊ±£¬µÚ¶þÏî³öÏÖ£¨Ó¦¸ÃÊÇÔÚdbca´´½¨Êý¾Ý¿âʱ£©Ò»¸ö´íÎó£º
ORA-3113 "end of file on communication chan ......
ÔÚOracleÖÐÒѾ½¨Á¢ÁËÐòÁкʹ¥·¢Æ÷£¬µ«ÊDZ£´æÊý¾Ýµ½OracleµÄʱºò×ÜÊDZ¨ÐòÁУ¨ºÅ£©²»´æÔÚµÄ´í£¡
ÔÚsqlPLusÖÐÓÃsqlÓï¾ä:
insert into system.A_register values(register_id_sequence.nextval,'sss',4,'2323','23','232','232','','','')
¿ÉÒÔ²åÈë¡£
ÎÊÌâ½â¾ö²»ÁË¡£{{ ......