Oracle

We've talked about the construction of Oracle 11G Dataguard in the front, and the 10G build is similar. However, Oracle 10G does not support standby openEnvironment: Role Host Name Ip Database version Operating

1. using thin ConnectionPros:The thin driver is pure Java code and uses TCP/IP technology to connect to the Oracle database through the socket of Java, so the thin drive is platform independent and requires no Oracle client installation. You only

Objective: Why do you want to learn a database? 1.1 Concept of the databaseA database is a warehouse that organizes, stores, and manages data in accordance with its data structure.The database, in a nutshell, is an electronic file

naming Conventions for table and column names :Must start with a letterMust be between 1-30 characterscan only contain a-z,a-z,0-9,_,$,#Cannot duplicate user-defined other objectsCannot use Oracle's reserved wordsPre-created conditions:CREATE Table

1. Stored Procedures1.1. Prepare SQL--  Defining stored Procedure Create or replace procedure get_rax (salary in number,rax out  number) as    --need to pay taxes     bal number;begin     bal := salary - 3500;    if bal1.2. Preparing the JAR Package

　　It is important to understand the architecture of a technology, especially one that is so complex as the knowledge system of Oracle database. At the same time, personally, it is not necessarily a professional DBA personnel need to understand its

Create a tableSql>create Table Classes (ClassId Number (2),CNAME varchar2 (+) ,Birthday Date);Add a fieldsql>alter Table Student Add (classId number (2));Modify field lengthSql>alter Table Student Modify (XM VARCHAR2 (30));Modify the type of the

This article refers to the articlehttp://blog.csdn.net/zonej/article/details/50680857http://blog.csdn.net/tongzidane/article/details/43852705Http://www.cnblogs.com/sopost/archive/2012/07/19/2598981.htmlThe maintenance of copyright starts with me.Pre-

1.%type allows users to dynamically associate the data type of a column in a database with a variable in PL/SQL. The syntax is as follows: Variable_name Table.column%type 2.%rowtype allows a user to define a single variable that contains

1. Introduction to Oracle1977 American Larry set up a software development lab1980 developed the world's first business relational database (RDBMS)1983 the company was renamed Oracle Corporation (Oracle Corporation)Over more than 30 years of

Oracle's wait events are an important basis for measuring Oracle health and metrics. The concept of wait events was introduced in Oracle7.0.1.2, with roughly 100 waiting events. This number is increased to approximately 150 in Oracle 8.0, with

1. Create a table in the target database1.1 Click the source table to copy the creation statement1.2 Modify the data type to match the target database, such as:String type: Character varying (20) >>>varchar2Number type: Numeric (19,2) >>>number (19,2

This article mainly describes the Oracle table add field, delete table fields to modify the use of table, please refer to the use of itSyntax for adding a field: ALTER TABLE tablename Add (column datatype [default value][null/not null],....);Modify

How to connect MySQL, Oracle, SQL Server database JDBC mysql:                  add a MySQL jar package first                   String url= "jdbc:mysql://localhost:3306/database name";       //Database address                  String name= "root";    

Audit files: Record suspicious operations in the database; SYS's connection and database start-up, stop is bound to be audited!Location of audit Files:Show Parameter Audit_file_destIf the audit directory does not exist, the database will not start

Sql server1. Determine whether the table users existif object_id(N'Users'N'U') is not NULL Print 'exist'Else Print 'does not exist' 2. Determine if the Name column exists in the table usersif exists(Select *

1:oracle's ServicesOracleservice + SID # database service Oracleoradb10g_home1listener # Database listener service.2: Start the native database:Start Oracleservice + SID: Database serviceLog in to Oracle using the

HTTP://BLOG.ITPUB.NET/22664653/VIEWSPACE-722463/: The log system in an Oracle RAC environment is more complex than a single system: see: A brief introduction to the log architecture in the Oracle cluster environment, In the case of problems, you can

Today suddenly found that the Tnslistener service can not start, after the service console to start, refresh, and automatically return to the stop state, there is no error reported. And the SPL plus can be used normally.From Baidu found a similar

Oracle SQL Tuning and CBO internals:based Optimizer with CBO internals and SQL Tuning