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

oracle֪ʶ£¨Ò»£©


sql½Å±¾£¬Ò²¾ÍÊÇÔÚÎļþÖÐдÓÐsqlÓï¾äµÄÎļþ£¬¿ÉÒÔÔÚsqlplusÖÐÔËÐС£
ÒýÈësql½Å±¾
sqlplus Óû§Ãû/ÃÜÂë @sql½Å±¾.sql
£¨×¢Ò⣺ÔÚÓû§ÃûÃÜÂëÊäÈë½áÊøºóÒ»¶¨Òª¼Ó¿Õ¸ñÈ»ºóÔÙд@sql½Å±¾£©
OracleÖеĿÕÖµ»áµ±×÷ÎÞÇî´ó´¦Àí£¬Æäʵ¿ÕÖµ¸ù±¾¾Í²»»á´æ´¢£¬Ö»ÊÇ¿´×÷ÊÇÎÞÇî´ó¡£
OracleÖпØÖÆ´¦Àíº¯Êý NVL(×Ö¶ÎÃû£¬Öµ)£¬Õâ¸ö×Ö¶ÎÖеĿÕÖµÌæ»»ÎªÖ¸¶¨Öµ£¬Èç¹û²»Îª¿Õ£¬Ôò»á·µ»ØÆäÔ­Öµ¡£
Àý£ºselect (salary*12)*(NVL(commission_pct,0)/100+1) salary,first_name
from s_emp;
 
distinct¹Ø¼ü×Ö£¬È¥µôÖØ¸´ÐУ¨Õâ¸ö¹Ø¼ü×ֻᴦ·¢ÅÅÐò²Ù×÷£©
Àý£º select distinct dept_id,title from s_emp;
 
×¢Ò⣺distinct£¬¹Ø¼ü×ÖÖ®ºó»á¶Ôfrom֮ǰµÄ×ֶνøÐÐÅÅÖØ²Ù×÷¡£
 
columnÃüÁÕâÊǸösqlplusÃüÁ
 
columnÃüÁî ÁиñʽµÄ¶¨Òå
column Ä¿±êÁÐÃû ²é¿´Õâ¸öÀàÊÇ·ñ¶¨ÒåÁ˸ñʽ
 
column Ä¿±êÁÐÃû format a.. ÉèÖÃÁпí
 
column last_name heading 'Employee|Name'£¨ÉèÖÃÌâÍ·£© FORMAT A15
ÕâÆäÖеÄ'|'ÊÇ»»Ðзû
 
column salary justify left format $99,990.00£¨¶¨ÒåÊý×ÖÏÔʾ¸ñʽ£©
×¢Ò⣺Èç¹û²»Âú×ãÏÔʾµÄ¸ñʽ£¬¾Í»á°ÑÊý¾ÝÏÔʾΪ"#"
 
column ÁÐÃû clear £¨Çå³ýÁиñʽ¶¨Ò壩
 
×¢Ò⣺ֻÓÐsqlplusÃüÁî²ÅÓмòд£¬²¢ÇÒÔÚʹÓÃsqlplusÃüÁîʱ½áβҲ²»Äܼӷֺš£
 
Ñ¡Ôñ²Ù×÷
 
order by ÅÅÐò×Ó¾ä ASC£¨Ä¬ÈÏ£¬ÉýÐò£© DESC£¨½µÐò£©
 
order by Ä¿±êÁÐÃû£¨±ðÃû£© ÅÅÐò˳Ðò£¨²»Ð´ÅÅÐò˳Ðò£¬»áĬÈÏΪÉýÐòÅÅÐò£©
 
Àý£ºselect first_name from s_emp order by first_name;
    select first_name from s_emp order by first_name desc;
 
×¢Ò⣺ÉýÐò¿ÕÖµÔÚ½á¹ûµÄĩ⣬½µÐò¿ÕÖµÔÚ½á¹ûµÄ×îÇ°Ãæ¡£
 
where×Ó¾ä
 
where×Ó¾äʹÓÃÔÚ select ... from ... ºóÃæ£¬ÓÃÀ´Ñ¡ÔñËùÐ裨·ûºÏÌõ¼þµÄ£©µÄ¼Ç¼
 
whereºóÃæ¸úµÄÊDZí´ïʽ Ò²¾ÍÊÇ XXX=XXX£¬ XXX between X and X  £¬XXX in£¨X£¬X£¬X£©
like '...' Í¨Åä²éѯ
 
between ... and ... ,±íʾ½á¹ûÔÚÕâÖ®¼ä£¬between andÊÇÒ»¸ö±ÕÇø¼ä£¬
Ò²¾ÍÏ൱ÓÚ... <


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

OracleϵÁУº¼Ç¼Record

 OracleϵÁУº¼Ç¼£¨Record£©
Ò»£¬Ê²Ã´ÊǼǼ£¨Record£©£¿
 Óɵ¥ÐжàÁеıêÁ¿¹¹³ÉµÄ¸´ºÏ½á¹¹¡£¿ÉÒÔ¿´×öÊÇÒ»ÖÖÓû§×Ô¶¨ÒåÊý¾ÝÀàÐÍ¡£×é³ÉÀàËÆÓÚ¶àάÊý×é¡£
½«Ò»¸ö»ò¶à¸ö±êÁ¿·â×°³ÉÒ»¸ö¶ÔÏó½øÐвÙ×÷¡£ÊÇÒ»ÖÖÁÙʱ¸´ºÏ¶ÔÏóÀàÐÍ¡£
 
 ¼Ç¼¿ÉÒÔÖ±½Ó¸³Öµ¡£RECORD1 :=RECORD2£»
 ¼Ç¼²»¿ÉÒÔÕûÌå±È½Ï. ......

¡¾×ª¡¿Oracle Tablespace´´½¨

 Tablespace
ORACLEÖУ¬±í¿Õ¼äÊÇÊý¾Ý¹ÜÀíµÄ»ù±¾·½·¨£¬ËùÓÐÓû§µÄ¶ÔÏóÒª´æ·ÅÔÚ±í¿Õ¼äÖУ¬Ò²¾ÍÊÇÓû§ÓпռäµÄʹÓÃȨ£¬²ÅÄÜ´´½¨Óû§¶ÔÏó£®·ñÔòÊDz»³äÐí´´½¨¶ÔÏó£¬ÒòΪ¾ÍÊÇÏë´´½¨¶ÔÏó,Èç±í,Ë÷ÒýµÈ£¬Ò²Ã»Óеط½´æ·Å,Oracle»áÌáʾ:ûÓд洢Åä¶î£®
¡¡¡¡Òò´Ë£¬ÔÚ´´½¨¶ÔÏó֮ǰ£¬Ê×ÏÈÒª·ÖÅä´æ´¢¿Õ¼ä£®¡¡¡¡
  ·ÖÅä´æ ......

OracleÍⲿ±íСÀý

1)½¨Á¢²Ù×÷ϵͳĿ¼e:\test£¬×¼±¸Êý¾ÝÎļþdept.txt²¢ÖÃÓÚe:\testÖ®ÏÂ
"10","ACCOUNTING","NEW
YORK"
"20","RESEARCH","DALLAS"
"30","SALES","CHICAGO"
"40","OPERATIONS","BOSTON"
2)´´ ......

OracleÊý¾Ý¿â½µµÍHWMµÄ¼¸ÖÖ·½·¨

HWMÊÇoracleÖÐblockÓÐûÓÐʹÓõķֽçÏߣ¬Ëü»áËæ×ÅÊý¾ÝµÄinsert¶øÉÏÉý£¬µ«Ëü²¢²»»áËæÊý¾ÝµÄdelete¶øÏ½µ£¬Òò´ËÈ«±íɨÃèµÄʱ¼ä²¢²»ÒòÊý¾ÝµÄdelete¶ø¼õÉÙ£¬Ïà·´¿ÉÄÜÓÉÓÚ¿éÇå³ý·´¶øÈ«±íɨÃèʱ¼äÔö¼Ó£¬¿ÉÒÔÓÃÏÂÃæ·½·¨µÄÈÎÒ»Ò»ÖÖÀ´½µµÍHWM£º
µÚÒ»ÖÖ£ºshrink
ÊÊÓÃÓÚ10gÒÔºóµÄ°æ±¾£¬Ç°ÌáÊÇÕâ¸ö±í£¬Ë÷Òý£¬ÎﻯÊÓͼ»òÎﻯÊÓͼlogËùÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ