OracleÓû§¹ÜÀí
oracleÓû§¹ÜÀí
ÖÆ×÷ÈË£ºÏòÏȺ¯
ÈÕÆÚ 2009-5-21
Æô¶¯-------------------------------------------------------------------
Æô¶¯¼àÌý Lsnrctl start ;
Æô¶¯ÊµÀý oradim -starup –sid orcl;
ȨÏÞ£º-----------------------------------------------------------------
´´½¨Óû§ create user lisi identified by lisi ;
´´½¨Óû§È¨ÏÞ grant create session to lisi;
´´½¨±íȨÏÞ grant create table to lisi;
´´½¨±í¿Õ¼äȨÏÞ grant unlimited tablespace to lisi;
³·ÏúȨÏÞ revoke create table from lisi;
²é¿´È¨ÏÞ select * from user_sys_privs;(ÆäÖÐuser_sys_privsÊÇÒ»¸öÊÓͼ)£¨ÏµÍ³£©
²é¿´µ±Ç°ÊÚȨ select * from user_tab_privs;(ÆäÖÐuser_tab_privs Êǵ±Ç°ÊÓͼ)£¨¶ÔÏó£©
²é¿´ÁÐÓÃÊý¾Ý×Öµäcol select * from user_col_privs
³·ÏúʹÓÿռäµÄȨÏÞ revoke unlimited tablespace from lisi;
²Ù×÷
²åÈëÒÔºó±ØÐëÊÖ¶¯Ìá½»²ÅÄÜÉúЧ commit£» ͬʱֻÓÐsysÓû§¿ÉÒÔ·ÃÎÊ
ÆÕͨÓû§ÊÚȨÈçÒªÔÚlisiÓû§ÀïÃæ·ÃÎÊwangwuµÄÓû§¾ÍÒªÉ趨
ÔÚwangwuÖÐ grant select on mytab to lisi; (²éѯÊÚȨ)
grant insert on mytab to lisi; (²åÈëÊÚȨ)
¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
&nb
Ïà¹ØÎĵµ£º
1. ¸´ÖƱí½á¹¹¼°ÆäÊý¾Ý£º
create table table_name_new as select * from table_name_old
2. Ö»¸´ÖƱí½á¹¹£º
create table table_name_new as select * from table_name_old where 1=2;
»òÕߣº
create table table_name_new like table_name_old
3. Ö»¸´ÖƱíÊý¾Ý£º
Èç¹ûÁ½¸ö±í½á¹¹Ò»Ñù£º
insert into table_name_ ......
The following are number examples for the to_char
function.
to_char
(1210.73,
'9999.9')
would return '1210.7'
to_char
(1210.73,
'9,999.99')
would return '1,210.73'
to_char
(1210.73,
'$9,999.00')
would return
'$1,210.73'
to_char
(21,
'000099')
would return '000021'
The foll ......
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;
mso-font-charset:2;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:0 268435456 0 0 -2147483648 0;}
@font-face
{font-family:ËÎÌå;
panose-1:2 1 6 0 3 1 1 1 ......
ÔÚoracleÖУ¬ÎÒÃÇʹÓÃin·½·¨²éѯ¼Ç¼µÄʱºò£¬Èç¹ûinºóÃæµÄ²ÎÊý¸öÊý³¬¹ý1000¸ö£¬ÄÇô»á·¢Éú´íÎó£¬ÏÂÃæµÄÕâ¸ö·½·¨¾ÍÊǽâ¾öÕâ¸öÎÊÌâµÄ£¬Ëü½«ÎÒÃǵÄÉÏǧ¸ö²ÎÊý·Ö³É¼¸×飬±£Ö¤Ã¿×éµÄ²ÎÊý¸öÊý²»³¬¹ý1000
/**
* Éú³É·ûºÏÌõ¼þµÄsqlÓï¾ä,½â¾öinÎÊÌâ
* @param sqlParam£ºÎÒÃÇÐèÒª´¦ÀíµÄ²ÎÊýµÄ×Ö·û´®¸ñʽ£¬ÀýÈ ......