oracleÈçºÎɾ³ýÓû§µÄËùÓжÔÏ󣬱£ÁôÓû§
¸Õ¿ªÊ¼Ó㬲»Ì«»á£¬dropÔÙcreateµÄÇëÈÆÐÐ
SQL code:
select 'drop '||object_type||' ' || object_name ; '
from dba_objects
where owner = 'yourUser'
http://edu.codepub.com/2009/0616/6398.php
Äã¿ÉÒÔ¿´Ò»ÏÂÕâ¸ö£¬½éÉܵĻ¹ÊǺÜÏêϸµÄ
Ïà¹ØÎÊ´ð£º
ÈÕÇ°ÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......
3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£
ûÓÐORACLE ERPµÄ¾Ñé,ÓÐÓÃÓѺÍTIPTOP¾Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
MSSQL2000 to Oracle 10g, text×Ö¶ÎÔõô´¦Àí£¿
ÓÃdtsµ¼Èë\µ¼³ö¹¤¾ß£¿
ѧϰ°ï¶¥²ä·Ö
sql server ÖÐµÄ±íµ¼µ½oracleÖУ¬ÔÚoracleÖжÔÓ¦textµÄÊý¾ÝÀàÐÍÊÇclobÀàÐÍ¡£
ÀûÓÃsqlserverµÄµ¼Èëµ¼³ö¹¦ÄÜ
× ......
ÇóoracleÓï·¨Îĵµ(chm)
kennth@126.com
Ô½ÐÂÔ½ºÃ
ÎÒÀ´½Ó·Ö£¬Ã»ÓÐеÄ
×Ô¼ºÈ¥ÏÂ
ÒýÓÃ
ÎÒÀ´½Ó·Ö£¬Ã»ÓÐеÄ
×Ô¼ºÈ¥ÏÂ
µ¹..ÄãÊÇרÃÅËÑË÷ËÍ·ÖµÄÎÄÕÂ?..ÄÄÀﶼ¼ûµ½Äã,,
........ ......