µãµãµÎµÎ(Oracle)
insert into
select * into t_dest from t_src; -- ÒªÇóÄ¿±ê±í²»´æÔÚ
insert into t_dest(a, b) select a, b from t_src; -- ÒªÇóÄ¿±ê±íÒÑ´æÔÚ
¶¯Ì¬SQL
execute immediate 'select ' || sq_serialnum || '.nextval from dual' into i_serialnum;
°´ÕÕÆ´Òô,²¿Ê×,±Ê»ÅÅÐò
ÏÂÃæµÄ·½·¨ÐèÒªORACLE9iºÍÒÔÉϵİ汾²ÅÖ§³Ö.
Oracle9i֮ǰ, ÖÐÎÄÊǰ´ÕÕ¶þ½øÖƱàÂë½øÐÐÅÅÐòµÄ.
ÔÚoracle9iÖÐÐÂÔöÁ˰´ÕÕÆ´Òô,²¿Ê×,±Ê»ÅÅÐò¹¦ÄÜ. ÉèÖÃNLS_SORTÖµ
SCHINESE_RADICAL_M °´ÕÕ²¿Ê×(µÚһ˳Ðò),±Ê»®(µÚ¶þ˳Ðò)ÅÅÐò
SCHINESE_STROKE_M °´Õձʻ®(µÚһ˳Ðò),²¿Ê×(µÚ¶þ˳Ðò)ÅÅÐò
SCHINESE_PINYIN_M °´ÕÕÆ´ÒôÅÅÐò, ϵͳµÄĬÈÏÅÅÐò·½Ê½ÎªÆ´ÒôÅÅÐò
select * from table_name order by nlssort(field_name, 'nls_sort=SCHINESE_STROKE_M');
È¡ºÁÃë(oracle 9i +)
select to_char(systimestamp,'yyyy-mm-dd hh24:mi:ss.ff3') from dual;
like²éѯÏ»®Ïß±¾Éí
select * from test where columnname like 'a\_%' escape '\';
-- ±íʾ½«½ô¸úÔÚescape×Ö·ûºóµÄ×Ö·û½âÊÍΪ×Ö·û±¾Éí, ¶ø·ÇתÒå×Ö·û
ÈÕÆÚ¼õÈ¥Ò»Ãë
select sysdate,sysdate - interval '1' second from dual;
Ð޸ıí½á¹¹
alter table t_employee add (remark varchar2(50)); --Ôö¼ÓÁÐ
alter table t_employee modify (sex default 0); --ÐÞ¸ÄÁеÄĬÈÏÖµ
alter table t_employee modify (remark null); --ÐÞ¸ÄÁпÉΪ¿Õ
alter table t_employee rename to t_employee_new; --Ð޸ıíÃû
&
Ïà¹ØÎĵµ£º
F.1×Ö·ûº¯Êý——·µ»Ø×Ö·ûÖµ
ÕâЩº¯ÊýÈ«¶¼½ÓÊÕµÄÊÇ×Ö·û×åÀàÐ͵IJÎÊý(CHR³ýÍâ)²¢ÇÒ·µ»Ø×Ö·ûÖµ.³ýÁËÌØ±ð˵Ã÷µÄÖ®Íâ,ÕâЩº¯Êý´ó²¿·Ö·µ»ØVARCHAR2ÀàÐ͵ÄÊýÖµ.×Ö·ûº¯ÊýµÄ·µ»ØÀàÐÍËùÊܵÄÏÞÖÆºÍ»ù±¾Êý¾Ý¿âÀàÐÍËùÊܵÄÏÞÖÆÊÇÏàͬµÄ,±ÈÈç: VARCHAR2ÊýÖµ±»ÏÞÖÆÎª2000×Ö·û(ORACLE 8ÖÐΪ4000×Ö·û),¶øCHARÊýÖµ±»ÏÞÖÆÎª255×Ö·û(Ô ......
oracleʵÀýÃû,·þÎñÃûµÈ¸ÅÄîÇø±ðÓëÁªÏµ
Ò»¡¢Êý¾Ý¿âÃûITPUB¸öÈ˿ռäv{7x6lo\
ʲôÊÇÊý¾Ý¿âÃû£¿ITPUB¸öÈ˿ռä*s*R5LVBXZ2w$I
Êý¾Ý¿âÃû¾ÍÊÇÒ»¸öÊý¾Ý¿âµÄ±êʶ£¬¾ÍÏñÈ˵ÄÉí·ÝÖ¤ºÅÒ»Ñù¡£ËûÓòÎÊýDB_NAME±íʾ£¬Èç¹ûһ̨»úÆ÷ÉÏ×°Á˶àÈ«Êý¾Ý¿â£¬ÄÇôÿһ¸öÊý¾Ý¿â¶¼ÓÐÒ»¸öÊý¾Ý¿âÃû¡£ÔÚÊý¾Ý¿â°²×°»ò´´½¨Íê³ÉÖ®ºó£¬²Î ......
insert into dts_auction_comments (id,auction_id,user_id,user_nick,comments,gmt_create,gmt_modified,status,comm_type)
values(409,127380, ......
1import java.sql.*;
2import java.util.logging.Level;
3import java.util.logging.Logger;
4
5/** *//**
6 * Title: JDBCÁ¬½ÓÊý¾Ý¿â
7 * Description: ±¾ÊµÀýÑÝʾÈçºÎʹÓÃJDBCÁ¬½ÓOracleÊý¾Ý¿â£¬²¢ÑÝʾÌí¼ÓÊý¾ÝºÍ²éѯÊý¾Ý.
8 */
9public class JDBCExampl ......
Ò»¸öʹÓÃibatis¶ÔÊý¾Ý¿âÔöɾ¸Ä²éµÄÀý×Ó:
ÕâÀïÓõĿª·¢»·¾³ÊÇ:Eclipse3.2+mysql5.0.20,ibatis°üÊÇibatis-common-2.jar,
ibatis-dao-2.jar,ibatis-sqlmap-2.jar,mysql°üÊÇmysql-connector-java-5.0.3-bin.jar.
²½Öè:
1.´´½¨Êý¾Ý¿â:
create database itcast;
use itcast;
´´½¨±í£º
create table stu ......