Oracle¶àÐмǼºÏ²¢/Á¬½Ó/¾ÛºÏ×Ö·û´®µÄ¼¸ÖÖ·½·¨
ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name Type Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y
CITY VARCHAR2(20) Y
SQL> select * from test;
COUNTRY CITY
-------------------- --------------------
Öйú ̨±±
Öйú Ïã¸Û
Öйú ÉϺ£
ÈÕ±¾ ¶«¾©
ÈÕ±¾ ´óÚæ
ÒªÇóµÃµ½ÈçϽá¹û¼¯£º
------- --------------------
Öйú ̨±±,Ïã¸Û,ÉϺ£
ÈÕ±¾ ¶«¾©£¬´óÚæ
ʵ¼Ê¾ÍÊǶÔ×Ö·ûʵÏÖÒ»¸ö¾ÛºÏ¹¦ÄÜ£¬Î񼆮æ¹ÖΪʲôOracleûÓÐÌṩ¹Ù·½µÄ¾ÛºÏº¯ÊýÀ´ÊµÏÖËüÄØ£º£©
ÏÂÃæ¾Í¶Ô¼¸ÖÖ¾³£Ìá¼°µÄ½â¾ö·½°¸½øÐзÖÎö£¨ÓÐÒ»¸öÆÀ²â±ê×¼×î¸ß¡ï¡ï¡ï¡ï¡ï£©£º
1.±»¼¯ºÏ×ֶη¶Î§Ð¡Çҹ̶¨ÐÍ Áé»îÐÔ¡ï ÐÔÄÜ¡ï¡ï¡ï¡ï ÄÑ¶È ¡ï
ÕâÖÖ·½·¨µÄÔÀíÔÚÓÚÄãÒѾ֪µÀCITY×ֶεÄÖµÓм¸ÖÖ£¬ÇÒ»¹²»ËãÌ«¶à£¬Èç¹ûÌ«¶àÕâ¸öSQL¾Í»áÏ൱µÄ
³¤¡£¡£¿´Àý×Ó£º
SQL> select t.country,
2 MAX(decode(t.city,'
Ïà¹ØÎĵµ£º
²é¿´oracle·þÎñÆ÷×Ö·û¼¯:select * from nls_database_parameters where parameter = 'NLS_CHARACTERSET'
ʹÓÃPl/SQL ²éѯÊý¾ÝʱÂÒÂë,²åÈëÊý¾ÝʱÂÒÂë
Êý¾Ý¿â·þÎñÆ÷µÄ×Ö·û¼¯ºÍ¿Í»§¶ËµÄ×Ö·û¼¯²»Í¬ËùÔì³ÉµÄ,ÐÞ¸ÄÊý¾Ý¿â¿Í»§¶ËµÄ×Ö·û¼¯ºÍ·þÎñÆ÷µÄ×Ö·û¼¯Ò»ÖÂ
²Ù×÷·½·¨:
oracle 9i :Ð޸ı¾µØ×¢²á±íÖÐORACLE¿Í»§¶Ëµ ......
if %time:~,2% leq 9 (set hh=0%time:~1,1%) else (set hh=%time:~,2%)
exp wzolerp/wzolerp@wzol file=E:\Êý¾Ý¿â±¸·Ý\wzolerp%date:~0,10%ÈÕ%hh%ʱ%time:~3,2%·Ö.dmp log=E:\Êý¾Ý¿â±¸·Ý\wzolerp%date:~0,10%ÈÕ%hh%ʱ%time:~3,2%·Ö.log
exp wzolwms/wzolwms@wzol file=E:\Êý¾Ý¿â±¸·Ý\wzolwms%date:~0,10%ÈÕ ......
Oracle ´æ´¢¹ý³Ì·µ»Ø½á¹û¼¯Óà ref cursor ʵÏÖ¡£ÊÔÑé²½ÖèÈçÏ£º
1. ½¨Á¢ ref cursor ÀàÐͺ͹ý³Ì
CREATE OR REPLACE PACKAGE types
AS
TYPE ref_cursor IS REF CURSOR;
END;
/
CREATE TABLE STOCK_PRICES(
RIC VARCHAR(6) PRIMARY KEY,
PRICE NUMBER(7,2 ......
ǰ¼¸Ìì°ïÒ»¸öÅóÓÑŪORACLE¿çÊý¾Ý¿âµÄ²Ù×÷£¬¹²ÏíϾßÌåµÄ²Ù×÷Á÷³Ì£º
Ò»¡¢²»Í¬IPµÄÊý¾Ý¿â£¨DBLINK£©
±¾µØÊý¾Ý¿âip 10.56.7.26
Ô¶³ÌÊý¾Ý¿âip 233.215.219.8
1.ÔÚ10.56.7.26Êý¾Ý¿â°²×°ÎļþÖУ¬ÕÒµ½$ORACLE_HOME/network/admin/tnsnames.oraÎļþ£¬
ĩβÌí¼Ó
MEDIADBLINK =
(DESCRIPTION =
&n ......
ʲôÊÇsavepoint?
Use the SAVEPOINT statement to identify a point in a transaction to which you can later roll back.
¸øÄã¸öÀý×Ó
SQL> create table test (id number(7));
±íÒÑ´´½¨¡£
SQL> insert into test values (3);
ÒÑ´´½¨ 1 ÐС£
SQL> savepoint a;
±£´æ ......