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

µÇ¼oracleÊý¾Ý¿âʱ³£ÓõIJÙ×÷ÃüÁîÕûÀí

¼oracleÊý¾Ý¿âʱ³£ÓõIJÙ×÷ÃüÁîÕûÀí
1¡¢su – oracle ²»ÊDZØÐ裬ÊʺÏÓÚûÓÐDBAÃÜÂëʱʹÓ㬿ÉÒÔ²»ÓÃÃÜÂëÀ´½øÈësqlplus½çÃæ¡£
2¡¢sqlplus /nolog »òsqlplus system/manager »ò./sqlplus system/manager@ora9i;
3¡¢SQL>connect / as sysdba ;£¨as sysoper£©»ò
connect internal/oracle AS SYSDBA ;(scott/tiger)
conn sys/change_on_install as sysdba;
4¡¢SQL>startup; Æô¶¯Êý¾Ý¿âʵÀý
5¡¢ ²é¿´µ±Ç°µÄËùÓÐÊý¾Ý¿â: select * from v$database;
select name from v$database;
desc v$databases; ²é¿´Êý¾Ý¿â½á¹¹×Ö¶Î
7¡¢ÔõÑù²é¿´ÄÄЩÓû§ÓµÓÐSYSDBA¡¢SYSOPERȨÏÞ:
SQL>select * from V_$PWFILE_USERS;
Show user;²é¿´µ±Ç°Êý¾Ý¿âÁ¬½ÓÓû§
8¡¢½øÈëtestÊý¾Ý¿â£ºdatabase test;
9¡¢²é¿´ËùÓеÄÊý¾Ý¿âʵÀý£ºselect * from v$instance£»
È磺ora9i
10¡¢²é¿´µ±Ç°¿âµÄËùÓÐÊý¾Ý±í£º
SQL> select TABLE_NAME from all_tables;
select * from all_tables;
SQL> select table_name from all_tables where table_name like '%u%';
TABLE_NAME
------------------------------
_default_auditing_options_
11¡¢²é¿´±í½á¹¹£ºdesc all_tables;
12¡¢ÏÔʾCQI.T_BBS_XUSERµÄËùÓÐ×ֶνṹ£º
desc CQI.T_BBS_XUSER;
13¡¢»ñµÃCQI.T_BBS_XUSER±íÖеļǼ£º
select * from CQI.T_BBS_XUSER;
14¡¢Ôö¼ÓÊý¾Ý¿âÓû§£º(test11/test)
create user test11 identified by test default tablespace users Temporary TABLESPACE Temp;
15¡¢Óû§ÊÚȨ:
grant connect,resource,dba to test11;
grant sysdba to test11;
commit;
16¡¢¸ü¸ÄÊý¾Ý¿âÓû§µÄÃÜÂ룺(½«sysÓësystemµÄÃÜÂë¸ÄΪtest.)
alter user sys indentified by test;
alter user system indentified by test;


Ïà¹ØÎĵµ£º

[ORACLE]ORACLE ʵÏÖmysqlÖеÄlimit ¹¦ÄÜ

ÏîÄ¿´ÓmysqlÇ¨ÒÆµ½ORACLEÖÐÓöµ½ÒÆÖ²ÎÊÌ⣬mysqlÖÐÖ§³Ölimit ¶øORACLE say no .
½â¾ö·½·¨ ÀûÓÃORACLEµÄαÁÐ rownumÀ´¿ØÖÆ¡£¡£
Mysql : select * from table limit 10
equl
ORACLE£º select * from table where rownum <= 10
ORACLE αÁнéÉÜ£º
ËæÊý¾Ý×ÖµäÒ»Æð×Ô¶¯´´½¨µÄÒ»¸ö±í,ÊôÓÚsysģʽ,ÈκÎÓû§¶¼¿ÉÒÔ·ÃÎÊ,&nbs ......

ORACLE jobʹÓ÷½·¨

EXP/IMP×¢Ò⣺´ÓÈ«¿âÂß¼­±¸·Ý°´Óû§µ¼Èëʱ£¬OracleûÓе¼ÈëJOB£¬²»ÖªµÀÕâ¸öÊÇOracleµÄbug£¬»¹ÊǹÊÒâÕâÑùʵÏֵġ£Õâ¸öÎÊÌâÔÚµ¼ÈëµÄÓû§ÃûºÍµ¼³öµÄÓû§Ãû²»Í¬Ê±³öÏÖ£¬Èç¹ûµ¼ÈëµÄÓû§ÃûºÍµ¼³öµÄÓû§ÃûÒ»Ö£¬Ôò²»»á³öÏÖÕâ¸öÎÊÌâ¡£»³ÒÉÊÇOracleµ÷ÓÃDBMS_IJOB°üʱ³öÏÖµÄÎÊÌâ¡£
×ÜÖ®£¬EXP/IMPµÄʱºòÐèÒª¿¼ÂÇJOB£¬²¢ÔÚ²Ù×÷½áÊøºó¼ì ......

ÓÃradiusºÍoracle×öÈÏÖ¤¼Æ·Ñϵͳ


Redhat
as4 + oracle 10g(10.2.0)
+ freeradius1.1.2+ tomcat5.5
*****************************
±¾ÎÄĿ¼
********************************
Ò»¡¢°²×°
redhat as4
¶þ¡¢°²×°
oracle 10g
£¨
10201_database_linux32.zip
£©
   
£¨Ò»£©¼ì²é
oracle 10g
ËùÐèµÄ°ü×é¼þ£º
£¨¶þ£©ÉèÖÃϵͳ²ÎÊ ......

SQL ServerºÍOracleµÄ³£Óú¯Êý¶Ô±È

---------Êýѧº¯Êý
1.¾ø¶ÔÖµ
S:select abs(-1) value
O:select abs(-1) value from dual
2.È¡Õû(´ó)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£©
S:select floor(-1.001) value
O:select floor(-1.001) value from dual
4.È¡Õû£¨½ØÈ¡£©
S:select cast(-1.002 as int) v ......

oracleÈÕÆÚº¯Êý¼¯½õ

Ò»¡¢ ³£ÓÃÈÕÆÚÊý¾Ý¸ñʽ
1.Y»òYY»òYYY ÄêµÄ×îºóһ룬Á½Î»»òÈýλ
SQL> Select to_char(sysdate,'Y') from dual;
TO_CHAR(SYSDATE,'Y')
--------------------
7
SQL> Select to_char(sysdate,'YY') from dual;
TO_CHAR(SYSDATE,'YY')
---------------------
07
SQL> Select to_char(sysdate,'YYY') from d ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ