Oracle´´½¨Óû§µÄÆæ¹ÖÎÊÌ⣿µÈ´ý¸ßÊÖ½â»ó
»·¾³ 10G
ʹÓÃem´´½¨Ò»¸öÓû§£¬Ò»ÇÐÕý³££¬
Óô´½¨Õâ¸öÓû§µÄ sqlÓï¾äÔÚ isql*plus ´´½¨ÁíÍâÒ»¸öÓû§
CREATE USER "Tim" PROFILE "DEFAULT" IDENTIFIED BY "*******" ACCOUNT UNLOCK
Ö»ÊÇÐÞ¸ÄÁËÓû§ÃûºÍÃÜÂë,Ò²Ìáʾ´´½¨³É¹¦¡£¶øÇÒÔÚemÀï±ß¿ÉÒÔ¿´µ½Õâ¸öÓû§ Tim
µ«ÊǽÓÏÂÀ´ Ö´ÐÐÊÚȨ²Ù×÷ grant create table to Tim
µÄʱºòÌáʾÎÒÓû§ºÍ½ÇÉ«²»´æÔÚ¡£
ºóÀ´·¢ÏÖÎ¨Ò»Çø±ðÊÇ£¬ÎÒʹÓÃem´´½¨µÄÓû§ÔÚemÀï±ßÏÔʾ¶¼ÊÇ´óдÃû×Ö£¨ÎÞÂÛÎÒ´´½¨µÄʱºòÊäÈë´óд»¹ÊÇСд£©
¶øÊ¹ÓÃisql*plus´´½¨µÄÓû§ ÔòÔÚemÀï±ßÏÔʾµÄÊÇÎÒµ±Ê±´´½¨Ê±ºòÊäÈëµÄ´óдС¹æÔò¡£
µ«ÕâÑùÔÙÊÚȨ¾ÍÊDz»ÐС£
ºóÀ´ÎÒ³¢ÊÔͬÑùµÄÓï¾ä£¬ÎÒ°ÑÓû§ÃûÈ«´óд£¬¾Í¶¼¿ÉÒÔÁË¡£
²éѯÓï¾äÀï±ßÎÒ´óСдÔõôÑù±ä»¯¶¼¿ÉÒԲ鵽Õâ¸öÓû§¡£¡£
ÕæÆæ¹Ö°¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡
¶¼ÊÇ""ÈǵĻö~
CREATE USER Tim PROFILE DEFAULT IDENTIFIED BY ******* ACCOUNT UNLOCK
SQL> CREATE USER "Tim" PROFILE "DEFAULT" IDENTIFIED BY "Tim" ACCOUNT UNLOCK;
Óû§ÒÑ´´½¨¡£
SQL> grant connect to tim;
grant connect to tim
*
µÚ 1 ÐгöÏÖ´íÎó:
ORA-01917: Óû§»ò½ÇÉ« 'TIM' ²»´æÔÚ
SQL> grant connect to Tim;
grant connect to Tim
&nb
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
ÎÊÌâÌá³ö£º
Ò»¸ö¸ß¼¶SQLÓï¾äÎÊÌâ
¼ÙÉèÓÐÒ»ÕÅ±í£¬AºÍB×ֶζ¼ÊÇNUMBER£¬
A B
1 2
2 3
3 4
4
ÓÐÕâÑùһЩÊý¾Ý
ÏÖÔÚÏëÓÃÒ»ÌõSQLÓï¾ä£¬²éѯ³öÕâÑùµÄÊý¾Ý
COLA COL1 COL3 COL2 COL1
4 4 ......