This chapter exercises the use of that Scott under the EMP table.
First use if/end IF;
If.sqlCREATE OR REPLACE PROCEDURE get_sal (emp_no_in in number) AUTHID Current_useris l_sal number; BEGIN SELECT sal into l_sal from emp WHERE empno
Link navigation in this series:[Lone solitary Nine swords] Oracle Knowledge Point Grooming (a) table space, user[Lone solitary Nine swords] Oracle Knowledge Point Grooming (ii) connection of databases[Lone solitary Nine swords] Oracle Knowledge
A sequence (SEQUENCE) is a sequence number generator that automatically generates a sequence number for a row in a table, producing a set of equal-spaced values (type number). Its main purpose is to generate the table's primary key value, which can
1. Create Debug folders under the following directories on database client: All log directories should is created Under/usr/openv/netbackup/logs with 777
Today bored to churn just graduated from the computer, found in 11 in the unit internship some exercises and examination questions and answers, now record here, convenient for later inspection.Assessment One:--1, List all employees who pay more than
If you are an architect, in addition to the selection of technology in the database selection, more important may be cost-effective choice, and Oracle is the cash ranked first database, so the price of Oracle is necessary to understand.Several
Refer to MOS article:Unable to Drop a datafile from the tablespace Using Alter tablespace Command (document ID 1050261.1)Any of the following conditions cannot be datafile by a drop1) must be empty, otherwise it will be reported: Ora-03262:the file
1.Overview of the Automatic Workload RepositoryThe Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics for problem detection an D self-tuning purposes. This data is both in memory and stored in the database.
1. The data file for the discovery database has special characters:2. Try to modify the tablespace offline after using the Sqlplussql> alter tablespace wst_data rename DataFile'D:\oracle11\oradata\teblespace\WST_DATA.
Application: Add a new primary key to the data table to speed up the data table access speed, and is the fastest index shaping. This program is suitable for running when you import an Oracle database without a primary key being removed.Code
1. How to access the databaseIn Oracle database management and system, there are three ways to access the database;⑴. With Sql*plus, it has SQL commands to access the database with an interactive application;⑵. Applications developed using the
This article was created by Jing and licensed under the Creative Commons Attribution-Share 3.0 Chinese mainland license agreement in the same way. Welcome reprint, but without the consent of the author must retain this paragraph, and in the article
---1, first check the user's profile in the user password life cycle, in general, the default is 180 days. When logged in, the system prompts ora-28002 that the user is about to expire--If we do not want to change the password, we can modify the
"Cause/Trigger factor"This is due to the fact that "password_life_time=180 days" is set in the default profile in oracle11g."Impact and risk"EffectAfter the password expires, the business process connects to the database exception, affecting
In the team development, everyone in the general team only need to install a client, there is no need to install an Oracle database server, and the database server is shared, at this time, we need to configure the client. There are two ways to
. net:microsoft Visual Studio +. NET Framework 3.5Operating system: windows2008 R2 64-bit operating systemOracle database: 32-bit version of Odp.net 2.0Fluroinefx:fluorinefx v1.0.0.15 (click to download)FluorineFX application, published to IIS,
Restore accidentally deleted oracle data files
Recovery Method for accidental deletion of oracle data files on the Linux platform simulates misoperations: the database is running normally and data files are directly rm. -- 1. test Environment: $ cat/
Adding columns with default values to tables in Oracle (including new 12C features)
This is a problem that I have been paying attention.
11G has been improved on this issue, and 12C has some new features.
12C adds the new 11g feature in this
Migrate a single oracle instance to RAC through dataguard
One instance primary to RAC standbyDataGuard Configuration:
Primary
Standby
Clusterware
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit
11g R2
Synonyms (study notes) and synonyms (study notes)Synonym = table alias
Syntax:CREATE [PUBLIC] SYNONYM name FOR database object;
Example 1,
-- Users created by the administrator or users with the permission to CREATE synonyms -- CREATE the synonym
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.