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

oracle¸ù¾ÝÖ÷Íâ¼ü²é±í

select a.constraint_name, a.table_name, b.constraint_name
  from user_constraints a, user_constraints b
where a.constraint_type = 'R'
  and b.constraint_type = 'P'
  and a.r_constraint_name = b.constraint_name
P ´ú±íÖ÷¼ü
R ´ú±íÍâ¼ü


Ïà¹ØÎĵµ£º

JDBCÁ¬½ÓOracleµÄ¼òµ¥Àý×Ó

 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 ......

Ò»¸ö¼òµ¥µÄhibernateÁ¬½ÓoracleÊý¾Ý¿âÀý×Ó£¡

Ò»¡¢ Hibernate½éÉÜ
    HibernateÊÇ»ùÓÚ¶ÔÏó/¹ØϵӳÉ䣨ORM£¬Object/Relational Mapping£©µÄÒ»¸ö½â¾ö·½°¸¡£ORM·½°¸µÄ˼ÏëÊǽ«¶ÔÏóÄ£ÐͱíʾµÄ¶ÔÏóÓ³Éäµ½¹ØϵÐÍÊý¾Ý¿âÖУ¬»òÕß·´Ö®¡£HibernateÄ¿Ç°ÊÇORM˼ÏëÔÚJavaÖÐ×î³É¹¦¡¢×îÇ¿´óµÄʵÏÖ¡£ËüÓÚ2001ÄêµÄÄêÄ©·¢²¼µÚÒ»¸ö°æ±¾£¬Á¢¼´ÒýÆðÁ˹㷺µÄ×¢Òâ¡£2003Äê6Ô£ ......

ibatisÁ¬½ÓoracleÀý×Ó£¡

Ò»¸öʹÓÃ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 ......

OracleÊý¾Ý¿âÍêȫжÔØ

1¡¢ Í£Ö¹oracleËùÓеķþÎñ£¨¿ªÊ¼--ÔËÐÐ--ÊäÈëservices.msc£©
2¡¢ ɾ³ý×¢²á±íÉϵÄORACLEµÄÓйؼüÖµ(¿ªÊ¼-->ÔËÐÐ-->ÊäÈëregedit£©½«HKEY_LOACAL_MACHINE/SOFTWAREϵÄÖ÷¼üORACLEÈ«²¿É¾³ý¡£
3. ÏÂÃæɾ³ýOracle·þÎñ£º½øÈëHKEY_LOACAL_MACHINE/SYSTEMÖ÷¼üÏ£¬ÔÚControlSet001¡¢ControlSet002¡¢CurrentControlSet--> ......

110¸öOracle ³£Óú¯ÊýµÄ×ܽá3

80¡£LAST
¹¦ÄÜÃèÊö£º´ÓDENSE_RANK·µ»ØµÄ¼¯ºÏÖÐÈ¡³öÅÅÔÚ×îºóÃæµÄÒ»¸öÖµµÄÐУ¨¿ÉÄܶàÐУ¬ÒòΪֵ¿ÉÄÜÏàµÈ£©£¬Òò´ËÍêÕûµÄÓï·¨ÐèÒªÔÚ¿ªÊ¼´¦¼ÓÉÏÒ»¸ö¼¯ºÏº¯ÊýÒÔ´ÓÖÐÈ¡³ö¼Ç¼
SAMPLE£ºÏÂÃæÀý×ÓÖÐDENSE_RANK°´²¿ÃÅ·ÖÇø£¬ÔÙ°´Ó¶½ðcommission_pctÅÅÐò£¬FIRSTÈ¡³öÓ¶½ð×îµÍµÄ¶ÔÓ¦µÄËùÓÐÐУ¬È»ºóÇ°ÃæµÄMAXº¯Êý´ÓÕâ¸ö¼¯ºÏÖÐÈ¡³öнˮ×îµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ