masuwen博客

<br />Oracle中join的用法<br />8i:create table dali.test1(a int,b int);  create table dali.test2(a int,b int);  insert into dali.test1 values(1,456);  insert into dali.test1 values(2,427);  insert into dali.test2 values(1,45456);  insert into dali.test2 values(

一：官方下载ORACEL客户端软件，http://www.oracle.com/technology/global/cn/software/products/database/xe/htdocs/102xewinsoft.html二：在 C:/XEClient目录下新建Network文件夹，在 Network 新建Admin文件夹，三：在Admin目录下新建名称为 tnsnames.ora 的文件，文件内容如下： ORCL1 =   (DESCRIPTION =    (ADDRESS = (PROTOCO

http://www.ezdml.com/index.html

@Id @Column(name="channel_id",nullable = false) @TableGenerator(name="channelId",allocationSize=1) @GeneratedValue(strategy=GenerationType.TABLE, generator="channelId") public Intege

//test为表空间//用户修改oracle服务器字段变更---oracle修改已有表类型ALTER TABLE test.CMS_NOTICE ADD IS_READ NUMBER(1,0);----oracle给表字段增加注释COMMENT ON COLUMN test.CMS_NOTICE.NOTICE_TITLE IS '通知标题';

sql:SELECT u.user_id,    u.user_name,    u.mail_receive_time  FROM mail_user u,    mail_interior i  WHERE u.mail_id          = i.mail_id  AND i.mail_creator       = '8440'  AND u.mail_

# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\network\admin\tnsnames.ora# Generated by Oracle configuration tools.#XIEHENG_192.168.16.20 =#  (DESCRIPTION =#    (ADDRESS_LIST =

1，按时间段查询  issueDate （ 起始日期）       issueTwoDate （结束日期）if (StringUtils.isNotEmpty(issueDate) &&  StringUtils.isNotEmpty(issueTwoDate)){                sql.append(" and to_date(to_char(s.issueDate,

update CMS_INFO_ACCESSORY  set ACCESSORY_NAME = 'xsmd/information/'||ACCESSORY_NAME where length(ACCESSORY_ID)

update table_wonder set tempcolumn = dbms_lob.substr(clobcolumn,4000);//追加列 update cms_info_relation r set r.info_content_test= info_content_test||'.doc' where info_id in(select i.info_

oracle start with, connect by,prior

-- mysql 查询一级菜单SELECT DISTINCT d.id AS "id", d.pid AS "pid", d.name AS "name", d.icon AS "icon", d.description AS "description", d.url AS "url", d.ordernum AS "orderNum", is_leaf_res

涉及到crm用户对象，全部创建视图，或者同义词，如：create view vc_cus_org_customer as select * from crm.cus_org_customer;create synonym sc_cus_seq_org for crm.cus_seq_org;不能直接使用 crm. 进行访问 create synonym sc_cus_s

If NEW_TABLE already exists then ...insert into new_table select * from old_table/If you want to create NEW_TABLE based on the records in OLD_TABLE ...create table new_table as select * from old...

INSERT INTO target_table (col1, col2, col3)SELECT col1, col2, col3FROM source_tableWHERE condition;

<br /> select e.ename,subq.loc<br />     from emp e,<br />      (select deptno,loc from dept where loc in('NEW YORK','DALLAS') ) subq<br />   where e.deptno=subq.deptno;<br />ENAME      LOC<br />---------- -------------<br />CLARK      NEW YORK

<br />http://www.docin.com/p-96526177.html

<br />登录 pssql，打开命令行输入：<br />select *from emp;<br /> ORA-00942: 表或视图不存在<br />sql>show user;<br />User is "sys"<br />解决办法:<br />重新登录，用户名 scott,密码: tiger<br />链接为：normal,注意:如果链接选为 sysdba 时 ，是超级管理员权限, <br /><br /><br /> <br />

<br /><br />ORA-00017: 请求会话以设置跟踪事件 <br />ORA-00018: 超出最大会话数 <br />ORA-00019: 超出最大会话许可数 <br />ORA-00020: 超出最大进程数 () <br />ORA-00021: 会话附属于其它某些进程；无法转换会话 <br />ORA-00022: 无效的会话 ID；访问被拒绝 <br />ORA-00023: 会话引用进程私用内存；无法分离会话 <br />ORA-00024: 单一进程模

<br />create or replace procedure proc_msw_strsql<br />/*<br />名称：在存储过程中执行3种循环语句<br />功能：利用循环给表中插入数据<br />调用：<br />      begin<br />        -- Call the procedure<br />        proc_msw_strsql;<br />      end;<br />      <br />创建人：马素文<br />

<br /> http://dev.firnow.com/course/3_program/java/javajs/20100710/400521.html

<br />create or replace procedure msw_add is<br />begin<br />  for i in 1 ..100000 loop<br />    insert into t1(id,name) values(i, sysdate);<br />    end loop;<br />end msw_add;<br />/

<br />create or replace procedure stu_recis<br />type record_type is record(<br />name students.student_name%type,<br />major major_lookup.major_desc%type);<br />student_recrecord_type;<br />begin<br />select student_name,major_descinto student

<br />create or replace procedure stu_record<br />(v_student_Id in varchar2) is<br />recstudents%ROWTYPE;<br />begin<br />select student_Id ,student_name<br />into rec.student_Id,rec.student_name from students<br />where student_id=v_student_Id

<br />CREATE USER NADEMO<br />IDENTIFIED BY           <br />DEFAULT TABLESPACE USERS<br />TEMPORARY TABLESPACE TEMP<br />PROFILE DEFAULT<br />/<br />GRANT DBA TO NADEMO<br />/<br />GRANT AUDIT SYSTEM TO NADEMO<br />/<br />GRANT UNLIMITE

<br />Oracle提示错误消息ORA-28001: the password has expired,<br />经调查是由于Oracle11G的新特性所致， Oracle11G创建用户时缺省密码过期限制是180天， 如果超过180天用户密码未做修改则该用户无法登录。 <br />可通过<br />SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME'<br />语句查询密码

<br />CREATE TABLESPACE TEST<br />DATAFILE 'D:/temp/DATAORA/TEST.DBF' SIZE 5M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED<br />LOGGING<br />ONLINE<br />BLOCKSIZE 8K<br />EXTENT MANAGEMENT LOCAL AUTOALLOCATE<br />SEGMENT SPACE MANAGEMENT AUTO<

<br />//一张表中父编号 = 字编号情况，<br />CREATE OR REPLACE FUNCTION nademo.GET_DEPTNAME(pId_param IN NUMBER)<br />RETURN VARCHAR2-- 返回值的数据类型<br />IS<br />    out_connNAME  VARCHAR2(500);<br />BEGIN<br />    --得到给定部门所有上级的数据集<br />    FOR K IN (<br />   

<br />@Entity<br />@Table(name = "数据库表名称")<br />1、检查实体类属性是否存在。<br />2、如果字段存在 则检查关联关系<br /> 比如：<br />   @OneToMany<br />    @JoinColumn(name="关联表主键名称",insertable= false,updatable= false )<br />把红色部分加入就可以了.

<br />本文简要介绍了ORACLE的高级复制功能，并通过一个实际项目，讨论了在内外网的两级DB中如何采用高级复制达到内外网的数据统一，最后给出配置脚本供大家参考。<br /><br />1、基本概念<br /><br />ORACLE<br />ORACLE是以高级结构化查询语言(SQL)为基础的大型关系数据库，通俗地讲它是用方便逻辑管理的语言操纵大量有规律数据的集合。是客户/服务器(CLIENT/SERVER)体系结构的数据库之一。<br /><br />高级复制<br />什么是

<br />org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query<br />Caused by: java.sql.SQLException: ORA-00933: SQL 命令未正确结束<br /> <

<br />//==================================tnsnames.ora<br /># tnsnames.ora Network Configuration File: D:/oracle/product/10.2.0/db_1/NETWORK/ADMIN/tnsnames.ora<br /># Generated by Oracle configuration tools.<br /><br />SGPMSS =<br />  (DESCRIPTION =<

Oracle提示错误消息 ORA-28001: the password has expired，是由于Oracle11G的新特性所致，Oracle11G创建用户时缺省密码过期限制是180天（即6个月），如果超过180天用户密码未做修改则该用户无法登录。Oracle公司是为了数据库的安全性默认在11G中引入了这个默认功能，但是这个默认的功能很容易被DBA或者是开发人员给疏忽，一旦...