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

oracle±£´æµÄÎÊÌâ

SQL> run
1 select customer_id,first_name,last_name,dob
2 from customers
3* where customer_id=1
CUSTOMER_ID FIRST_NAME LAST_NAME DOB
----------- ---------- ---------- --------------
1 John Brown 01-1ÔÂ -65
SQL> save a.txt;
SP2-0110: ÎÞ·¨´´½¨±£´æÎļþ "a.txt"

ÇëÎÊΪʲô²»Äܱ£´æÎļþ°¡
ÎÒÓõÄVISTAϵͳ
SQL> ed
SP2-0110: ÎÞ·¨´´½¨±£´æÎļþ "afiedt.buf"
»¹ÓÐÕâ¸öÎÊÌâ

ÇëÎÊ´óÏÀ ʲô»ØÊ°¡
sql>save f:/a.txt
???ûÕâô¸É¹ý£¬°ï¶¥ÁË

oracleʲô°æ±¾?

ÒýÓÃ
oracleʲô°æ±¾?
10g 10.2.0.3.0 ÆóÒµ°æ


ÒýÓÃ
²»ÊÇÕâôÓõģºspool f:\text.txt
Ò»Ñù°¡ ²»¿ÉÒÔ
SQL> spool e:text.txt;
SP2-0606: ÎÞ·¨´´½¨ SPOOL Îļþ "e:\text.txt"
{{


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

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²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

oralce µÄÒ»¸öSQL - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÊÌâÌá³ö£º
Ò»¸ö¸ß¼¶SQLÓï¾äÎÊÌâ 
¼ÙÉèÓÐÒ»ÕÅ±í£¬AºÍB×ֶζ¼ÊÇNUMBER£¬
A B
1 2
2 3
3 4

ÓÐÕâÑùһЩÊý¾Ý
ÏÖÔÚÏëÓÃÒ»ÌõSQLÓï¾ä£¬²éѯ³öÕâÑùµÄÊý¾Ý
COLA COL1 COL3 COL2 COL1
4 4 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ