Oracle

Oracle 9i provides 16 scalar data types, as shown in Table 7.4.Table 7.4 scalar Data Types of Oracle 9i Name Description Char Used to describe

1. Select name, type from SYS. all_sourceWhere instr (upper (text), 'tbname')> 02. Select name, type from user_dependencies where referenced_name = upper ('tablename ');3. Dynamically input a table name and create a new table in the Stored

1. Start the script-----------------------------------------------Net start oracleoradb10g_home1tnslistenerNet start oracleserviceorclRem Net start oracleoradb10g_home1isql * PlusRem Net start oraclejobschedulermyoracleNet start oracledbconsoleorcl--

Oracle stored procedure [reprinted] Http://blog.bossma.cn/archives/2008/01/80 1. Insert data:Insert several data entries into a table /* Create a table tb1 contains two fields: col1 and col2 */ Create Table tb1 (

Without authid CURRENT_USER, The definer permission (definer rights) is executed as the definer identity; If authid CURRENT_USER is added, the caller permission (invoker rights) is executed as the caller.   Example:   1. Create two users: xxpo and

Create or replace trigger update_sys_ins_tasksBefore update on sys_inst_tasksFor each rowDeclare-- Local variables hereFinished number;Nowproc varchar2 (4000 );BeginFinished: =: New. finished;Nowproc: =: New. nowproc;If finished = 1 and nowproc <>

-- View all tables of the current user in the Oracle database Select table_name from user_tables; -- View All tables under all users in the Oracle databaseSelect User, table_name from all_tables; -- View all user columns in the Oracle

You can also use the field name like '% string %' in Oracle. However, this method cannot use indexes and is not fast. Use a string to compare the instr function (field name, 'string') to 0 to get more accurate search results. Processing of Oracle

Create or replace package pkg_tools Is Type resultdata is ref cursor; Procedure sp_page (p_pagesize int, -- number of records per page P_pageno int, -- current page number, starting from 1 P_sqlselect varchar2, -- query statement, including sorting

All scripts and instructions for creating databases manually System Environment: 1. Operating System: Windows 2000 Server, 128 MB of machine memory 2. Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition 3. installation path: D: \ oracle Steps

After several hours, I finally realized why the self-started script could not be successfully executed. It turned out to be a space error. The steps are described as follows: 1. Modify the dbstart and dbshut scripts. The default dbstart script

C: \ Documents ents and Settings \ Administrator> oradim-startup-Sid testbas C: \ Documents ents and Settings \ Administrator> set oracle_sid = testbas C: \ Documents ents and Settings \ Administrator> sqlplus "/As sysdba" SQL * Plus: Release 9.2.0.4

1. Basic Structure Create or replace procedure ( Parameter 1 in number, Parameter 2 in number ) Is Variable 1 integer: = 0; Variable 2 date; Begin End stored procedure name 2. Select into statementSave the result of the SELECT query to a variable.

Problem:[Root @ rac2 ~] #/U01/APP/11.2.0/GRID/root. Sh Running Oracle 11g root. Sh script... The following environment variables are set:Oracle_owner = OracleORACLE_HOME =/u01/APP/11.2.0/Grid Enter the full pathname of the local bin directory:

package com.huawei.oracle;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class OracleTest {public static void main(String[] args) throws

Two effective methods for creating Oracle dblinkTwo different database servers read data from one user on one database server from another database server. In this case, you can use dblink. In fact, dblink is similar to the view in the database.

Windows is a very fragile system. It may crash in a few days after it is installed. If you have Oracle installed in windows, how can you restore the database? One method is to use IMP to import the original data after reinstalling the database, but

On Thursday's European version of The Wall Street Journal, Oracle published a large number of front-page ads to talk to Sun Microsystems customers. This advertisement promises to increase investments in Sun's hardware and Solaris software, but it

The query date is an operation that you often encounter when using the Oracle database. The following lists some Oracle query date statements. If you are interested, take a look. Oracle query date statements are frequently used when we use

In Oracle, sequence is the so-called serial number, which is automatically increased every time it is obtained. It is generally used in places where the sequence numbers need to be sorted.1. Create SequenceFirst, you must have the create sequence or