OracleÓû§¹ÜÀí³£ÓòÙ×÷
ÒÔÏÂÁгöµÄÊÇOracle
Óû§¹ÜÀí¹ý³ÌÖг£ÓõÄһЩָÁÒÔ¹©´ó¼Ò²Î¿¼¡£
Oracle
Óû§¹ÜÀíÖ®Ò»¡¢´´½¨profile
Îļþ¡£
1.
SQL>Create
profile
ÎļþÃû limit
2.
FAILED_LOGIN_ATTEMPTS
£ºÖ¸¶¨Ëø¶¨Óû§µÄµÇ¼ʧ°Ü´ÎÊý
3.
PASSWORD_LOCK_TIME
£ºÖ¸¶¨Óû§±»Ëø¶¨ÌìÊý
4.
PASSWORD_LIFE_TIME
£ºÖ¸¶¨¿ÚÁî¿ÉÓÃÌìÊý
5.
PASSWORD_REUSE_TIME
£ºÖ¸¶¨Ôڶ೤ʱ¼äÄÚ¿ÚÁî²»ÄÜÖØÓÃ
6.
PASSWORD_REUSE_MAX
£ºÖ¸¶¨ÔÚÖØÓÿÚÁîǰ¿ÚÁîÐèÒª¸Ä±äµÄ´ÎÊý
7.
SESSIONS_PER_USER
£ºÏÞÖÆÓû§²¢·¢»á»°¸öÊý
8.
CPU_PER_SESSION
£ºÏÞÖÆ»á»°ËùÕ¼ÓõÄCPU
ʱ¼ä£¨°Ù·ÖÖ®Ò»Ã룩
9.
CPU_PER_CALL
£ºÏÞÖÆÃ¿´Îµ÷ÓÃËùÕ¼ÓõÄCPU
ʱ¼ä£¨°Ù·ÖÖ®Ò»Ã룩
10.
CONNECT_TIME
£ºÏÞÖÆ»á»°µÄ×ܼÆÁ¬½Óʱ¼ä£¨·ÖÖÓ£©
11.
IDLE_TIME
£ºÏÞÖÆ»á»°µÄ¿ÕÏÐʱ¼ä£¨·ÖÖÓ£©);
Oracle
Óû§¹ÜÀíÖ®¶þ¡¢´´½¨Óû§£¨°üÀ¨´´½¨½ÇÉ«£©:
1.
SQL>Create
user
Óû§Ãû
2.
IDENTIFIED BY
¿ÚÁî
3.
Default
tablespace &nb
Ïà¹ØÎĵµ£º
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%--
ʹÓÃJDBCÁ¬½ÓOracleÊý¾Ý¿â
--%>
<%!
String DBDRIVER="oracle.jdbc.driver.OracleDriver";
String URL="jdbc:oracle:thin:@localhost:1521:orcl";
String USER="scott ......
ÎÊÌâ1£º ½øÈëʱÐèÒªÖ÷»úÉí·ÝÖ¤Ã÷£º ½â¾ö·½°¸£º¹ÜÀí¹¤¾ß——±¾µØ°²È«²ßÂÔ——Óû§È¨ÀûÖ¸ÅÉ——×÷ΪÅú´¦Àí×÷ÒµµÈ¼£¨×îºóÒ»Ï——Ìí¼Ó±¾»úµÄÕ˺ÅÓëÃÜÂë ......
ÒÔÏÂÊÇÔÚºǫ́¸üÐÂÒ×ÍØERPÊý¾Ý¿âʱÓöµ½µÄÒ»¸öÎÊÌâ:
1.ÔÚDB14Êý¾Ý¿âÖн«ÁϼþºÅP44¿ªÍ·,²¢ÇÒÆ·ÃûΪ"ËÜÁÏ´ü"µÄÁϼþ¸ÄΪÏûºÄÐÔÁϼþ.
Õâ¸ö¼òµ¥: UPDATE DB14.ima_file SET ima70 = ‘Y’ WHERE ima01 like ‘P44%’ AND ima0 ......
½ñÌì¿´µ½Ò»Æª¹ØÓÚORA_ROWSCNµÄÎÄÕ£¬ËäÈ»¼ò¶Ì£¬Ã»ÓÐʲôʵÀý£¬µ«ÊÇÒѾ°ÑORA_ROWSCN´ó¸ÅÊÇÔõô»ØÊ½éÉÜÇå³þÁË¡£¼Ç¼һÏ¡£
=================================================================================
ĬÈϵÄÇé¿öÏ£¬Ã¿¸ö¿éÖÐËùÓеļǼµÄORA_ROWSCN¶¼ÊÇÏàͬµÄ£¬µ±¿éÖÐÈÎÒâÒ»Ìõ¼Ç¼·¢Éú¸Ä±äµÄÇé¿öÏ£¬¿éÖÐËùÓм ......
ʹÓõÄÊÇADODB¿â,ÐèÒªÓÐOCI8¿â.
<?php
//require("adodb5/adodb-exceptions.inc.php");
require("adodb5/adodb.inc.php");
$conn = NewADOConnection("oci8");
$conn->Connect($url, $user, $password, $service_name);
$rs;
try {
$rs = $conn->Execu ......