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" {{
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡ oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË ÒýÓà oracle ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......
ÎÊÌâÌá³ö£º Ò»¸ö¸ß¼¶SQLÓï¾äÎÊÌâ ¼ÙÉèÓÐÒ»ÕÅ±í£¬AºÍB×ֶζ¼ÊÇNUMBER£¬ A B 1 2 2 3 3 4 4 ÓÐÕâÑùһЩÊý¾Ý ÏÖÔÚÏëÓÃÒ»ÌõSQLÓï¾ä£¬²éѯ³öÕâÑùµÄÊý¾Ý COLA COL1 COL3 COL2 COL1 4 4 ......