Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : Oracle

ÓÃVBÈçºÎ·ÃÎÊoracleÖеÄblob×ֶΣ¿

ÎÒÐèÒªÓÃVBÁ¬½ÓOracle²¢ÏÂÔØblo£â×ֶΣ¬
ÎÒÓÃÒÔÏÂÁ¬½Ó·½Ê½£¬³ÌÐòʼÖÕ²»ÄÜʶ±ð£â£ì£ï£â×ֶΣ¬
  connStr = "Provider=msdaora;Persist Security Info=False;User ID=" & _
              uid & ";Password=" & pwd & ";Data ......

Oracle´íÎóORA-00942

Âé·³ÎÊһϸ÷룬ORA-00942£ºtable or view does not existÔõô½â¾ö°¢£¬Ð»Ð»¸÷λÁË
Ò»°ã´íÎó:
Äã²éµ½±íÔÚÄãµÄµ±Ç°Óû§ÏÂÃæÓÐȨÏÞ²éѯ,»òÕß±í²»´æÔÚ
ÀýÈç DBA²éѯSCOTTµÄÓû§
Òª¼ÓÉϱíËùÔÚµÄÓû§
SELECT *¡¡from SCOTT.EMP;

ÒýÓÃ
Âé·³ÎÊһϸ÷룬ORA-00942£ºtable or view does not existÔõô½â¾ö°¢£¬Ð»Ð» ......

Êý¾Ý¿â(Oracle)AjaxÌÖ(Jquery)ÌÖÂÛȺ×齨

ΪÁË´ó¼ÒºÃºÃѧϰÒÔ¼°ÔÚ¹¤×÷ÖÐÓöµ½ÎÊÌâÄܹ»ºÍ´ó¼ÒÒ»Æð½â¾ö
ºÍѧϰ
ΪÁË Ñ§Ï°µÄ¶øÑ§Ï°ÎªÁË·³ÄÕ²»ÔÚ·³ÄÕ...ÆÚ´ý´ó¼ÒµÄ¼ÓÈë.....
ȺºÅ:2987841

¶¥

¶¥heÀϴ󣬱ØÐë¶¥

¶¥....Ⱥ¹æÔòÒ²·¢Ï°É

ding

²»ÊǰÉ,Ó¦¸ÃÈ¥AJAX¼¼Êõ×¨Çø°É

¶¥Æð¡£¡£¡£¡£ -ÃÔʧ

¶¥Æð¡£¡£¡£¡£ -ÃÔʧ

¶î£¬ÀÏ´óÏÖÔÚÍæjquery
......

oracle ´æ´¢¹ý³ÌÎÊÌâ

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µÄËùÓбí¿Õ¼ä

ÎÒÓÐ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 ......

oracle²éѯ´æ´¢¹ý³Ì

ÎÒÓÃ×Ô¼º´´½¨µÄÓû§Ãû£¨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');

²éѯ´æ´ ......
×ܼǼÊý:1827; ×ÜÒ³Êý:305; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [215] [216] [217] [218] 219 [220] [221] [222] [223] [224]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ