table1:
uID uName
1 СÀî
2 СÕÅ
table2:
pID uID type
1 1 H1
2 2 H2
table3:
uID teamID
1 T1
1 ......
Çë½Ì¸÷λ´óÏÀÁ½¸öÎÊÌâ:
£¨1£©ÇëÎÊoracleÊÇ·ñÓо«¼ò°æÏÂÔØ£¿ÍêÕû°æ»ú×ÓʵÔÚÊÇÅܲ»¶¯£¬
¶øÇÒһЩ¹¦ÄÜÒ²Óò»ÉÏ£¬²»ÖªµÀÊÇ·ñÓо«¼ò°æ¡£
£¨2£©ÓÃoracle½øÐпª·¢ÐèÒª°²×°¿Í»§¶ËÂð£¿
лл£¡
º¹£¬Ã»ÈË
1.¾«¼ò°æÒ»Ëµ,ûÌý˵¹ý.
2.Òª°²×°client ¶Ë°æ±¾ oracle.Ò»°ã¿ª·¢»¹Ðè°²×°plsql»òtoad
ÂÌÉ ......
Java code:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class JDBCTest {
/**
* @param args
*/
private Connection con = null;
static{
try{
Class.forName ("oracle.jdbc.driver.OracleDriver&qu ......
ÇëÎÊORACLEÊÇ·ñÓÐÀàËÆSQL SERVER 2008ÖеÄSQL Server ProfilerÕâÑùµÄ½ØÈ¡Ö´Ðе½·þÎñÆ÷µÄÔËÐнű¾µÄ¹¤¾ß»ò¹¦ÄÜ£¿
лÀ²¡£
ûÓÐÈËÖªµÀÂð£¿
²»Çå³þ..
½ØÈ¡Ö´Ðе½·þÎñÆ÷µÄÔËÐнű¾£¿ÊÇʲôÒâ˼£¿
¾ÍÊÇ¿ÉÒÔ²éѯµ½ÄÄЩÈËÖ´ÐÐÁËÄÄЩ²éѯÓï¾äµ½·þÎñÆ÷ÁË¡£
ÔÙ¶¥
ÔÙ¶¥
oracleÌṩ¶¯Ì¬ÊÓͼ¼Ç¼Óû§Ö´Ðйý ......
window ce ϵͳÏÂÔõô·ÃÎÊ pc»úÉϵÄoracleÊý¾Ý¿â£¡ÎÒÓõÄÊÇvs2008£¬poketpcÊÇwindows mobile 5.0£¬²»ÖªÄÇλ¸ßÈËÄܸø½â¾ö¡£
Ö±½Ó·¢Êý¾Ýµ½PCÉÏ.
È»ºóPC´¦Àí..
²»ÓÃÁª°É
³ýÁËÕâ¸öÕæµÄûÓиüºÃµÄ½â¾ö°ì·¨ÁËÂð£¿
ÏëÎÞÏßÖ±½ÓÁ¬£¬£¬£¬£¬Õâ¸öºÃÏñÓеãÄѶȣ¡
¾ÍËãÁ¬ÉϺó²»Ò²¾ÍÊÇ·¢·¢Êý¾ÝÂð£¿ÔÀíÊÇÒ»ÑùµÄ£¡
......
¿É·ñ°ïæ×ö¸ö×¢ÊÍ£º
1) SQL> create pfile from spfile;
2) shutdown immediate
3) ÓÃд×Ö°å´ò¿ªinitSID.ora
*.log_archive_start=true
*.log_archive_dest='D:\oracle\oradata\archive00\'
*.log_archive_format='awu%s.arc'
OS±£´æ
4) SQL> create ......