һЩoracleµÄÃüÁî¼°º¯Êý °üÀ¨decodeµÈ
1¡¢set linesize 100; ÉèÖó¤¶È
2¡¢set pagesize 30; ÉèÖÃÿҳÏÔʾÊýÄ¿
3¡¢em a.sql ´ò¿ª¼Çʱ¾
4¡¢@ a Ö´ÐÐÎļþaÖеĴúÂ룬¿ÉÖ¸¶¨ÎļþµÄ·¾¶ @d:a.txt
5¡¢conn Óû§Ãû/ÃÜÂë ¸ù¾ÝÓû§ÃûºÍÃÜÂëÁ¬½ÓÊý¾Ý¿â Èç¹ûÁ¬½Ó³¬¼¶¹ÜÀíÔ±(sys) ÔòÓ¦¼ÓÉÏas sysdba;
6¡¢show user; ÏÔʾµ±Ç°Á¬½ÓµÄÓû§
7¡¢select * from tab; µÃµ½µ±Ç°Óû§ÏµÄËùÓбí
8¡¢desc temp; ²é¿´±í½á¹¹
9¡¢/ ¼ÌÐøÖ´ÐÐÉÏÒ»¸ö²éѯÓï¾ä
clear scr; ÇåÆÁ
×Ö·ûº¯Êý
10¡¢select upper('coolszy') from dual; ½«Ð¡Ð´×Öĸת»»³É´óд£¬dual ΪһÐé±í
11¡¢select lower('KUKA') from dual; ½«´óд×Öĸת»»³ÉСд
12¡¢select initcap('kuka') from dual; ½«Ê××Öĸ´óд
13¡¢select concat('Hello',' world') from dual; Á¬½Ó×Ö·û´®£¬µ«Ã»ÓÐ||ºÃÓÃselect concat('Hello','world') from dual;
14¡¢select substr('hello',1,3) from dual; ½ØÈ¡×Ö·û´®
15¡¢select length('hello') from dual; Çó×Ö·û´®³¤¶È
16¡¢select replace('hello','l','x') from dual; Ìæ»»×Ö·û´®
17¡¢select substr('hello',-3,3) from dual; ½ØÈ¡ºóÈýλ
ÊýÖµº¯Êý
18¡¢select round(789.536) from dual; ËÄÉáÎåÈ룬ÉáȥСÊý
19¡¢select round(789.536,2) from dual; ±£ÁôÁ½Î»Ð¡Êý
20¡¢select round(789.536,-1) from dual; ¶ÔÕûÊý½øÐÐËÄÉáÎåÈë
21¡¢select trunc(789.536) from&n
Ïà¹ØÎĵµ£º
OracleÊý¾Ý¿âÓÐÈýÖÖ±ê×¼µÄ±¸·Ý·½·¨£¬ËüÃÇ·Ö±ðÊǵ¼³ö£¯µ¼È루EXP/IMP£©¡¢Èȱ¸·ÝºÍÀ䱸·Ý¡£µ¼³ö±¸¼þÊÇÒ»ÖÖÂß¼±¸·Ý£¬À䱸·ÝºÍÈȱ¸·ÝÊÇÎïÀí±¸·Ý¡£
Ò»¡¢ µ¼³ö£¯µ¼È루Export£¯Import£©
ÀûÓÃExport¿É½«Êý¾Ý´ÓÊý¾Ý¿âÖÐÌáÈ¡³öÀ´£¬ÀûÓÃImportÔò¿É½«ÌáÈ¡³öÀ´µÄÊý¾ÝËͻص½OracleÊý¾Ý¿âÖÐÈ¥¡£
£±¡¢ ¼òµ¥µ¼³öÊý¾Ý£¨Export£©ºÍµ¼ÈëÊý¾ ......
±íµÄ²éÕÒ£º
select * from emp where (sal>500 or job='MANAGER') and ename like 'J%';
ÒýºÅÀï±ßµÄ×Ö·ûÊÇÇø·Ö´óСдµÄ¡£
²éÕÒÖ®ºó°Ñ½á¹ûÅÅÐò£º
select * from emp order by sal asc;
ascÊÇÉýÐò£¬descÊǽµÐò
¶ÔÁÐÖØÃüÃû£¬Ö»Òª´ò¸ö¿Õ¸ñ£¬ºó¸úÐÂÁÐÃû¾Í¿ÉÒÔ
select ename,sal*12+nvl(comm,0)*12 "Äêн" from ......
ÈçºÎ±¸·ÝOracleÊý¾Ý¿â£º
MD F:\DB_BAK\%date:~0,10%
EXP userid=bszlhr/bszlhr@ORCL_14 file=F:\DB_BAK\%date:~0,10%\bszlhr%date:~0,10%.dmp log=f:\DB_BAK\%date:~0,10%\log_bszlhr_%date:~0,10%.log
buffer=64000 owner=bszlhr
-----´´½¨ÐÅÓÃÐÅÏ¢µÄ±í----------
create table GCCredit(
itemID numb ......
ÓÃJavaÀ´²Ù×÷Êý¾Ý¿â£¬ÓÐÈçϼ¸ÖÖ·½Ê½£º
1JDBC-ODBCÇÅ£ºODBCÊý¾ÝÔ´ÔÚ²Ù×÷ϵͳ²ãÃæ¸øÓèÁËÖ§³Ö£¬ÎÒÃÇ¿ÉÒÔ²»ÓÃÁ˽âµ×²ãµ½µ×ÊÇ·â×°µÄÄÄÖÖÊý¾ÝÔ´£¬Ò²ÕÕÑù¿ÉÒÔÍê³É¶ÔÊý¾ÝµÄ²Ù×÷¡£µ«ÊÇËüÓÐƽ̨ÒÀÀµÐÔ£¬²»Ì«ÍƼöʹÓá£
2Javaµ½±¾µØAPI
3Javaµ½ÍøÂçÐÒé
4Javaµ½Êý¾Ý¿âÐÒ飺ËÙ¶È×î¿ì
Á¬½ÓÊý¾Ý¿â¿ÉÒÔ·ÖΪËIJ½£º
A¼ÓÔØÇý¶¯³ÌÐò£¨Ï ......