oracle´æ´¢¹ý³ÌÔõôÊä²»³ö´ð°¸
declare
v_name exwarehouse.goodsname%type;
v_a exwarehouse.amount%type;
begin
select goodsname,amount
into v_name,v_a
from exwarehouse
where exwarehouse.id='20091012091729';
dbms_output.put_line(v_name);
dbms_output.put_line(v_a);
end;
Õâ¶Î´úÂë±àÒë³É¹¦£¬ÔõôÔÚpl\sqlÖÐûÓÐÊä³ö½á¹û£¿ÎÒÔÚ¿ØÖÆÌ¨Ã»¿´µ½¡£¡£¡£
sf
set serverout on
Ö´ÐÐÕâ¶Î¹ý³ÌǰÏÈÖ´ÐÐÏ£º
set serveroutput onÊÔÊÔ¿´
±àÒëºóÔËÐÐû£¿
ÔËÐÐǰset serveroutput onÁËû£¿
set serveroutput on
¿ÉÄÜÍüÁËSET SERVEROUTPUT ON
set serveroutput on;
Ïà¹ØÎÊ´ð£º
abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y
Äã² ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
·þÎñÆ÷ϵͳÊÇxp,Êý¾Ý¿âoracle10g£¬web·þÎñÆ÷ÊÇtomcat£¬Á¬½ÓÊý¾Ý¿âʱ±¨Á¬½Ó´íÎó£¬ÈçÏÂËùʾ£ºThe Network Adapter could not establish the connectionÒì³££¬oracle·þÎñºÍ¼àÌýÒѾÆðÀ´ÁË£¨¶øÇÒ¶¼ÊÇÕýÈ·µÄ£©¡£Êý¾Ý¿âjar ......
ÈçÏÂVC6²Ù×÷ORACLEÁ¬½Ó·½·¨Îª¿É±¨´í£º
_bstr_t connStr£»
connStr="Provider=OraOLEDB.Oracle;User ID=scott;Password=tiger;Data Source=192.168.0.120;";
m_SqlConn->Open(_bstr_t(connStr),(_b ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......