Oracle

Download Oracle Instantclient_11_2 and PlsqlExtract Oracle Instantclient_11_2 to any directoryCreate a new network in this directory, create a new admin in the network directory, and in the installation directory from OracleCopy the Sqlnet.ora and

1 Create or Replace functionMca_detail_material_val (P_material_codeVARCHAR2,--actual Parameters2P_material_nameVARCHAR2,3P_mca_noVARCHAR24 ) 5 RETURN varchar2 as6 7 --Item code/name

1 Create or Replace functionWork_plan_mask (P_schemaVARCHAR2, p_tableVARCHAR2)2 3 return Varchar2 as --data control, specifying that certain people can only view information within their purview4 5V_predicateVARCHAR2( +) := '1=2';6V_personcode

  Backup Restore the backup RESTORE command under Oracle database Winserver and Linxu is the same basic format: IMP and exp are not suitable for large file backups, and if the file exceeds 20 g, this approach is inefficient and if the file is too

Oracle Notes (14) User managementSQL statements are divided into three categories: DML, DDL, DCL, before the DML and DDL have been explained, now the DCL operation, DCL mainly represents the database control statements, control is the operation of

Oracle Notes (16) database design paradigmThe database design paradigm is a very important concept, but this important degree is only suitable for reference. Using the database design paradigm, you can make the data table better to save the data,

ROWNUMROWNUM: Represents a row number, which is actually a column, but this column is a pseudo-column that can appear in each table.Example: On the Query Employee table, add ROWNUMSELECT from EMP;From the running, the ROWNUM itself is in the form

Recovery in Rman corresponds to two operations: Database repair (Restore) and database recovery (recover)Database repair (Restore): A data file that uses a backup set to replace a corrupted database file or restore it to a new location. When Rman is

--Modify the Data Oracle field type from number to varchar--Example: Modifying the Rescue_phone field type in the Ta_sp_org_invoice table, converting from number to varchar--STEP1: Add an original type buffer fieldALTER TABLE Ta_sp_org_invoice add

InsertId="Insertgoodsdescription" Parameterclass="Goodsdescription"> Selectkey ResultClass="int"Keyproperty="Servicedescriptionid"> SELECTGoods_description_seq.nextval asservice_description_id fromDualSelectkey> Insert

1- save Excel file as (text file (Tab delimited) (*.txt))2- Open PL/SQL Create temp table jh_info, Open tool - text Importer3- Open the file location in the upper left corner, select the prepared txt file, and open it. 4- Switch to Oracle data,

REGEXP_SUBSTR Functions in OracleInstructions for using the REGEXP_SUBSTR function in Oracle:The topics are as follows:In Oracle, a statement is used to implement the ' 17,20,23 ' split into a collection of ' 17 ', ' 20 ', ' 23 '.The REGEXP_SUBSTR

This is the first to meet the entire library is normal, but a table query error situationA table data can be checked, but a sort of check on the errorSELECT * from Acct_daily_bak;SELECT * from Acct_daily_bak ORDER by open_time Desc;Ora-01578:oracle

Normal Import method (cmd command): First build table space, then build user IMP database name/database password @orcl file= database file path (can be dragged in automatically generated) Full=y St                       Atistics=none Common Export

Oracle Recovery method for accidental deletion of dataLearning the database, we are just learning attitude, consider how to use the database command statements, did not think about the work, if the wrong operation, can lead to irreparable loss. When

1. Enter Sqlplus modeSqlplus/as Sysdba;2. Change your account password againAlter user username identified by original password;3. Check the validity period of the user password (the default configuration file is defaulted)SELECT * from Dba_profiles

This article is mainly about MyBatis in connection with the Oracle database , some of the bulk operations, please(finally come back to add, all in the framework of the SPRING+MVC implementation)No nonsense, on the code:1, BULK Insert (online a lot,

Oracle generates non-repeated ticket numbers and LPAD, RPAD and NEXTVAL function parsing, and lpadnextval SELECT TO_CHAR (SYSDATE, 'yymmdd') | LPAD (REFUNDSEQ. NEXTVAL, 6, '0') AS RES_ORDER_NO FROM DUAL The statement splicing time is consistent with

Solution to ora-12899 errors in Oracle databases, oracleora-12899 ORACLE may cause various problems and errors, the ORA-12899 is a problem that occurred some time ago when I imported data to my local machine. but fortunately, this problem has been

Set the script for automatic archiving and Archiving Root User Mkdir-p/home/temp Cd temp Mkdir bin log tmp Chown-R oracle: oinstall/home/temp/bin Chown-R oracle: oinstall/home/temp/log Chown-R oracle: oinstall/home/temp/tmp