Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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

Linq Ö§³Ö oracle Â𣿠- .NET¼¼Êõ / LINQ

ÈçÌâ
ûÓÐÊÔ¹ý£¬
²»¹ýÓ¦¸Ã¿ÉÓã¬
µ«Ö§³Ö²»Èçsql serverºÃ¡£¡£¡£¡£

²»Ö§³Ö

http://blogs.msdn.com/charlie/archive/2008/02/28/link-to-everything-a-list-of-linq-providers.aspx

Ö§³Ö...

http://linqtooracle.codeplex.com/


ÈÈÁÒ»¶Ó­.NET³ÌÐòÔ±¼ÓÈë108860028Ⱥ,ÎÒÃǹ²Í¬½ø²½,×·Öð¸÷×ÔµÄÃÎÏë!

ÈÈÁÒ» ......

Ä£ºý²éѯoracleÖÐÓжàÉÙÕÅ±í£¿ - Oracle / ·Ç¼¼ÊõÇø

Ä£ºý²éѯoracleÖÐÓжàÉÙÕÅ±í£¿
select * from tabs;

select count(*) from tabs;

select sum(1) from all_all_tables;

select count(1) from dba_tales;
SELECT COUNT(1) from DBA_OBJECTS WHERE OBJECT_TYPE='TABLE';

SQL code:

SQL> select count(*) from user_tables;
COUNT(*)
----------
......

Çó½Ìoracle±¸·ÝÎÊÌâ - Oracle / ¿ª·¢

ÔÚoracle±¸·ÝÍê³ÉÒÔºó,ÈçºÎ²é¿´±¸·ÝÊÇ·ñ³É¹¦,ËüÓÐûÓÐÈÕÖ¾Îļþ,Èç¹ûÓÐÔÚʲôµØ·½,Ôõô²é¿´!лл

ʲô²Ù×÷ϵͳ°¡£¬Ä㲻˵ÎÒ¾ÍĬÈÏÊÇlinuxÁË¡£
ÓÐÈÕÖ¾Îļþ£¬alert.log £¬ÊÔÊÔshow parameter background_dump_dest µÄ·¾¶ÏÂÕÒÕÒ£¬ÒªÊÇûÓоÍfind / -name alert.log
²é¿´±¸·ÝÊÇ·ñ³É¹¦£¬
rman
connect target /
list b ......

JDBC Á¬½Ó Oracle - Java / Java SE

ʹÓà JDBC Á¬½Ó Oracle ʱ£¬Èç¹û URL д³É£ºjdbc:oracle:thin:@192.168.1.100:1521:sid (192.168.1.100 ÊDZ¾»ú IP)
´ËʱÔÚ»ñÈ¡ Connection ʱ½«³öÏÖÒÔÏÂÒì³£¡£
Java code:

java.sql.SQLException: The Network Adapter could not establish the connection
µ«Èç¹û½« URL д³É jdbc:oracle:thin:@localhost:1521:sid ......

Ë­ÄܽÌÎÒѧOracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÕâÒ»¸öÐÇÆÚ¶ÔOracle ½øÐÐÁËÍ»»÷ѧϰ£¬¸Ðµ½ºÜÀÛ°¡¡­¡­
ÓкܶණÎ÷Òª¼ÇµÄ¡­¡­ÓкöàsqlÓï¾ä¸Ð¾õºÜÂé·³£¬
¹òÇó¸÷λ´óϺÃÇ ÓÐʲôºÃµÄѧϰ·½·¨£¬¸øÎÒÒ²½éÉÜһϣ¬
СµÜÔÚ´ËÏÈл¹ýÁË
Â¥Ö÷¼ÓÓÍ

ÎÒÒ²ºÜÀÛ°¡£¬ÎÒÏëÓÐÈ˽ÌÎÒ£¬¿Éϧһ¸öûÓа¡


ÂýÂýÀ´£¬³¤³Ç²»ÊÇÒ»Ì콨³ÉµÄ¡£
......

100·ÖÇó½âoracleÓйصÄ5¸öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ÈçÌâ:
1.ÈçºÎ²é¿´ºÍµ÷ÕûÊý¾Ý¿âµÄ×î´óÁ¬½ÓÊý£¿
2.linuxϲ鿴alert log?
3.ÔÚ×Ô¶¨ÒåµÄÀàÐͺóÃæ¼ÓÉÏindex by pls_integer ±íÊÇʲôÒâ˼£¿
4.oracleÖÐ×ÔÖÎÊÂÎñpragma autonomous_transaction µÄÀí½â£¿
5.Õâ¾ä»°ÔõôÀí½â£º
  Èç¹ûijһ²Ù×÷°üº¬´óÁ¿µÄSQL´úÂë»ò·Ö±ð±»¶à´ÎÖ´ÐУ¬ÄÇô´æ´¢¹ý³ÌÒª±ÈÅú´¦ÀíµÄÖ´ÐÐËÙ¶È¿ìº ......
×ܼǼÊý:1827; ×ÜÒ³Êý:305; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [40] [41] [42] [43] 44 [45] [46] [47] [48] [49]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ