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

oracle²éѯÎÊÌ⣡¼±

ԭʼÓï¾ä£ºvar indexsql="select * from fla_info where obj_id = 1; 

ÎÒÏëÒª²éѯid=1µÄÊý¾Ý

ÏÖÔÚÏëÓÃÒ»¸ö±äÁ¿£¬ÀýÈçnumber ´úÌæÊýÖµ1¡£¾ÍÊÇÕâÑù£º

var number = 1 £»
var indexsql="select * from fla_info where obj_id = number ;

ÕâÑùµÄ»°³öÀ´µÄ½á¹ûΪ¿Õ¡£

Ó¦¸ÃÔõÑùÐ޸ģ¿Ð»Ð»¸÷λ¸ßÊÖ£¡
ÔÚPL/SQL ÖпÉÒÔÓÃ&±äÁ¿´úÌæ
±ÈÈçSQL code:

SELECT * from EMP WHERE EMPNO=#
ÔËÐкó»áÌáʾÄãÊäÈë±äÁ¿Ö²




Ò²¿ÉÒÔÔÚÃüÁîÐÐÌáʾ·ûÏÂ
¶¨Òå±äÁ¿
SQL code:

SQL>DEFINE A=7788
SQL>SELECT * from EMP WHERE EMPNO=&A



ÒýÓÃ
var indexsql="select * from fla_info where obj_id = '" + number  + "'";

ʵ¼ÊÉÏÕâÀïÒѾ­ÊÇǰ¶Ë³ÌÐòµÄÎÊÌâÁË
phoenix_99˼·û´í£¬Õâ¸öµ¥ÒýºÅûÓбØÒªÌí¼Ó

лл¸÷λÁË£¬°´Phoenix_99µÄ·½·¨ÒѾ­½â¾öÁË£¡


Ïà¹ØÎÊ´ð£º

oracle 10g webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

oracleÊý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£

²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿

ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ

ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ