ITPub博客

declare tablename1 number(3);STRSQL varchar2(30);TABLENAME2 varchar2(20);beginTABLENAME2 := 'dept';STRSQL :='SELECT COUNT(*) FROM '||TABLENAME2;EXECUTE IMMEDIATE STRSQL INTO tablename1;dbms_output.put...

Recordsa record is composed of one or more fields. There are three different ways to define a record:1. Table-based recordCREATE TABLE books (      book_id   &n...

单引号两种转义select 'Aren''t you glad you''re learning PL/SQL?'from dualselect q'!Aren't you glad you're learning PL/SQL?!'from dual--! @ 等select q'!Aren''t you glad you're learning PL/SQL?!'from du...

Executing DDL and SCL (Session control language (SCL) statements, such as ALTER SESSION and SET ROLE)Statements in PL/SQL

一、设置初始化参数 job_queue_processes　　sql> alter system set job_queue_processes=n;（n>0）　　job_queue_processes最大值为1000　　　　查看job queue 后台进程　　sql>select name,description from v$bgp...

  1. Enable job queueSQL> alter system enable restrict session;2. make sure oracle has set the job queue parameterin orcl(oracle sid).ora, need to addjob_queue_process = N (proce...

创建job declare    job2 number; begin dbms_job.submit(job2,'test_lk;',sysdate,'sysdate+1'); end; 1创建一个表 create table test_table(a date); 2创建 一个存储过程 create or replace proced...

fedora 12 x64 安装virtualboxVirtualBox教程2010-06-24 15:03当我们利用fedora12的livecd安装完操作系统后，在安装virtualbox之前还需要安装很多的组件。现在我以64位Fedora为例，安装virtualbox（64位）。首先我们...

SQL code --功能概述:删除重复记录 --做成时间:2008/10/31 在几千条记录里,存在着些相同的记录,如何能用SQL语句,删除掉重复的呢?谢谢! 1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断 select...

insert into emp(empno, ename) values(999,'begin' || '&' || 'end')

9.18号通过了OCP考试接下来复习备份和还原的知识准备准备了你懂的

近日生产库中的一个过程报出了ora-1461的错误，虽然错误实际处理起来非常简单，但解决过程中与yangtingkun老大就该问题思想火花的碰撞还是让我颇有收益。创建一个最简单的示例演示一下错误的触发：SQL> CREATE ...

http://forums.oracle.com/forums/thread.jspa?messageID=3197857#3197857  ORA-100501 is the error returned when you trap a Raise Form_Trigger_Failure in an exception handler.Somewhere in you...

话说题目是这样的：有三个公司，苹果，微软，IBM。里面自然有好多员工，员工也有月薪。这三个公司每个月要交一定的税。请查询出：这几个公司的每个月要交的税，大于所在员工的最高月薪。并且返回公司名称。举个例子I...

create table rates( curr varchar2(4), rate  number(15,10) )  insert into rates values ('EURO',1.1012);commit;update rates set rate = 1.1014;commit;update rates set rate =...

how to start oracle on linux1. start listener$lsnrctl start2. dbstart$dbstart输入没反应action:  edit /etc/orataborcl:$ORACLE_HOME:N->Y输入dbca 报错 no protocal specified.Action: #xhost ...

检查系统的硬件需求是否满足RAM > 1GSwap > 1G/tmp > 400MB命令: grep Men(Swap) /proc/meminfo df -m /tmp 以ROOT用户登录 ORACLE数据库安装需要两个用户组：oinstall and dbaORAC...

declare         type emp_type is ref cursor return emp%rowtype;        cur_emp emp_type;       ...

declarev_date varchar2(18);beginv_date := to_char(sysdate, 'Day, hh24:mi');dbms_output.put_line(v_date );end; 

In 适合于外表大而内表小的情况；Exits 适合于外表小而内表大的情况。in list是非关联子查询，用于子集小的情况下exist是关联子查询，用于母集小的情况下某大型应用数据库系统中，有T1和T2两个表，并且这两个表通过...