oracleµÄ»ù±¾ÖªÊ¶
Oracle
SqlServer2000 2005
MySql
DB2
ORACLE sun SUN
Êý¾Ý¿â DataBase db
´æ´¢Êý¾Ý
Êý¾Ý Data
Êý×Ö ·ûºÅ ×Ö·û ÐÅÏ¢
DBMS Êý¾Ý¿â¹ÜÀíϵͳ
SQL : ½á¹¹»¯²éѯÓïÑÔ
±ÊÊÔ: scjp sql 20 - 30%
Oracle 10g XE
Oracle 9i
SQL:
CRUD
Ôöɾ¸Ä²é
DDL
DML
DCL: DBA
²éѯÊý¾Ý¿âÖÐËùÓеıí:
select table_name from user_tables;
SELECT Òª²éµÄÊý¾Ý from ´ÓÄÄÀï²é
1. ²éʲô
2. ´ÓÄÄÀï²é
²éѯ s_emp ËùÓÐÐÐËùÓÐÁÐ
select * from s_emp ;
Ö¸¶¨Áвéѯ (×Ö¶ÎÃûÖ®¼äʹÓöººÅ·Ö¸ô)
select first_name , last_name from s_emp ;
SELECT last_name, salary * 12, commission_pct from s_emp;
ʹÓÃNVLº¯Êý¿ÕÖµÎÊÌâ
SELECT last_name, title, salary*commission_pct/100 + salary from s_emp;
SELECT last_name, title, salary*NVL(commission_pct,0)/100 + salary from s_emp;
×ֶαðÃû
as ±ðÃû " ±ð Ãû "
×Ö·ûÁ¬½Ó
select first_name || last_name " ÐÕ Ãû " from s_emp ;
DISTINCT &n
Ïà¹ØÎĵµ£º
extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î» --segment management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......
ÒÔϾÝ˵ÃüÁî¾ùÖ¸ÔÚPL/SQLÖУ¬ÔÚCommand WindowÖÐÖ´ÐеÄÃüÁî¡£
²»¶ÏËѼ¯ÕûÀí
1¡¢the account is locked"µÄ½â¾ö·½·¨
ÓÃsysÒÔsysdbaµÄÉí·ÝÀ´½øÐеǼ,ÔÚsys״̬ÊÇlockedµÄʱºòÒ²ÊÇÄܵǼµÄ.È»ºóÔÙʹÓÃÃüÁî
alter user sys account unlockÀ´½øÐнâËø ......
ÓÐʱºòÎÒÃÇ¿ÉÄܲ»ÖªµÀÒ»¸öÓû§µÄÃÜÂ룬µ«ÊÇÓÖÐèÒªÒÔÕâ¸öÓû§×öһЩ²Ù×÷£¬ÓÖ²»ÄÜÈ¥Ð޸ĵôÕâ¸öÓû§µÄÃÜÂ룬Õâ¸öʱºò£¬¾Í¿ÉÒÔÀûÓÃһЩСÇÏÃÅ£¬À´Íê³É²Ù×÷¡£
¾ßÌå²Ù×÷¹ý³ÌÈçÏ£º
SQL*Plus: Release 9.2.0.5.0 - Production on ÐÇÆÚÈÕ 11ÔÂ 21 13:32:34 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reser ......
ǰÑÔ£º
OracleµÄ¶Ô±í²Ù×÷ÖÐÓÐÒ»ÖÖÀàËÆÓÚDataSetµÄ¶ÔÏó²Ù×÷·½·¨CURSOR£¬Ëü¿ÉÒÔͨ¹ý½¨Á¢±íµÄ²Ù×÷¶ÔÏó»òÕß˵±íµÄÖ¸Õë¶ÔÏóÀ´´ïµ½´Ó±íÀïÃæÌáÈ¡Êý¾ÝµÄ²Ù×÷¡£
˵Ã÷£º
Ò»°ãͨ¹ýSQLÓïÑÔ¿ÉÒÔÕë¶Ôij¸ö±íµÄijһÐлò¶àÐÐÊý¾Ý½øÐвÙ×÷±ÈÈç˵SELECT£¬UPDATEµÈ¡£ÕâЩ²Ù×÷±ØÐëÒÔSQLÓï¾äµÄÓï·¨¸ñʽÀ´±»½âÊÍÆ÷½âÊͲ¢Ö´ÐС£ÔÚʵ¼ ......
-- ²éѯÍâ¼üÔ¼Êø(²éij±íµÄËùÓи¸±í)
select c.constraint_name,cc.column_name,rcc.owner,rcc.table_name,rcc.column_name
from user_constraints c,user_cons_columns cc,user_cons_columns rcc
where c.owner=' ......