Oracle Database µÄѧϰ±Ê¼Ç
SQL:½á¹¹»¯²éѯÓïÑÔ
C R U D: Ôöɾ¸Ä²é
table : name age score
desc+±íÃû ---> ²éѯ±í½á¹¹
»òÕßÓà describe ÃüÁî (descÊÇdescribeµÄ¼òд)
²éѯÓïÑÔ£ºSELECT [DISTINCT] {*,column[alias],...} from table;
SELECT identifies what columns from identifies which table
******* SELECT ²éʲô from ´ÓÄÄÀï²é *******
SELECT dept_id,last_name,manager_id from s_emp;
Óöµ½¿Õֵʱ¿ÉÒÔÕâÑù²Ù×÷£º
SELECT last_name,title,salary*NVL(commission_pct,0)/100 COMM from s_emp;
Åųý²éѯʱ³öÏÖÖØÃûÏÖÏó £¬Óùؼü×Ö DISTINCT
eg: SELECT DISTINCT name from s_dept;
ÅųýÁ½¸ö×Ö¶ÎÁ¬ºÏÆðÀ´»¹ÓÐÖØ¸´µÄÏÖÏó£º
eg: SELECT DISTINCT dept_id,title from s_emp;
¶Ô²éѯµÄ½á¹û½øÐÐÅÅÐòÓà ORDER BY;
eg: SELECT last_name "ÐÕÃû",salary "¹¤×Ê" from s_emp ORDER BY salary;
(ĬÈÏÊÇÉýÐòÅÅÐò)
eg: SELECT last_name "ÐÕÃû",salary "¹¤×Ê" from s_emp ORDER BY salary asc;
(ascÖ¸¶¨ÎªÉýÐòÅÅÐò)
eg: SELECT last_name "ÐÕÃû",salary "¹¤×Ê" from s_emp ORDER BY salary desc;
(descÖ¸¶¨Îª½µÐòÅÅÐò)
×ܽ᣺order by ÅÅÐò
asc ÉýÐò
desc ½µÐò
select last_name EMPLOYEE,start_date from s_emp order by EMPLOYEE desc;
(ÔÚÅÅÐòµÄʱºò¿ÉÒÔÓñðÃûµ±×ö×Ö¶Î[ÅÅÐòµÄ¸ù¾Ý]½øÐÐÅÅÐò)--->ÕâÀïÊÇ£¨EMPLOYEE£©¡£
select last_name,salary*12 from s_emp order by 2;
(ÕâÀïµÄ2ÊÇÓÃÀ´Ö¸¶¨×ֶεÄλÖã¬ÕâÀïÖ¸Ïò salary*12 ,¼´°´Ô±¹¤µÄÄêнÅÅÐò)
select last_name,dept_id,salary from s_emp order by dept_id,salary desc;
(ÏȰ´dept_idµÄÉýÐò½øÐÐÅÅÐò£¬ÅÅÍêºóÔÙ°´salaryµÄ½µÐò½øÐÐÅÅÐò)
×¢£ºÕâÀïdept_idºóûÓÐÖ±½ÓÖ¸ÅÅÐò¹æÔò£¬°´Ä¬ÈϵÄÉýÐòÅÅÐò¡£
WHERE¹Ø¼ü×Ö£º
SELECT ÐÕÃû£¬²¿ÃÅID from s_emp WHERE dept_id = 42;
(
Ïà¹ØÎĵµ£º
´æ´¢¹ý³Ì¾ÍÊÇ×÷Ϊ¿ÉÖ´ÐжÔÏó´æ·ÅÔÚÊý¾Ý¿âÖеÄÒ»¸ö»ò¶à¸öSQLÃüÁî¡£
¶¨Òå×ÜÊǺܳéÏó¡£´æ´¢¹ý³ÌÆäʵ¾ÍÊÇÄÜÍê³ÉÒ»¶¨²Ù×÷µÄÒ»×éSQLÓï¾ä£¬Ö»²»¹ýÕâ×éÓï¾äÊÇ·ÅÔÚÊý¾Ý¿âÖеÄ(ÕâÀïÎÒÃÇ̸ֻSQL Server)¡£Èç¹ûÎÒÃÇͨ¹ý´´
½¨´æ´¢¹ý³ÌÒÔ¼°ÔÚASPÖе÷Óô洢¹ý³Ì£¬¾Í¿ÉÒÔ±ÜÃ⽫SQLÓï¾äͬASP´úÂë»ìÔÓ ......
ÉîÈëÁ˽âOracle SCN (1)
--------------------------------------------------------------------------------
£Û˵Ã÷£Ý±¾À´ÔÚÑо¿Backup and Recovery£¬¿ÉÊÇÔÚ×öʵÑéµÄʱºòÓöµ½Ò»Ð©ÎÊÌâ²»ÊǺÜÀí½â£¬½ø¶ø×·¸ùÇóÔ´£¬Ïë¸ãÇå³þ£¬ÓÚÊDZØÐë¸ãÇå³þSCNºÍRecoveryÖ®¼äµÄ¹ØÏµ¡£ÓÚÊǺõת¶øÑо¿SCN£¬ÕâÁ½Ìì¿´Á˺ܶàÎÄÕ£¬°üÀ¨EygleÍ ......
* start Oracle *
set noexec_user_stack=1
set msgsys:msginfo_msgmax=65535
set msgsys:msginfo_msgmnb=65535
set msgsys:msginfo_msgmap=258
set msgsys:msginfo_msgmni=1792
set msgsys:msginfo_msgssz=32
set msgsys:msginfo_msgtql=1792
set msgsys:msginfo_msgseg=32767
set shmsys:shminfo_shmmax=4294967 ......
oracle
Îóɾ³ýÈÕÖ¾ÎļþºóµÄ´¦Àí·½·¨£¡
½â¾ö·½·¨±³¾°
1
ÕûÀíc
Å̵ÄÀ¬»øÎļþ£¬°Éoralce
µÄ¡£log
ÈÕÖ¾Îļþɾ³ý¡£
2
È»ºóoralce
Ò»Ö±²»ÄÜʹÓã¬Ìáʾtns
ÓÐÎÊÌ⣬
È»ºóÔÙÍùÉÏÕÒ×ÊÁÏ£¬Ò»Ö±Ã»Óнâ¾öµô£¬ºóÀ´¿´µ½Ò»±ßÎÄÕÂÈçÏ£¬ÎÊÌâ½â¾öµôÁË£¬Ìغʹó¼Ò·ÖÏí£¡
======================================== ......