ÎÒÐèÒªÓÃVBÁ¬½ÓOracle²¢ÏÂÔØblo£â×ֶΣ¬
ÎÒÓÃÒÔÏÂÁ¬½Ó·½Ê½£¬³ÌÐòʼÖÕ²»ÄÜʶ±ð£â£ì£ï£â×ֶΣ¬
connStr = "Provider=msdaora;Persist Security Info=False;User ID=" & _
uid & ";Password=" & pwd & ";Data ......
Âé·³ÎÊһϸ÷룬ORA-00942£ºtable or view does not existÔõô½â¾ö°¢£¬Ð»Ð»¸÷λÁË
Ò»°ã´íÎó:
Äã²éµ½±íÔÚÄãµÄµ±Ç°Óû§ÏÂÃæÓÐȨÏÞ²éѯ,»òÕß±í²»´æÔÚ
ÀýÈç DBA²éѯSCOTTµÄÓû§
Òª¼ÓÉϱíËùÔÚµÄÓû§
SELECT *¡¡from SCOTT.EMP;
ÒýÓÃ
Âé·³ÎÊһϸ÷룬ORA-00942£ºtable or view does not existÔõô½â¾ö°¢£¬Ð»Ð» ......
ΪÁË´ó¼ÒºÃºÃѧϰÒÔ¼°ÔÚ¹¤×÷ÖÐÓöµ½ÎÊÌâÄܹ»ºÍ´ó¼ÒÒ»Æð½â¾ö
ºÍѧϰ
ΪÁË Ñ§Ï°µÄ¶øÑ§Ï°ÎªÁË·³ÄÕ²»ÔÚ·³ÄÕ...ÆÚ´ý´ó¼ÒµÄ¼ÓÈë.....
ȺºÅ:2987841
¶¥
¶¥heÀϴ󣬱ØÐë¶¥
¶¥....Ⱥ¹æÔòÒ²·¢Ï°É
ding
²»ÊǰÉ,Ó¦¸ÃÈ¥AJAX¼¼Êõ×¨Çø°É
¶¥Æð¡£¡£¡£¡£ -ÃÔʧ
¶¥Æð¡£¡£¡£¡£ -ÃÔʧ
¶î£¬ÀÏ´óÏÖÔÚÍæjquery
......
oracle Êý¾Ý¿âÏÂдµÄ´æ´¢¹ý³Ì
CREATE OR REPLACE PROCEDURE "TEST" is
cursor cur1 is select unique month from tb order by month;
begin
for p in cur1
loop
alter table tb1 add(p.month varchar2(40));
end loop;
end;
Õâ¾äΪʲô×ÜÊDZ¨´íÄ ......
ÎÒÓÐOracleµÄȨÏÞ£¬ÏëÖªµÀÔõÑù²éѯÆäÖеÄËùÓбí¿Õ¼ä
ÊÇsqlplusµÄ£¬Ã»ÓпÉÊÓ»¯µÄ´°¿Ú
SQL code:
SELECT tablespace_name,file_name from dba_data_files;
select * from dba_tablespaces
SQL> select name from v$tablespace;
NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAU ......
ÎÒÓÃ×Ô¼º´´½¨µÄÓû§Ãû£¨kkk£©ºÍÃÜÂëµÇ½ÁË£¬ÈçºÎ²éѯ³ökkkÕâ¸öÓû§Ëù´´½¨µÄ
´æ´¢¹ý³ÌÃû
º¯ÊýÃû
°üÃû?
SQL code:
SELECT object_name,object_type from user_objects;
SQL code:
SELECT object_name,object_type from user_objects WHERE object_type IN ('PROCEDURE','FUNCTION','PACKAGE');
²éѯ´æ´ ......