Oracle Database search Stored Procedure

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

Oracle cold backup and recovery

Method 1: the simplest method (database creation required) Backup:Directly copy the admin and oradata folders in the Oracle directory and the database under the ora92 directory to other storage for backup. Recovery:1. Create a database that is

C # The simplest example of calling an oracle Stored Procedure

Oracle 1. Create an oracle Stored Procedure Create or replace procedure proce_test (paramin in varchar2, paramout out varchar2, paraminout in out varchar2) As Varparam varchar2 (28 ); Begin Varparam: = paramin; Paramout: = varparam | paraminout; End;

Oracle-Materialized View

Create or replace view ov_applicant of ob_applicant with object OID (applicantid) as select * from applicant; -- ov_applicant is equivalent to applicant. Insert into ov_applicant values g_ob_applicantinfo; -- Insert data in g_ob_applicantinfo

Oracle converts sqlserver

Recently, a Project Database of the company was converted to SQL Server (2000 or 2005) as a database of Oracle. At the beginning, I found some information on the Internet, I found a tool called swissql. I tried it and failed to find it again. later,

Oracle-External Connection

Left: Select E. last_name, E. department_id, D. department_name From Employees E Left     Join Administrative ments d On (E. department_id = D. department_id ); Equivalent Select E. last_name, E. department_id, D.

Oracle System Table query

From: Http://www.gbunix.com/htmldata/2004_06/2/5/article_53_1.html The data dictionary dict always belongs to the Oracle user SYS.1. User:Select username from dba_users;Change PasswordAlter user spgroup identified by spgtest;2.

Oracle recursive query

In database queries, data in the tree structure is often queried. You need to use the data of a field as the parent node of the next record to continue the query, if you do not know how many nodes there are, writing SQL queries again and again will

Oracle-Function)

Format: (not in package) Create or replace function function_name (argu1 [mode1] datatype1, argu2 [mode2] datatype2,...) return datatype isResult varchar2 (50 );BeginReturn result; end; Call: VaR V1 varchar2 (100) Exec: V1: = function_name;

Create a job in Oracle (note that you must execute the job in the PLSQL command window)

 1. Create a stored procedure Create Or Replace Procedure My_procedure Is -- The cursor is used here. Cursor Cur Is Select * From Users Where Length (name) > 10 ; Begin For User In Cur Loop Insert Into

Oracle searches for and deletes duplicate records in a table

Case: one field in an application table is the primary key. when inserting data into the table, the data is first put in the temporary table (without the primary key) and then inserted into the application table. At this time, if duplicate data

Oracle collection User Permissions

[Application Scenario] preparations before the system goes online. Generally, the Dump File Import method is often used for data migration. Because the data is imported by one user, a permission error (which can be ignored) is reported during the

Oracle Database Synchronization

Oracle Database Synchronization The test is successful between two Oracle databases. The following is a summary: Requirements: There are two Oracle database servers A and B (A and B can be on the same Intranet or two independent machines on the

Oracle snapshot replication

A snapshot of an Oracle database is a table that contains query interceptions on one or more tables or views in a local or remote database. Because snapshots are a subset of a master table, you can use snapshots to speed up database queries. When

Role and security of Oracle View

Oracle As a data transformation in the original relevant database, the view is mainly used to view some data in the relevant table. You can set Oracle A view is a moving window through which you can see the data you are interested in. A

Oracle column forwarding

1. Create a table named Test 2. Add data to the test table Insert into test (student, course, score)Select 'zhang san', 'China', 78 from dual UnionSelect 'zhang san', 'mat', 87 from dual UnionSelect 'zhang san', 'English ', 82 from dual

Oracle statement Performance Optimization

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

Oracle paging stored procedures)

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

Oracle service in Linux

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

JDBC for Oracle demo

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

Total Pages: 2147 1 .... 2095 2096 2097 2098 2099 .... 2147 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.