oracleebs学习总结.docVIP

HOST文件 c://windows/system32/drivers/etc/hosts 最后加入 浏览器进入 :8000 user:yysoft_zhm password:yysoft2015 TNS文件 D:\DevSuiteHome_1\NETWORK\ADMIN\tnsnames.ora yysoft= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) (CONNECT_DATA= (SID=vis) ) ) 建表、同义词、序列 -- Create table create table CUX.HYP_VENDORS ( VENDOR_ID NUMBER not null, VENDOR_CODE VARCHAR2(20), VENDOR_NAME VARCHAR2(50), ADDRESS1 VARCHAR2(200), VENDOR_TYPE VARCHAR2(1), CREATION_DATE DATE, UPDATED_DATE DATE ); create or replace synonym HYP_VENDORS for CUX.HYP_VENDORS; -- Create sequence create sequence hyp_vendors_s minvalue 1 maxvaluestart with 100001 increment by 1; WHEN-NEW-FORM-INSTANCE go_block(‘block_name’); app_window.set_window_position(‘child_block’,’center’,’parent_block’); QUERY-FIND go_block(‘block_name’); PRE-INSERT :block_name.item_name := package_name.function_name(parameter1…); WHEN-NEW-RECORD-INSTANCE If :block_name.item_name ‘N’ then Set_block_property(‘block_name’,DELETE_ALLOWED | DEFAULT_WHERE,PROPERTY_FALSE); End if; 记录组的建立 Select_statement LOV的建立 选择现有记录组 LOV返回值 LOV分配的项 LOV高：4750，宽：3000 开关服务器的步骤 开机： 按开机键 登陆root 密码：Founder123 进入数据库 su – oracle 密码：oracle 输入：sh startDB.sh 进入应用服务器 su – applmgr 密码：applmgr 输入：sh startAPP.sh 关机： 进入应用服务器 su – applmgr 密码：applmgr 输入：sh stopAPP.sh 进入数据库 su – oracle 密码：oracle 输入：sh stopDB.sh 进入根目录 su – root 密码：Founder123 输入：shutdown-h now 创建数据视图 CREATE OR REPLACE VIEW view_name AS Select_statement; 创建触发器 CREATE OR REPLACE TRIGGER trigger_name INSTEAD OF INSERT OR UPDATE OR DELETE ON view_name FOR EACH ROW DECLARE BEGIN IF inserting THEN INSERT INTO table_name VALUES(); END IF; IF updating THEN UPDATE table_name set item = vlaue WHERE primary_key = primary_key; END IF; IF deleting THEN DELETE F