Oracle software itself is free, so anyone can download and install Oracle's database software from Oracle's official website, at a charge of license, which is software licensing, and if the database is for commercial use, it is necessary to purchase
PLSQLDownload
PL/SQL developerDownloadVersion 7.1.0.1337
PL/SQL developerIs an integrated development environment for development, testing, debugging, and optimization of Oracle PL/SQL storage.ProgramUnit,
Such as triggers.PL/SQL developerThe
Sample script: using the additions API with no invoices
The following sample script shows how you can use the additions API to test a manual change, when no invoice information is used:
Set serveroutput onDeclare
l_trans_rec syntax;
The database version is 10.2.0.1. When using expdp to export data, Alert Log displays the following information:
Weds Oct 26 12:14:02 2011
The value (30) of maxtrans parameterignored.
Kupprdp: Master process dm00 started withpid = 73, OS id = 473
We know that the flashback table can restore the drop table from the recycle bin, but not everything about the table can be returned by flashback, such as foreign key constraints.
Duzz $ Scott @ orcl> Create Table D (deptno Number Primary Key,
If reproduced, please indicate the source: http://blog.csdn.net/robinson_0612/archive/2010/03/30/5431428.aspxAlthough Oracle 10g Database Release 2 has been released for several years, this version is still a version that many beginners learn. The
L management view
Create View
Use the create view statement to CREATE a VIEW. Each VIEW is materialized by the query of the reference table or defined by other views, just as all the subquery definition views cannot contain the for update clause.
The ORACLE tutorial is: remote automatic backup of Oracle data in the database. In large commercial applications, Remote Disaster Recovery and backup of data are very important and necessary. Based on my practical experience, I have designed a
There are many date functions in oracle, such:
1,Add_months ()Used to increase or decrease the number of months from a date value.
Date_value: = add_months (date_value, number_of_months)
Example:
SQL> select add_months (sysdate, 12) "Next Year"
Database objects include tables, views, sequences, indexes, and synonyms. The tables and views are learned in the previous notes.
Database objects, that is, sequences, indexes, and synonyms.
Sequence: provides regular values. Database objects that
In fact, the actual import and export of Oracle Data imp/exp operations are similar to the actual Oracle data restoration and backup operations. We all know that the exp command can export relevant data from the remote Oracle database server to the
When the Instant Client connects to the oracle database, problems may occur when connecting directly. You must set the environment variables. Let's take a look at how to set the environment variables for the Instant Client to connect to
Guidance:Oracle announced at its U.S. headquarters that,Oracle Database 11 GBInTPC-HA new world record was created in the MB benchmark. This achievement marks another milestone in Oracle Database development and marks the rapid development of Oracle
Oracle handbookSeriesVirtual Private Database VPDThe usage is what we will introduce in this article. VPD, Oracle Virtual Private Database, that is, Oracle Virtual Private Database, refers to the application of some policies, this allows users to
I. Official Website description
1.1 processes
11gR2 documentation:
Property
Description
Parameter type
Integer
Default value
100
Modifiable
No
Range of values
6 to operating system dependent
Basic
Yes
Oracle RAC
Multiple instances can have
For PL/SQL connection, 64-bit Oracle has recently changed to 64-bit Win7, and oracle has also changed to 64-bit 11g. After the change, we found that the plsql cannot load the database at all. There are also various changes to version Shenma on the
One of the Oracle-SQL skills (query continuous records) Requirement Description: www.2cto.com needs to query that a customer has been continuously performing business for those days of a year. The SQL implementation is as follows: Create a table:
Oracle Data Pump tool series: how to reinstall the DataPump EXPDP/IMPDP tool and how to reload the Datapump utility EXPDP/IMPDP this article applies to OracleDatabase-Enterprise Edition-Version 10.1.0.2 to 11.2.0.3 which may need to be reloaded in
In PLSQL Developer, the complete server of Oracle9i is installed on the machine that modifies the Oracle Home setting method, and an Oracle10g client is also installed, in this way, my machine has two Oracle Home instances at the same time. During
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