Oracle

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

The 10 Gb archive log of Oracle Database is stored in flash_recovery_area by default, and 1 GB is selected during the default installation. When the archiving log exceeds 1 GB, the space is insufficient, so the archive log file cannot be archived.

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

-- Oracle service reconstruction method (-- telemt is the database name) > Oradim-New-Sid telemt-srvc oracleservicetelemt-intpwd Oracle-pfile C: \ oracle \ product \ 10.2.0 \ Admin \ telemt \ pfile \ init. ora.89200801642 -- Still unsolved>

Sometimes we may have this requirement: Create a trigger on the table, and then when the fields A and B are updated in the table, the field C is changed to a + B, this forms the situation of modifying the base table data in the trigger. Create a

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 <>

Software environment:1. Windows XP + Oracle 10g2. Oracle installation path: D:/Oracle Implementation Method: 1. Choose "start"> "Settings"> "Control Panel"> "Management Tools"> "services" to stop all Oracle services;2. Start-> Program-> Oracle-oradb1

-- 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

The database table contains three columns: ID name banben (Version) (the column value is a number ). The ID is unique, the name is not unique, and the banben is not unique, but the combination of name and banben is unique. Find the ID of the row

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

Basically, the syntax used is as follows: A. Obtain the syntax for creating a single table and an index Set heading off; Set echo off; Set pages 999; Set long 90000; Spool Dept. SQL Select dbms_metadata.get_ddl ('table', 'dept', 'Scott ') from

Exp encountered ORA-06552 error solution (PLS-553: Character Set Name is not recognized) There is a built data, Oracle 9.2.0.4 for Linux, character set is the default we8iso8859p1, not changed to zhs16gbk. the database does not have any

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

Sometimes Oracle databases cannot use indexes. There are many reasons for this phenomenon. How can we locate it? This article mainly introduces this part. First, determine the optimization mode in which the database runs. The corresponding parameter

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.

Research on spatial GIS data uploading methods in Oracle Spatial)   Source: http://blog.sina.com.cn/s/reader_45f260910100999x.html     Abstract: Oracle Spatial is used to store and manage spatial data, it is easy to solve problems in data sharing,

Applies:Oracle Server-Enterprise Edition-version: 10.1.0.5.0This problem can occur on any platform.Symptoms:The issue is that the following error was raised:ORA-00600: Internal error code, arguments: [kesutlGetBindValue-2], [], [], [], [], [], [], []

I started learning Oracle9i today, so I won't talk about installation. Here is the portal. I have a problem with the second dish, and I am out of touch with the traditional installation method. I ignore it, we directly found a RAR download of CD2