An example is given below to how to create a modal dialog window in Oracle Forms for asking user input and return the value to any text item. The following is the screen shot of this demo and this form could be downloaded from the following link: Custom_diag.FMB This form is containing the following objects: You can see in above screen shot of object navigator that there are two data blocks, one...
<span style="font-family: Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">Let's say we are going to develop a application for a bank, or any other enterprise, this application need a DB. And we decide to choose Oracle 12c. Then we make a plan:</span>Application is for WBBANK, so name is WBBANKApplication DB is running in a individual PDBApplication DB has its own tablespaceThe...
转载请注明原文地址：http://www.cnblogs.com/litou/p/8028843.html 环境：Oracle 11g 11.2.0.1.0（双节点RAC群集），ArcGIS Desktop 10.1。 一般在Oracle单机实例的情况下需要存储ArcGIS空间数据，第一次需要使用ArcGIS工具箱中的Create Enterprise Geodatabase工具生成SDE用户、表空间及相应的管理表，这个在Oracle单机实例情况下是没有问题的。 但是在Oracle RAC群集的情况下使用该工具创建SDE相关内容时，会创建失败...
Symptoms The command "opatch lsinventory" reports the error: OUI-67076:OracleHomeInventory was not able to create a lock file, probably due to a failed OPatch Session. The loaded inventory might not show correctly what you have in the Oracle Home.CauseA previous "opatch apply" session failed and so a lock still exists on the local inventorySolution 1. Take a backup of $ORACLE_HOME/.patch_storage2...
CREATETABLE employees_demo
( employee_id NUMBER(6)
, first_name VARCHAR2(20)
, last_name VARCHAR2(25)
CONSTRAINT emp_last_name_nn_demo NOTNULL
, email VARCHAR2(25)
CONSTRAINT emp_email_nn_demo NOTNULL
, phone_number VARCHAR2(20)
, hire_date DATE DEFAULT SYSDATE
CONSTRAINT emp_hire_date_nn_demo NOTNULL
, job_id VARCHAR2(10)
CONSTRAINT emp_job_nn_demo NOTNULL
, salary NUMBER(8,2)
CONSTRAINT emp_sala...
show user; select sys_context(‘userenv‘,‘session_user‘) from dual; select user from dual; 查看所有登录的用户必须为DBA 用户： select username from v$session;
sys、system等DBA 用户查看 其他用户(test)中的对象(表)：
SQL> select * from test.student;
创建一个普通用户都把该用户用起来的流程：
1、创建用户
SQL>create user test indentified by test;
这样就创建了一个用户名密码都为...
I have installed 10gR2 on linux environment, When running DBCA it got filed with below error
ORA-27125: unable to create shared memory segment
SOLUTION:
cd $ORACLE_HOME/bin
mv oracle oracle.bin
—- Paste it as one —
cat >oracle <<“EOF”
#!/bin/bash
export DISABLE_HUGETLBFS=1
exec $ORACLE_HOME/bin/oracle.bin $@
EOF
—- End of paste —
chmod +x oracle
Thank You !!oracle 10gr2 ORA-27125: ...
CREATE OR REPLACE PROCEDURE proc_Insert_BookKindList
(
temTypeName nvarchar2,
temParent int
)
AS
ncount number;
begin
--SELECT COUNT (*) INTO ncount FROM BookKindList fm1 where EXISTS (SELECT BookKindName from BookKindList fm2 where fm2.BookKindName=temTypeName);--判斷是否存
SELECT count(*) INTO ncount FROM BookKindList where BookKindName=temTypeName;
if ncount<=0 then
begin
INSERT INTO BookKin...
6. 使用约束时的注意事项
约束里不能用系统函数,如SYSDATE和别的表的字段比较
可以用本表内字段的比较
想在事务处理后, 做约束的
检查
SQL> alter session set constraints deferred.
7. 由实体关系图到创建表的例子 s_dept
前提条件:已有region表且含唯一关键字的字段id
SQL> CREATE TABLE s_dept
(id NUMBER(7)
CONSTRAINT s_dept_id_pk PRIMARY KEY,
name VARCHAR2(25)
CONSTRAINT s_dept_name_nn NOT NULL,
region_id NUMBER(7...
系统环境： 操作系统： RedHat EL5.5 Cluster： Oracle Grid 11.2.0.1.0 Oracle： Oracle 11g 11.2.0.1.0故障现象： 在Oracle 11gR2 RAC添加新节点的过程中，在new node上运行root.sh时出现以下故障：[root@node3 install]# /u01/11.2.0/grid/root.shRunning Oracle 11g root.sh script...The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /u01/11.2.0...
----------------------Create Table--------------------------------create table SMS_EXTERNALSYSSMSREQUEST( SMSSENDRECID VARCHAR2(20) primary key not null, SOURCEREF NUMBER(38) not null, SURVEYSVCNO VARCHAR2(30) not null, SURVEYNAME VARCHAR2(30), SENDDATETIME DATE, CREATEUSERID VARCHAR2(10) not null, CREATEDATETIME DATE not null, CHANGEUSERID VARCHAR2(10), CHANGEDATETIME...
当你试图输入了用户名:sys
密码：通用
之后，你发现连接不上；
而输入 用户名：system
密码：通用
或者 用户名：scott
密码：tiger
的时候都可以连接，所以你认为
sys的权限没有system高；
其实正是因为sys的权限高，所以你必须以
dba的身份来登陆：sys/通用 as sysdba
//可以使用数据字典user_users来查看当前用户管理的用户：
select * from user_users;
而dba_users可以查...
标签：type create oracle object record一：Oracle中的类型有很多种，主要可以分为以下几类：1、字符串类型。如：char、nchar、varchar2、nvarchar2。2、数值类型。如：int、number(p,s)、integer、smallint。3、日期类型。如：date、interval、timestamp。4、PL/SQL类型。如：pls_integer、binary_integer、binary_double(10g)、binary_float(10g)、boolean。plsql类型是不能在sql环境中使用的，比如建表时。5、自定义类型：type...
-创建一个student表,设定表的主键为学号CREATE TABLE student( sno VARCHAR2(10) PRIMARY KEY, --列级约束 sno VARCHAR2(20) CONSTRAINT sno_pk PRIMARY KEY, --有约束名的列级约束 sname VARCHAR2(10) DEFAULT ‘张三‘, ssex VARCHAR2(1), sbirthday DATE, saddress VARCHAR2(50), --创建表级约束 CONSTRAINT sno_pk PRIMARY KEY(sno))
--查询表studentSELECT * FROM student...
--创建一个用户yong2，yong2的表空间为users，临时表空间为temp，users的表空间大小为10M,密码立刻过期，用户锁定。
CREATE USER yong2IDENTIFIED BY qwerDEFAULT TABLESPACE usersTEMPORARY TABLESPACE tempQUOTA 10m ON usersPASSWORD EXPIREACCOUNT LOCK;
--修改yong2密码为inspur123,并给用户解锁。
ALTER USER yong2 IDENTIFIED BY inspur123;ALTER USER yong2 ACCOUNT UNLOCK;
--给用户yong2授予创建会话的权限GRANT create ...
=> ‘JOB_BASIC_STATISTIC‘,
job_type => ‘STORED_PROCEDURE‘,
job_action => ‘PROC_BASIC_STATISTIC‘, --存储过程名
start_date => to_date(to_char(sysdate,‘yyyy-mm-dd‘)||‘ 19:32:00‘, ‘yyyy-mm-dd hh24:mi:ss‘),
REPEAT_INTERVAL => ‘freq=minutely;interval=1‘,
enabled => true,
end_date => to_date(to_char(sysdate,‘yyyy-mm-dd‘)||‘ 20:34:00‘, ‘yyyy-mm-dd hh24:mi:ss‘),
comments => ‘执行定时统计数据‘);
commit;
end;