Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Ð¶ÔØoracleµÄ²½Ö裨±Ê¼Ç£©

½ñÌìÖØÐÂÕûÀíµçÄÔ£¬ÕÒµ½Ò»¸öÎļþ£¬¿´ÁËÏÂÈÕÆÚ£¨2006.11.3£© £¬Å²»Ð¡ÐÄÔÙ¶ªÁË£¬´æµ½ÍøÉÏÀ´É¹É¹¡£
1.HKEY_LOCAL_MACHINE
  HKEY_LOCAL_MACHINE
  SOFTWARE
  ORACLE
2.HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services
3.ÖØÐÂÆô¶¯»úÆ÷.
create role  a  identified  by password


Ïà¹ØÎĵµ£º

MyeclipseÖÐÁ¬½ÓOracleµÄ¾­µä´úÂë

 package cn.edu.bit.test;
import java.sql.*;
public class Jdbc {
 public static void main(String[] args)
 {
     try{ 
      Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
     System.out.p ......

Oracle¶à±íÁªºÏ¸üÐÂ

ÒÔÏÂÊÇÔÚºǫ́¸üÐÂÒ×ÍØERPÊý¾Ý¿âʱÓöµ½µÄÒ»¸öÎÊÌâ:
1.ÔÚDB14Êý¾Ý¿âÖн«ÁϼþºÅP44¿ªÍ·,²¢ÇÒÆ·ÃûΪ"ËÜÁÏ´ü"µÄÁϼþ¸ÄΪÏûºÄÐÔÁϼþ.
          Õâ¸ö¼òµ¥:  UPDATE DB14.ima_file SET ima70 = ‘Y’ WHERE ima01 like ‘P44%’ AND ima0 ......

8¸öDBA×î³£ÓÃµÄ¼à¿ØOracleÊý¾Ý¿âµÄ³£ÓÃshell½Å±¾

±¾ÎĽéÉÜÁË8¸ö³£ÓÃµÄ¼à¿ØÊý¾Ýshell½Å±¾¡£Ê×ÏȻعËÁËһЩDBA³£ÓõÄUnixÃüÁÒÔ¼°½âÊÍÁËÈçºÎͨ¹ýUnix CronÀ´¶¨Ê±Ö´ÐÐDBA½Å±¾¡£ÍøÉÏÒ²ÓкöàÀàËÆµÄÎÄÕ£¬µ«»ù±¾É϶¼²»ÄÜÕý³£ÔËÐУ¬»¨µãʱ¼äÖØÐÂÕûÀíÁËÏ£¬ÒÔºó¾ÍÄÜÖ±½ÓʹÓÃÁË¡£
Ò»£®Í¬Ê±ÎÄÕ»¹½éÉÜÁË8¸öÖØÒªµÄ½Å±¾À´¼à¿ØOracleÊý¾Ý¿â£º
1.¼ì²éʵÀýµÄ¿ÉÓÃÐÔ
2.¼ì²é¼àÌýÆ÷µ ......

Ãâ°²×°µÄOracle¿Í»§¶Ë

 Oracle Instant ClientÊÇÃâ°²×°µÄOracle¿Í»§¶Ë£¬ÓÉÓÚËüûÓб»OracleµÄ°²×°³ÌÐòËù·â×°£¬Ê¹Óû§¸üÈÝÒ×Àí½âËüµÄ½á¹¹¡£
Instant Client¼ò½é
ÔÚÆä×îеÄVersion 11.1.0.7.0ÖУ¬°üÀ¨ÏÂÃæµÄ°ü£º
µÚÒ»¡¢»ù±¾°ü¡£
ÓÐÁ½ÖÖ£ºÈ«¹¦ÄܰüºÍ¼ò»¯°ü£¬¸ù¾ÝÐèÒªÏÂÔØ¡£
1)  Instant Client Package - Basic: All files required ......

oracle ´æ´¢¹ý³ÌºÍº¯Êýѧϰ±Ê¼Ç

oracle ´æ´¢¹ý³ÌºÍº¯Êýѧϰ±Ê¼Ç
1¡¢´´½¨¹ý³ÌµÄÓï·¨£º     
Code
create [or replace] procedure procedure_name
  [(argument[{in|out|in out}] type,
    
   argument[{in|out|in out}] type)]&n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ