Oracle

When the PL SQL is installed, the database at the following figure is empty. You need to install a 32-bit client, stating that PL SQL does not support 64-bit client connections. Solution: 1. Download the 32-bit Oracle client and install 2, set

After installing the virtual machine VM VirtualBox, you can start to install the operating system on the virtual machine, such as Windows Xp,windows VISTA/7/8 or Mac OS, Liunix, UNIX and other operating systems. The following shows the virtual

 Srvctl is a tool for Oracle RAC Cluster configuration management. This article is a reference document detailing all the commands for Srvctl. 　　 SRVCTL ADD 　　 Add configuration information for a database or instance. In the Add instance, the

1.TRUNC (for dates) The date value that the Trunc function truncates for the specified element. Its specific syntax format is as follows: TRUNC (Date[,fmt]) which Date value FMT the date format, which is truncated by the specified element format.

Oracle many friends ask genuine Oracle database products and pirated products what is the difference, in fact, from the product technology itself, the difference is not small, you can download a database from the OTN website products, and then

Oracle's technology for implementing heterogeneous database connection Services is called transparent Gateway (transparent gateway). At present, Oracle utilizes transparent gateway to realize the interconnection with SQL SERVER, SYBASE, DB2 and

Unzip the downloaded zip file first and run the Setup.exe file.First step: Select Administrator (0MB) (A), then click NextStep Two: Select the language and click NextStep three: Select the path to install and click NextFourth step: After the fourth

Scheduler (Dispatch) was introduced in the Oracle 11g release to replace the previous version of the Job (Task). Here is a brief introduction to the meaning and use of the Repeat_interval parameter in scheduler.Repeat_interval literally means

Environment: DB version Oracle database 12c Enterprise Edition release 12.2.0.1.0-64bit ProductionExperiment Preparation:1.--Database Archiving modeSql> select Name,log_mode from V$database;NAME Log_mode--------- ------------ANDYCDB ARCHIVELOG >

Differences between Classes12.jar,ojdbc14.jar,ojdbc5.jar and Ojdbc6.jar, the difference betweenZhao LeiBlog: http://elf8848.iteye.comSource: http://elf8848.iteye.com/blog/811037When using the Oracle JDBC driver, are there some problems that you can

Today, using Navicat to connect to the Oracle database, the following error was reported: "ORA-12737 Instant Client light:unsupported server character Set ZHS16GBK"From this error, it can be known that the client does not support the server-side

After getting to much requests for a free Oracle Forms and Reports project for students, I am sharing a project with SOURC e Code (Oracle forms Example application), which I developed in around for Oracle Forms 4.5, but can download it a nd can use

You can use the Loop statement to loop through the data in PL/SQL, which allows you to loop through the specified sequence of statements. The common Loop Loop statement consists of 3 types: basic loop, while ... Loop and for ... LOOP.The basic

Oracle Video tutorial goals Oracle video tutorial, wind Brother this set of Oracle Tutorial Training learning Oracle Sql*loader Concepts and usage and sql* Loader two cases, while the courseware with nearly 20 cases for everyone to practice their

　　I. Oracle related statistical functions for IO informationThe Oracle I/O stack contains HBAs, which stores the relevant switches and stores the physical disks. Then Oracle recommends validating I/O to avoid problems when deploying applications.

http://blog.csdn.net/redarmy_chen/article/details/7351410Oracle Two time subtraction default is the number of daysOracle two time subtraction The default is the number of days *24 is the difference between the hoursOracle two time subtraction The

As Microsoft's. NET Framework becomes increasingly popular, many developers are eager to learn about applying. net Program The best way to integrate with Oracle-not only in terms of basic connectivity, but also in relation to effective application

Transferred from: bytes. When creating an Oracle database, you should see this option in the database creation assistant wizard, which is the connection mode of the database. In Oracle9i or 10g, we can see two connection modes, one is

    When the database of Oracle 10.2.0.1 is installed on Redhat 5.4, the result remains stuck at 51%: CP: cannot stat '/discard/': no such fileor directory   However, it will be skipped after a period of time. In short, the link process was very

    When you use the DataPump tool in the RAC environment, Alert Log prompts you to modify the service_names parameter.   For example:     Sat Sep 13:33:20 2012 Alter system setservice_names = 'pmos ', 'sys $ sys. kupc $ c_1_20901133317.pmos' scope =