ÅäÖû·¾³±äÁ¿oracleÔÚ XP - Oracle / »ù´¡ºÍ¹ÜÀí
ÅäÖû·¾³±äÁ¿oracleÔÚ XP
ÐüÉÍ·Ö£º105 - ½â¾öʱ¼ä£º2008-9-23 23:39
ÎÒÖ»°Ñoracle×°ÔÚÁËE:\oracleÖÐ
»·¾³±äÁ¿²»ÖªµÀÈçºÎÅäÖÃ.
XPϰ²×°ORACLE ûÓÐÐèÒªÅäÖõĻ·¾³±äÁ¿
¿ÉÒÔͨ¹ýEMÅäÖÃÏ·þÎñÃûºÍIP¾Í¿ÉÒÔÁË
»òÕßÖ±½ÓÅäÖð²×°Ä¿Â¼ÏµÄADMIN/NETWORK/TNS¡£ORAÎļþ
LINUXϰ²×°ORACLEËùÐèµÄ»·¾³±äÁ¿ÔÚXP¶¼±»×Ô¶¯Ð´½ø×¢²á±íÁË£¬²»ÐèÒªÅäÖÃÁË
°²×°Íê³É£¬Èç¹ûÊÇ·þÎñÆ÷±¾»úµÇ¼£¬¿ÉÒÔ²»ÓÃÈκÎÅäÖã¬Ö±½Ó
c:>sqlplus <Óû§Ãû>/<ÃÜÂë>
¾Í¿ÉÒԵǼʹÓÃÁË£¬Èç¹ûÔÚÆäËü¿Í»§¶ËµÇ¼£¬ÔòÐèÒªÅäÖüàÌýºÍTNSNAMES
windows
»·¾³±äÁ¿°²×°Ê±¶¼±»×Ô¶¯Ð´½ø×¢²á±íÁË
ÎÒÏëÎʵÄÊÇÔõÑù²ÅÄÜÐ޸Ļ·¾³±äÁ¿£¿Ð»Ð»
ÐÞ¸Ä×¢²á±íÁË¡£¡£¡£¡£¡£¡£
ÄܾßÌåµÄ˵˵¸ÃÔõôÐÞ¸ÄÂð£¿ÎÒÊdzõѧÕß
лл
http://www.hackline.net/a/Special/Linux/application/2009/1107/1424.html
Õâ¸ö¿ÉÄÜÄãÒªµ½oracle¹Ù·½ÍøÕ¾¿´¿´
»¹ÊÇû¿´Ã÷°×°¡
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
Á½¸ö±í
Çë¿´ "Persons" ±í£º
name banji shunxu
yiyang 01 1
yiyang 02 1
lili 01 2
½ÓÏÂÀ´Çë¿´ "xueke" ±í£º
name kemu shunxu
yiy ......
ÔÚOracle Êý¾Ý¿âÖÐÔõô²éǰÈýÌõ¼Ç¼½µÐò£»
select * from
(select * from table order by col_name desc)
where rownum<=3;
select * from
(
select s.*,rownum rn
from t3 s
)
where ......