OracleÖÐÐÞ¸ÄSequence·½·¨
OracleÖÐÐÞ¸ÄSequence·½·¨£º¾ÍÊǸıäËüµÄincrement µÝÔö´óС£¬Ëü¿ÉÒÔΪÕýÒ²¿ÉÒÔΪ¸º¡£ÈçÏ£º
SQL> select seq.nextval from dual;
NEXTVAL
----------
21
SQL> alter sequence seq increment by 79;
ÐòÁÐÒѸü¸Ä¡£
SQL> select seq.nextval from dual;
NEXTVAL
----------
100
SQL> alter sequence seq increment by 1;
ÐòÁÐÒѸü¸Ä¡£
SQL> select seq.nextval from dual;
NEXTVAL
----------
101
SQL>
Ïà¹ØÎĵµ£º
import java.net.url;
import java.sql.*;
public class javaoracle {
public javaoracle() {
}
public static void main(string[] args){
try
{
try{
class.forname("oracle.jdbc.driver.oracledriver");
}
catch(java.lang.classnotfoundexception e)
{
system.err.print(e.getmessage());
} ......
½«Ò»¸öÊý¾Ý¿âµÄijÓû§µÄËùÓÐ±íµ¼µ½ÁíÍâÊý¾Ý¿âµÄÒ»¸öÓû§ÏÂÃæµÄÀý×Ó¡¡¡¡
exp userid=system/manager owner=username1 file=expfile.dmp
imp userid=system/manager fromuser=username1 touser=username2 ignore=y file=expfile.dmp
ORACLEÊý¾Ý¿âÓÐÁ½À౸·Ý·½·¨¡£µÚÒ»ÀàΪÎïÀí±¸·Ý£¬¸Ã·½·¨ÊµÏÖÊý¾Ý¿âµÄÍêÕû»Ö¸´£¬µ«Êý¾Ý ......
ORACLEÊý¾Ý¿âµÄ»ù±¾Óï·¨¼¯½õ
-- ±í
create table test (names varchar2(12),
dates date,
&nb ......
·ÖÎöº¯Êý£¬×îÔçÊÇ´ÓORACLE8.1.6¿ªÊ¼³öÏֵģ¬ËüµÄÉè¼ÆÄ¿µÄÊÇΪÁ˽â¾öÖîÈç“ÀۼƼÆË㔣¬“ÕÒ³ö·Ö×éÄڰٷֱȔ£¬“Ç°-NÌõ²éѯ”£¬“Òƶ¯Æ½¾ùÊý¼ÆËã”"µÈÎÊÌâ¡£Æäʵ´ó²¿·ÖµÄÎÊÌⶼ¿ÉÒÔÓÃPL/SQL½â¾ö£¬µ«ÊÇËüµÄÐÔÄܲ¢²»ÄÜ´ïµ½ÄãËùÆÚÍûµÄЧ¹û¡£·ÖÎöº¯ÊýÊÇSQLÑÔÓïµÄÒ»ÖÖÀ©³ä£¬Ëü²¢²»Êǽö½ ......
update customers a
set city_name=(select b.city_name from tmp_cust_city b where b.customer_id=a.customer_id)
where exists (select 1
from tmp_cust_city b
where b.customer_id=a.customer_id
)
-- update ³¬¹ý2¸öÖµ
update customers a
set (city_name,customer_type)=(select b.city_name,b.customer_ ......