Oracle

The Utl_file package can be used to read and write text files on the operating system, Utl_file provides file access functions on the client (form, etc.) and on the server side. Create a test directory: Create a new command window; directory: (Log

Ext.: http://chwshuang.iteye.com/blog/933926In development, it is often necessary to write a SQL statement to insert information into a table, insert the data if the field is a date type, you must convert the date type to a string literal in the SQL

Let's start a new chapter to learn!When an SQL statement is entered, the statement is present in the SQL buffer (that is, a memory area). This SQL buffer is small and can only have one SQL statement, and the SQL statement that was originally in the

Oracle common commands and functions, do a collation, for later use, easy to consult.Common commands:Connection SqlplusCommand line to run CMD entry, such as logging in the SYS mode, the command is as follows:(1). Sqlplus "sys/zhb126 as SYSDBA"(2).

The INTERVAL day to second type can be used to store the time interval in days and seconds of the unit. The following statement creates a table named promotions that stores promotional information. The Promotions table contains a column duration of

1. Issue: An error occurred while the database was synchronizing a large table from another library3 : ORA-24801 in OCI lob Functionora-02063 from Piclinkora -016918192 in Tablespace tsp_webagent2. Problem Analysis:The following is an official

PL/SQL Exception throwing and handling1. Get Exception Specific information:1 Dbms_output.put_line (‘Error code is:‘||sqlcode); 2 -- output exception number 3 dbms_output.put_line ( "error message is: ' 2. Exception throws(1) RaiseDeclareException_1

In the previous version of Oracle, your username password is case insensitive, but in 11g, the case of the database default password is sensitive, so we know the fact that JDBC will turn it into uppercase when it gives the Oracle password, it's a

PL/SQL single-line functions and group functionsA function is a program that has 0 or more parameters and has a return value. Oracle built a series of functions in SQL that can be called SQL or PLFunctions are divided into two main categories:Single-

Oracle Order Management dropship Flow for R12 Email This blogthis! Share to Twitter Share to Facebook Share to Pinterest In this blog I'll explain Oracle Drop ship Flow for r12i.What's dropship order-in dropship order, sales order line creates a

Basic information Situation:DB version: Oracle database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionOperating system version: CentOS release 5.6Speed up index creation the main consideration is from the point of view: Using

The execution and exception parts of PL/SQL in OracleI. The executive section of PL/SQL. An assignment statement. Assignment statements are divided into two types, one defining a variable and then receiving the user's IO assignment,

#!/bin/bash## du of each subdirectory in a directory for asm#d=$1  if [[ -z  $D  ]]then echo  "please provide a directory !"  exit 1fi  (for dir in  ' asmcmd ls ${d} '  do      echo ${DIR}  ' asmcmd du ${d}/${dir} | tail -1 '  done)  |  Awk -v d=

In Oracle:1, Query database name: Select Name,dbid from V$database; or show parameter db_name;2. Query instance Name: Select instance_name from v$instance; or show parameter instance_name;3. Query the database domain name: Select value from

Source of the blog post (exists and not EXISTS usage in Oracle): http://chenshuai365-163-com.iteye.com/blog/1003247Bowen Source (in VS. exists statement efficiency issues): http://www.cnblogs.com/iceword/archive/2011/02/15/1955337.htmlAexists (SQL

/Dev/shm should set how large the Oracle instance is to be started before reporting ORA-00845 /Dev/shm should set how large the Oracle instance is to be started before reporting ORA-00845Source: ORA-00845-Which value for/dev/shm is needed to startup

OracleDBConsole startup error specific service error code 2, oracledbconsoleorcl The error message is: Windows cannot start OracleDBConsoleorcl on the local computer. For more information, see System Event Logs. If this is a non-Microsoft Service,

Solution to oracle Database ORA-01654 errors, oracleora-01654 Introduction:Database suddenly reported: ORA-01654: unable to extend index BO. INDEX_indexname by 311072 in tablespace error, online query causes, found that there is only one solution,

HP-UNIX installation OraclePHCO-40381First, we need to identify the HP processor.View machinfo The product number of pa-risc is set to rp, and the product number of itanium is set to rx. Different products need to download different media from the

Common Oracle Database Problems and Solutions In the process of using Oracle databases, we often encounter one or another problems. These problems often confuse us. In this article, we have summarized some problems in the use of Oracle databases,