oracle ebs implementation

Tags: des blog file Data div log as new database1, set up a "Oracle_backup" folder in the E-disk, the folder is built two folders are: "New", "old", and then create a new bat file in the Oracle_backup folder, named "Expdb.bat", the contents are as follows:REM * * File:expdb.batREM * * Name:database BackupREM * * Desc:database backup fileCopy e:\oracle_backup\new\*.dmp E:\oracle_backup\oldExp Username/[email protected] file= ' e:\oracle_backup\new\db.dmp ' full=y buffer=640000 log= ' e:\oracle_ba

First, create a table: CREATE TABLE Example ( ID Number (4) Not NULL PRIMARY KEY, NAME VARCHAR (25)); Then, customize a sequence (sequence): CREATE SEQUENCE example_sequence INCREMENT by 1--add a few each time Start with 1-counting starting from 1 Nomaxvalue--Do not set the maximum value Nocycle--keep accumulating, not looping NOCACHE--Do not build buffers Create a second trigger: CREATE TRIGGER Example_triger before INSERT on

First look at how SQL writesSelect * from ( Select A.*, ROWNUM rn from (lowest query statement ) A wherelt; = #{endcol} ) where gt; #{startcol}Note: Of course we also need select COUNT (*) the lowest query statement to get the total number of result sets. And then convert the Endcol and Startcol.The conversion code is as follows://int totalrecord= total number of bars; //Calculate Paging

Tags: cells for end int inserting data maximum char IDT whenFirst, create a table: CREATE TABLE Example ( ID Number (4) Not NULL PRIMARY KEY, NAME VARCHAR (25)); Then, customize a sequence (sequence): CREATE SEQUENCE example_sequence INCREMENT by 1--add a few each time Start with 1-counting starting from 1 Nomaxvalue--Do not set the maximum value Nocycle--keep accumulating, not looping NOCACHE--Do not build buffers Create a second trigg

Tags: database information ROM image into tracking int context host---Create log table records user logon informationCREATE TABLE User_log(user_id VARCHAR2 (30),session_id Number (10),HOST_NAME VARCHAR2 (30),Last_module VARCHAR2 (30),Logon_day DATE,Logoff_day DATE,Elapsed_minutes Number (10)); --Create a trigger after the user logs in to count the user's login information: Create or Replace Trigger Logon_triggerAfter logon on databaseBeginINSERT INTO User_logValuesUserSys_context (' Userenv ',

) {This.age = age;}}4, StuservicePackage sql2excel;Import Java.io.File;Import java.sql.Connection;Import java.sql.PreparedStatement;Import Java.sql.ResultSet;Import java.sql.SQLException;Import java.util.ArrayList;Import java.util.List;Import JXL. Sheet;Import JXL. Workbook;/*** @author Liuhaijun**/public class Stuservice {/*** @return*/public static listlisttry {Connection conn = null;conn = Dbutil.getconnection ();Create precompiled statement objects, usually with this instead of statementPrep

Label:Sequences, triggers, and other related uses SQL Server under Microsoft grows as long as the set column identity Create Table myTable ( intIdentity(1,1primarykey NOT null, varchar() ; MySQL to achieve self-growth as long as the set column auto_increment Create Table myTable ( intprimarykeynotnull, varchar(() ); The Oracle database is a bit different, and does not have a self-growing column type like MySQL and SQL Server databases, but ra

Tags: Oracle--Delete the previously existing table: drop table emp; --Creating the Table EMP CREATE TABLE emp ( deptno number, ename varchar2 (), sal number ); --Insert data- -Department 1 Employee Information INSERT INTO EMP values (1, ' Wang Hee 1 ', 15000); INSERT into EMP values (1, ' King Hee 2 ', "); INSERT into EMP values (1, ' King Hee 3 ', 115000); INSERT into EMP values (1, ' King Hee 4 ', 12300); --Department 2 employee in