Oracle implicit cursors, display cursors, cursor loops, dynamic SELECT statements and dynamic cursors, exception handling, custom exceptions ____oracle

The concept of cursors: A cursor is a memory workspace of SQL that is defined by the system or user as a variable. The role of a cursor is to temporarily store blocks of data that are extracted from the database. In some cases, the data needs to be

Oracle data import and Export ____oracle

Import Export of data Description: Objects targeted: Import and export of data the role involved is primarily the engineering implementation personnel. The problem to be solved is to import the required data from one database into another. 1 Tools

How to use Oracle databases in PHP

In php3.0 above, PHP has nearly all of the current database processing functions, including Oracle; In this article we have an example of how to use these functions to manipulate Oracle databases. PHP provides 2 classes of APIs (application

How to access trace files using an Oracle external table

As I said earlier, Oracle's external tables can be used to access warning log files, but Oracle's external tables can be very flexible to use. After creating the appropriate directory with the Create Directory command, we can grant access to the

Installation of Oracle Enterprise Manager Cloud Control 12c

Here, I am introducing the installation of the cloud Control 12c. The previous version is called Grid Control, which is also known as 11g. When I write this blog, the Cloud Control 13c has come out, this version follow me to introduce.  Before

Oracle Sales Cloud: Reporting and Analysis (BIEE) Small details 2--use variables and filters to pass parameters (for example, show data from different departments based on hints)

In the last essay, we set up two tips for departments and sub-departments, and we associate departments with sub-departments. So, in this essay, we focus on the use of the built-in double hints for the transfer of parameters.Before we do this, let's

Oracle Online redo log files (online redo log file)

Oracle Online redo log files (online redo log fileAlmost all of the internal changes that occur in Oracle are recorded in the online redo log file, and Oracle uses these redo log groups to recover the database, so they are very important.The main

25. Oracle PL/SQL Advanced-control structure (branch, loop, control)

First, the advanced level of PL/SQL-control structureIn any computer language (c,java,pascal) there are various control statements (conditional statements, loop structures, sequential control structures ...), and there are also such control

The difference between Oracle Service name and SID

Database name (db_name), instance name (instance_name), and operating system environment variables (ORACLE_SID)   only database name (db_name) and DB instance name (Instance_) in ORACLE7, 8 database Name). A new parameter, the database domain name

Several common SCN in Oracle database

SCN in the control file SCN for data file header SCN in a data block SCN in the log file header Transaction SCN In-memory SCN The SCN in a control file 1.1 Database SCN Database SCN represents the SCN for the most recent full-volume checkpoint

Where does Oracle SQL Developer store connections? Oracle SQL Developer connection information where to save, where

Where is the Oracle SQL Developer connection information saved?Oracle SQL Developer connection information is missing after switching the logged-on user. As long as the previous user information still exists, you can C:\Users\ the user name \appdata\

Reprint: Generate Oracle Performance Excel curve using python one click

Article turned from: http://www.shsnc.cn/show-109-970-1.htmlFor further details, refer to: http://xlsxwriter.readthedocs.io/tutorial01.html1.Why do you want to generate graphsFor Oracle database operations, sometimes it takes a week to see how the

Connect to Oracle 11g remote database using instantclient_11_2 and PL/SQL Developer Toolkit (RPM)

1, first download instant Client to Oracle website:Http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.htmlChoose a different instant client version based on your operating systemDownload back is a compressed file,

Oracle Date minute solution and week start end time calculation

1 ORACLE mid-week related knowledge description 1.1 Date formatting functions To_char (X [,FORMAT]) : Press X toFORMATThe format is converted into a string. X is a date,FORMATis a format string that specifies the format in which X is

Oracle database monitoring Configuration and services

Plsql Developer non-installed configuration directory for file directory 1 is C:\Program files\oracle\instantclient-basic-nt-11.2.0.4.0\instantclient_11_22 is c \ Program Files\oracle\instantclient-basic-nt-11.2.0.4.0\instantclient_11_2\oci.dll then

Oracle Stored Procedure (2)-call of Stored Procedure

The use of any language or technology is the final principle. Why should we use stored procedures? Not applicable? Is there anything better than a stored procedure ?, With these series of problems, we can enter the use stage of the stored procedure.1

Mybatis implements the oracle primary key auto-increment mechanism tutorial, mybatisoracle

Mybatis implements the oracle primary key auto-increment mechanism tutorial, mybatisoracle How to Implement oracle primary key auto-increment using mybatis First, let's look at how to create primary keys for the same student table, mysql, SQL

Oracle Database 12c six years of development

With the rapid development of cloud computing, mobile and social technology, the role of enterprise data centers is constantly changing. Enterprises need stronger computing capabilities, simpler IT architecture, and more controllable O & M costs.

Oracle reports RMAN active duplicate hanging on restore control file

After 12.1.0.2, when duplicate target database for standby from active database, hang will always die in restore controlfile. This error is caused by a Bug of 19664695. (Both Bug22468652 and Bug 20721271 can be attributed to Bug 19664695 .)The

Total Pages: 2147 1 .... 39 40 41 42 43 .... 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.