Oracle ѧϰ֪ʶµã£¨Ò»£©

 Ò» µÇ¼SQLPLUS
    sqlplusÓû§Ãû/ÃÜÂë@Êý¾Ý¿âʵÀýasµÇ¼½ÇÉ«;
Èç:Óû§sys(ÃÜÂëΪ123)ÒÔsysdbaµÄ½ÇÉ«µÇ¼Êý¾Ý¿âORACL£¬ÎÒÃÇ¿ÉÒÔÊäÈ룺sqlplus sys/123@oracl as sysdba;
    ÕâÖֵǼ·½Ê½»áÖ±½Ó±©Â¶ÃÜÂ룬Èç¹ûÏëÒþ²ØÃÜÂ룬¿ÉÒÔÔÚ´ËÊ¡ÂÔÃÜÂëµÄÊäÈ룬È磺sqlplus sys@oracl as sysdba;»Ø³µÒÔºóORACLE»á¸ø³öÊäÈëÃÜÂëµÄÌáʾ·û¡£
    µÇ¼ÒÔºóÈç¹ûÏëÇл»ÆäËûµÄÓû§£¬¿ÉÒÔÖ±½ÓʹÓÃconnect ÃüÁî,È磺connect user2/password@oracl as sysdba,ͬÉÏÒ»Ñù£¬¿ÉÒÔ½«ÃÜÂë·Ö¿ªÊäÈë¡£
Oracle ·ÖÒ³ºÍÅÅÐò³£ÓõÄ4Ìõ²éѯÓï¾ä
1. ²éѯǰ10Ìõ¼Ç¼
¡¡¡¡SELECT * from TestTable WHERE ROWNUM <= 10
¡¡¡¡2. ²éѯµÚ11µ½µÚ20Ìõ¼Ç¼
¡¡¡¡SELECT * from (SELECT TestTable.*, ROWNUM ro from TestTable WHERE ROWNUM <=20) WHERE ro > 10
¡¡¡¡3. °´ÕÕname×Ö¶ÎÉýÐòÅÅÁкóµÄÇ°10Ìõ¼Ç¼
¡¡¡¡SELECT * from (SELECT * from TestTable ORDERY BY name ASC) WHERE ROWNUM <= 10
¡¡¡¡4. °´ÕÕname×Ö¶ÎÉýÐòÅÅÁкóµÄµÚ11µ½µÚ20Ìõ¼Ç¼
¡¡¡¡SELECT * from (SELECT tt.*, ROWNUM ro from (SELECT * from TestTable ORDER BY name ASC) tt WHERE ROWNUM <=20) WHERE ro > 10
¶þ¡¢±íµÄ²Ù×÷
1¡¢ÐÞ¸ÄÁеÄÊý¾ÝÀàÐÍ»òÁÐÃû£¨²»ÄÜÓÐÊý¾Ý£©
SQL>alter table±íÃûmodify(ÁÐÃû ÁÐÊý¾ÝÀàÐÍ);
2¡¢Ìí¼ÓÒ»¸ö×Ö¶Î
SQL>alter table±íÃûadd(ÁÐÃû ÁÐÊý¾ÝÀàÐÍ);
3¡¢É¾³ýÒ»¸ö×Ö¶Î
SQL>alter table ±íÃûdrop column ÁÐÃû;
4¡¢Ð޸ıíÃû
SQL>rename ¾É±íÃûto бíÃû;
5¡¢²åÈëÈÕÆÚ×Ö¶Î
OracleÖÐĬÈϵĸñʽΪ"dd-mm-yy"Èç‘20-5ÔÂ-87’ÆäÖÐÔÂÒ»¶¨ÒªÎªºº×Ö£»
¸ü¸ÄÈÕÆÚµÄĬÈϸñʽ:alter session nls_date_format='yyyy-mm-dd';
6¡¢²åÈë¿ÕÖµ
insert into student(xh,xm,sex,birthday)values('1001','СÃ÷',null)
²éѯµÄʱºòselect * from student where birthday is (not)null;
7¡¢Ð޸ĺ¬ÓÐnullµÄÊý¾Ý
update student set sex='Å®' where birthday is null;
8¡¢É¾³ýÊý¾Ý
delete from ±íÃû ɾ³ýËùÓеļǼ£¬±í½á¹¹»¹ÔÚ£¬Ð´ÈÕÖ¾£¬¿ÉÒÔ»Ö¸´£¬É¾³ýËÙ¶ÈÂý£»
drop table±íÃû;ɾ³ý±íµÄ½á¹¹ºÍÊý¾Ý£»
truncate table±íÃû£ºÉ¾³ýËùÓеļǼ£¬±í½á¹¹»¹ÔÚ£¬²»Ð´ÈÕÖ¾£¬ÎÞ·¨ÕÒ»Øɾ³ýµÄ¼Ç¼£¬É¾³ýËٶȿì
Èý¡¢±íµÄ¸´ÔÓ²éѯ
1¡¢·Ö×é²éѯµÄ×ܽá
A¡¢·Ö×麯ÊýÖ»ÄܳöÏÖÔÚÑ¡ÔñÁÐ±í¡¢Having¡¢Order by×Ó¾äÖÐ
B¡