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

oracleÖеĵ¥ÒýºÅºÍË«ÒýºÅ

ÔÚOracleÖУº
¡¡¡¡Ë«ÒýºÅµÄ×÷ÓÃÊÇ£ºÈç¹û´´½¨¶ÔÏóµÄʱºò£¬¶ÔÏóÃû¡¢×Ö¶ÎÃû¼ÓË«ÒýºÅ£¬Ôò±íʾOracle½«ÑϸñÇø·Ö´óСд£¬·ñÔòOracl¶¼Ä¬ÈÏ´óд¡£
¡¡¡¡¶øµ¥ÒýºÅÔò±íʾ£ºÕâ¸ö¼ÓÁ˵¥ÒýºÅµÄ×Ö¶ÎÊÇÒ»¸ö×ÖÀàËÆ×Ö·û´®£¬²¢²»Çø·Ö´óСд¡£
¡¡¡¡µ¥ÒýºÅÓÃÓÚ±êʶ×Ö·ûÓëÊý×ÖµÄÇø±ð
¡¡¡¡µ±Ö¸¶¨×Ö·û´®Îı¾Ê±£¬±ØÐëÓõ¥ÒýºÅ½«×Ö·û´®Îı¾Òýס¡£
¡¡¡¡Oracle10g֮ǰ£¬Èç¹û×Ö·û´®Îı¾ÀﺬÓе¥ÒýºÅ£¬ÄÇô±ØÐëʹÓÃÁ½¸öµ¥ÒýºÅ±íʾ¡£ÀýÈ磺I'm a String!
¡¡¡¡×Ö·û´®Îı¾ÔòΪ£ºstring_var:='I''m a String!'
¡¡¡¡ÔÚoracle10gÖпÉÒÔʹÓÃÆäËü·Ö¸ô·û£¨<>,[],{}µÈ£©,×¢Ò⣬ʹÓÃÕâЩ·Ö¸ô·ûʱ£¬²»½öÒªÔÚ·Ö¸ô·ûǰºó¼Óµ¥ÒýºÅ£¬»¹Òª´øÓÐǰ׺q.Àý£ºstring_var:=q'[I''m a String!]';
¡¡¡¡ÀýÈç
¡¡¡¡select * from table_name where id=1;ÕâÖÖ´ú±í²éѯµÄÊÇÊý×Ö
¡¡¡¡select * from table_name where id='1';ÕâÖÖ´ú±í²éѯµÄÊÇ×Ö·û
¡¡¡¡Èç¹ûÊÇË«ÒýºÅÊÇÕâÑù£¬¼ÙÈçÄãÓиö±íµÄ×ֶνÐsysdate£¬ÒòΪsysdateÊôÓÚoracleÖеÄÌØÓÐ×Ö·û£¬µ«ÄãÒª²éѯÕâ¸ö×ֶεÄʱºò
¡¡¡¡select "sysdate" from table_name;
¡¡¡¡µ«ÊÇÄãÒªÊÇÓÃ
¡¡¡¡select 'sysdate' from table_name;
¡¡¡¡ÄÇôÄã²é³öÀ´µÄ¾ÍÊÇ×Ö·û´®£¬½á¹ûÊÇsysdate
¡¡¡¡Ê¹ÓÃÈçϵĸüÐÂÓï¾ä²»ÐУºupdate device set dept='select * from message where name='tom' ' ;
¡¡¡¡½â¾ö·½·¨£º
¡¡¡¡update device set dept='select * from message where name=' 'tom' '  where  id=3' ;
¡¡¡¡Ö´Ðгɹ¦¡£
¡¡¡¡Ô­À´£¬Á½¸ö'' ±íʾÁËÒ»¸ö'
ÁíÍ⣺
ÔÚsqlÖпÉÓÃ+½øÐÐ×Ö·û´®Á¬½Ó.
ÔÚoracleÖÐÊÇÓÃ||½øÐÐ×Ö·û´®Á¬½Ó


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

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

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

oracle±Ê¼Ç

--oralceÖдӱíÖÐËæ»úÈ¡³önÌõ¼Ç¼
select * from  (select t.*,dbms_random.random num from fms_branch_info t order by num)    
where rownum <= 5;
--ȡǰʮÐÐ
SELECT t.* from fms_branch_info t
WHERE ROWNUM != 10
--WHERE ROWNUM between 1 and 10
ORDER BY branch_code;
......

¡¾oracleÐòÁÐרÌâ¡¿£¨×ªÔØ£©

ORACLEûÓÐÏóSQL SERVERÖÐÒ»ÑùµÄ×ÔÔö¼Ó×ֶΣ¬ÒªÊµÏÖÖ»ÄÜͨ¹ýSEQUENCEÀ´ÊµÏÖ
1.´´½¨ÐòÁУº
create sequence your_seq
nocycle
maxvalue 9999999999
start with 1;
2.ʹÓô¥·¢Æ÷ʵÏÖ×ÔÔö£º
create or replace trigger your_seq_tri
before insert on your_table1 for each row
declare
next_id number;
begin
se ......

Oracle´æ´¢¹ý³Ì£¬º¯Êý¡£

--ÔÚÓ¦ÓóÌÐòÖÐÍùÍùÓÐЩ¹Ì¶¨µÄÊý¾Ý¿â²Ù×÷£¬ÎÒÃdz£³£ÎªÖÂл¹Ì¶¨µÄ²Ù×÷¶¨ÒåÁËһЩ´æ´¢¹ý³Ì¡£ÕâЩ´æ´¢¹ý³Ì²»½ö
--¿ÉÒÔ¼ò»¯¿Í»§¶ËµÄÓ¦ÓóÌÐòµÄ¿ª·¢ºÍά»¤¡£¶øÇÒ»¹¿ÉÒÔÌá¸ßÓ¦ÓõÄÔËÐÐÐÔÄÜ¡£
-- ´´½¨´æ´¢¹ý³ÌµÄÓï·¨¡£
create [or replace] procedure <¹ý³ÌÃû>[(²ÎÊý)]
is|as
[¾Ö²¿±äÁ¿ÉùÃ÷]
begin
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ