Oracle

from://http://blog.csdn.net/gobitan/article/details/24322561installing Oracle JDK under Ubuntu LinuxDennis Hu 2014-4-22Description:Because many systems do not support the use of OPENJDK, it is necessary to install Oracle JDK under Ubuntu. While the

Environment: Oracle 10g,11gProblem recurrence: Under the Command window in PL/SQL, the time format found by the stored procedure does not meet the expected requirements.Sql> SelectSysdate fromdual; Sysdate----------- the- A- -Executedinch

Oracle SQL Developer is a very powerful open source SQL development tool, the installed Oracle SQL Developer does not support MySQL connection, need to download the JDBC driver formysql from the MySQL official website.Oracle SQL Developer Official

First, the preparatory work 1. Download grid and Oracle. 2, two virtual machines. 3. Assign 7 IP addresses to two virtual machines, which will be explained later in detail. 2 of these are for external access (this article uses 10.1.1.110 and 10.1.1.1

The mode of the HASH joinHash join has three kinds of working modes, namely optimal mode, OnePass mode and Multipass mode, respectively, there are corresponding statistic information in V$sysstat:Sql> select name, value from V$sysstat where name is

Original: C Language connection OracleRecently in the C language connection Oracle, DB2 database, now the C connection to Oracle's article summary:Connect to the Oracle database in C language.There are two ideas and purposesIdea one)Local

1. Establish Oracle Users and groups: #groupadd Oinstall #useradd-G Oinstall Oracle #passwd Oracle 2. Create an Oracle base directory #mkdir –p/usr/local/oracle/product/11.2.0/db_1 #chown –R

The following is a small routine where the Java connection Oracle executes a stored procedure that does not return a value.package com.test;import java.sql.*;p ublic class procedure {     Public static void main (String[] args)  {         Connection 

What is the tracking document used for? The trace file contains a large amount of detailed diagnostic and debugging information. Through the interpretation and analysis of the tracking file, we can locate the problem, analyze the problem and solve

Bulk change the table name to uppercase begin   for C in (select table_name TN from USER_TABLES where TABLE_NAME <> UPPER (table_name)) Lo op       begin          EXECUTE immediate ' ALTER TABLE ' | | c.tn| | ' Rename to ' | | c.tn;       exception 

Transferred from: http://blog.itpub.net/22990797/viewspace-750157/The Oracle documentation uses two methods of expressing syntax, syntax diagrams, and BNF.BNF, Backus-naur Form, Chinese is the Backus paradigm: It is a set of symbols introduced by

First, the normal way to install a new 1. Oracle Installation Environment ReadyUse OEL5.8 x64 installation, installation process, choose Anti-Custom selected GUI, development package, development library, old software development package, etc., must

There are two types of data type conversions for Oracle: Implicit conversions and explicit conversions. Try to use explicit conversions when you use them.Implicit conversions are typically Varchar2 or char conversions to number and date, or vice

Sql> StartupOra-01078:failure in processing system parametersLrm-00109:could not open parameter file '/opt/oracle10g/product/10.2/db_1/dbs/initora10g.ora 'Find the file, and sure enough does not exist. The estimate is caused by an illegal

Starting from August to receive a project, the business logic is not complicated, because there is no previous experience of the C#L connection to Oracle, so the stumbling, and now finally finished. Now comb the way of the experience.The first is

It is important to note that the import and export of different versions of Oracle should conform to the following rules:Either from the low version to the higher version, or to the higher version of the import low version. When exporting, you need

An example of abnormal restart of the oracle database caused by VCS: vcsoracle1. Environment Description Operating system version: SUSE Linux Enterprise Server 10 sp2 (x86_64) Database Version: Oracle 11.1.0.7.16 VCS version: 5.1 Blog:

Oracle query Character Set, Oracle Character Set Select * from nls_database_parameters Forget it. How to view the character set of the Oracle database, detailed operations, xx Database Server Character Set select * from nls_database_parameters,

Oracle tablespace query and maintenance command Book II (undo tablespace)-- Undo tablespace Summary-- View All tablespace namesSelect name from v $ tablespace;-- Create a new UNDO tablespace and set automatic expansion parameters;Create undo

Differences between a transaction-based temporary Oracle table under 11 GB and 12CThe transaction-based temporary tables in Oracle differ from those in 11g and 12C. After collecting statistics on the temporary tables, the former records are cleared,