Oracle

Steven Feuerstein Four simple guidelines for improving the number and quality of PL/SQL code I've been writing PL/SQL code since 1990. This means that I have written tens of thousands of lines of software code, but I am sure that most of the

Previously reprinted an article installed on Windows, I actually installed on the CentOS. The following are the installation records:First, operating system environmentII. database environment (log in with Oracle user)Third, DG4ODBCIn Oracle DB 11g,

SQL statement stitching can be performed using execute immediate when the database handles complex business logic in a developed application scenarioInsert into Tb_temp_public (v1, v2, V3, V4, v5,v6,v7,v8,v9) Select ",", ",", ",", ",", "from

This article summarizes the knowledge of the Oracle EBS Purchase Order (PO) module Package Purchase agreement, which is summarized as follows:1 , Theoretical introduction(1) Noun termsA blanket purchase agreement (Blanket Purchase AGREEMENT,BPA) is

Chapter One: Log Management1.forcing Log Switchessql> alter system switch logfile;2.forcing checkpointsSql> alter system checkpoint;3.adding Online Redo Log groupssql> ALTER DATABASE Add logfile [Group 4]Sql> ('/disk3/log4a.rdo ', '/disk4/log4b.rdo '

Querying the most resource-intensive queries from V$sqlareaSelect B.username Username,a.disk_reads reads,A.executions Exec,a.disk_reads/decode (a.executions,0,1,a.executions) Rds_exec_ratio,A.sql_text StatementFrom V$sqlarea A,dba_users bwhere

Before 12c, if you want to achieve the automatic growth of column, usually through the sequence, but this problem is resolved in 12c, Oracle deferred the identity column function, which solves the previous problem perfectly, here is my simple test,

SELECT b.*,RANK () over (PARTITION by B.dname ORDER by B.sal) as Rank_num,Dense_rank () over (PARTITION by B.dname ORDER by B.sal) as Dence_rank,MIN (SAL) KEEP (Dense_rank first ORDER by B.sal) through (PARTITION by B.dname) as First_val,MAX (SAL)

There was a project to install Oracle The client then lets ASP. System.Data.OracleClient to access the Oracle database, but does not know why it is always reported: ORA-12170: The connection timed out error (the client's server configuration is:

Imitate1 Createsequence seq_id2MinValue13MaxValue999999994Start with 15Increment by 16 NoCache7 Order;8 9 To create a trigger:Ten One Create Triggertri_test_id--(1) ABeforeInsert onTest forEach row--test is a table name - begin -

Some time ago on the local XP system to test some of the integration of JavaBean form example, want to publish to the server segment to see if it works properly, at first think it will be the same as the local XP system, deploy to the relevant

There are two types of cursors in Oracle: Explicit cursors, implicit cursors. The display cursor is a cursor defined with the cursor...is command, which can process multiple records returned by a query statement (SELECT), whereas an implicit cursor

Date/Time Related queries1. Get the first day of the current monthRun this command to quickly return to the first day of the current month. You can replace "sysdate" with any date value to specify the date of the query.The code is as follows:Select

--create the tablespacecreate smallfile tablespace "Table_container"--Create TABLE space datafile ' E:\ORACLE\ORADATA\ORCL\table_ 01.DBF '--Create data file, file location of data file size 100M--Initial size of data file autoextend on NEXT

2015-10-24DirectoryResources[1] Oracle Database Import and Export command![2] Oracle database Import and Export command summary[3] Oracle data import and export[4] Oracle Import and Export command[5] Oracle Import and Export[6] An explanation of the

First, EXPDP and IMPDP instructions for useOracle Database 10g introduces the latest data Dump technology, the role of data Pump export import (EXPDP and IMPDP)1) Implement logical backup and logical recovery.2) Move objects between database users.3)

Preparatory work: Main Library Enable archiving Install Oralce 11g software on all systems Repository to create the necessary directories Create a listener, configure the Tnsname file The first step:A copy of the password

--Exception handlingDeclare Snum number: = 0;Begin Snum: = 5/snum; Dbms_output.put_line (Snum); When others then Dbms_output.put_line (' is error! ');End--Custom exceptionsDeclare Ex_custom_invaild_age exception; --Custom Exception

Oracle SQL BASICS (3)-index/trigger/view operations, oraclesql This document only lists simple operation statements for indexes, triggers, and views. 1. Index A. Create Create index idx_name on fdh_client_info (name); -- Common index (Single Column

Common commands for creating, updating, and deleting MongoDb documentsMongodb is written by C ++. Its name comes from the middle part of the word humongous. From its name, we can see that its ambition lies in the processing of massive data. The