Êý¾Ý¿âËùÔÚÓ²Å̿ռäʣϵIJ»¶àÁË£¬ËùÒÔÎÒɾ³ýÁËһЩ²»ÐèÒªµÄÓû§£º
drop user B0901 cascade;
drop user B0902 cascade;
drop user B0903 cascade;
µ«ÊÇɾ³ýÓû§ºó£¬¿Õ¼äÒ»µã±ä»¯¶¼Ã»ÓС£¡£¡£
Õ⼸¸öÓû§Ê¹ÓõÄTABLESPACE¶¼ÊÇUSERS
ÏÖÔÚÎÒ²éϵͳÖл¹ÓкܶàÓû§Ê¹ÓÃÕâ¸öUSERS±í¿Õ¼ä£º
SQL> select username,default_tablespace from dba_users;
USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
A0908 USERS
A0901 USERS
A0904 USERS
A0907 USERS
A0909 USERS
A0905 USERS
ÏÖÔÚÎÒµÄÎÊÌâÊÇ£¬ÈçºÎÒªÊÍ·ÅÒѾɾ³ýÓû§ËùÕ¼ÓõĴÅÅ̿ռ䣬¶ø²»Ó°ÏìÆäËûʹÓÃUSERS±í¿Õ¼äµÄÓû§£¿
ÄÇÄãÊDz»ÊǴ󲿷ֵÄobjects²¢²»ÊÇÔÚusrsÀïÃæ°¡¡£
USERNAME DEFAULT_TABLESPACE
Ïà¹ØÎÊ´ð£º
ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......
<?php
getenv("ORACLE_HOME");
$conn=ocilogon("test","test","test_db");
if($conn)
echo success;
&nb ......
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
ÔÚoracleÖÐÓÃjdbcÀ´Á¬½ÓÊý¾Ý¿â£¬ÎªÊ²Ã´ResultsetÀïÃæÇ¶Ì×ResultSet,µ½Ñ»·µÄµÚ¶þ´Î¾Í±¨¿ÕÖ¸Õ룬ÄÄλ֪µÀÊÇÔõô»ØÊÂÂð£¿
´úÂ룺Java code:
while(prors.next()){
System.out.println(prors.getRow ......