Oracle

Stored Procedure creation Syntax:Create or Replace procedure stored procedure name (param1 in type,param2 out type)AsVariable 1 type (value range);Variable 2 type (value range);BeginSelect COUNT (*) into variable 1 from table A where column name

There has recently been a need to use triggers to make changes to a column of the inserted data, thus collating the trigger notation of Oracle and SQL Server for such requirements, and this article only mentions insert triggers.First we create a

Because of the project needs, in a Query page query field Support multi-keyword query, support space-delimited query conditions, it is implemented as follows:The principle used is: thefunction Regexp_likethat supports regular expressions in Oracle,'

a connection is not synonymous with a session and can be established on a connection 0 One or more sessions. Each session is separate and independent, even if they share the same database physical connection. Commits in one session do not affect any

Import Java.sql.connection;import Java.sql.drivermanager;import Java.sql.preparedstatement;import Java.sql.resultset;import java.sql.statement;//The custom JDBC tool class. The goal is to simplify JDBC development. public class Jdbcutil {public

First, start the service, (skip this step if the database is in a startup state)Open the command line to execute the following statementnet start ORACLESERVICEORCLnet start Oracleoradb10g_home2tnslistenernet start Oracleoradb10g_home2isql*plusThe

Assignment of permissions:1. Grant is used to assign roles, system permissions, object permissions to users, and roles.2. Preconditions for empowerment:System permissions: "Grant any privilege" system permissions, the system has been granted

In the command line, the Oracle user unlocks the operation method, through a few simple unlock statements can do this work. Here are the specific procedures:Unlock Users1: Log in to Oracle using an Administrator accountSqlplus system/Password2:

Build table:SELECT * FROM fruit;create table fruit (id varchar (+) NOT NULL, name varchar () default "NOT NULL", price varchar () default ' NOT NULL, area varchar (+) default ' NOT NULL, PRIMARY key (ID)) INSERT into fruit (id,name,pri Ce,area)

ORA-01555 snapshot is too old, is a common error in the database, such as when our transaction needs to use Undo to build a CR block,And at this time the corresponding undo no longer exists, this time will be reported ORA-01555 error.Environment is

1-show pagesize # # #显示页行数Set PageSize # # #显示页行数为3002-show Linesize # # #显示行宽度Set Linesize # # #显示行宽度为3003-show Numwidth # # #显示数字字段长度Set Numwidth Ten # # #显示数字列长度4-Save Forever/u01/app/oracle/product/11.2.0/db_1/sqlplus/admin/glogin.sql # #

First connect the Sqlplus:Sqlplus/nologConn System/manager1. Manually create a directory to hold the exported DMP fileCreate or replace directory Whboa as ' E:\oracleDate\dmp ';2. Authorizing the CatalogGrant Read,write on directory Whboa to public;3

A new 64-bit Win7 system has recently been installed that requires an Oracle database for work, and a database that is managed and maintained by the company's it dba.We only need to connect to use it, so I installed the Oracle client x64 and PL/SQL

Oracle Number type query, sometimes you encounter the problem of loss of precision, the following shows you a resolution of the Oracle Number type query precision loss method for your reference.One, the Oracle number type query needs to find the

Use of the Oracle to_date () functionTo_date () is one of the representative functions of Oracle database functions, and the following is a detailed description of several uses of the Oracle To_date () function for your reference.In Oracle database,

1. Build the EnvironmentMain Library ORACLE11GR2 Library ORACLE11GR2Db_name ORCL ORCLDb_unique_name ORCL standby239Configuring the Host FileMain Library: Primaryhost Library: StandbyhostThe prepare library is placed in archive mode.2. Configure

1. View all users in the Oracle database: (1) Log in to the database using an account with DBA authority; (2) Execute select username from dba_users. SQL> conn sys input password: connected. SQL>Select from dba_users; USERNAME-----------------------

The original in this pokeRegexp_like3 parametersThe first one is the string enteredThe second one is the regular expressionThe third is the range of values:I: case is not sensitive;C: Case sensitive;N: Point number. Do not match line break symbols;M:

SYSDBA and Sysoper are administrative permissions that are performed by the user to perform advanced administrative operations such as creating an on/off backup/restore database.SYSDBA system permissions are for database administrators who want to

1. Aggregation functionCount (field) //number of non-empty lines max (field) //Get maximum sum (field) //Sum avg (field)/ / average min (field) / min value2. Conversion functionTo_date ()