Oracle

SelectFu.user_name User Name,Fu.description User Description,Frv. Responsibility_name Responsibility Name,Request_group_name Report Group,(select PPF. Full_nameFrom Apps.per_people_f PPFwhere fu.employee_id = PPF. person_idand Trunc (sysdate)

1.1. ORA-01722Date: 2014-06-05 14:09Environment: Test environment"Scenario description"During the upgrade of the database, the execution of the Sql> @?/rdbms/admin/catupgrd.sql script encountered an error exiting."Error Message"doc>##################

Oracle Database Performance Optimization general rule:One, reduce data access (reduce the number of drive room visits)Second, return less data (reduce network transmission or disk access)Third, reduce the number of interactions (reduce network

First, the concept1. Databases (database)What is a database?A database is organized according to a data model and holds data sets in Level two memory.This collection of data has the following characteristics:As little as possible, the best way to

If you don't see the diagram, you can visit this page. Http://note.youdao.com/share/?id=82c1b694241ecc15eee9348e767756c7&type=notefor occasional Tomcat pages when accessing an Oracle EBS system, Oracle technical support suspects that the OS was

Oracle the user security management mainly has permissions and RolesWhen a user is just established, the user does not have any permissions and cannot perform any action. If you want to perform a specific database operation, you must grant it

The Clob field stores text, and if the store is less than 4,000 bytes, the Clob field is stored with the record, and if the store is more than 4,000 bytes, it is not stored with the record. It is worth noting that the 4,000 bytes here are not

Package Com.org.beimei;import Java.sql.connection;import Java.sql.drivermanager;import java.sql.PreparedStatement; Import Java.sql.resultset;import java.sql.sqlexception;import Java.util.arraylist;import Java.util.Iterator;import

1>oracle JDeveloper official address, the official learning resources include videos and textbooks, very comprehensive, many do not know from and start.2>oracle JDeveloper 12C Tutorial, Step-by-step learning Jdev, you can use this tutorial as a

See online there is such an introduction and a lot, but I think it is the great God can see all of a sudden understand. I summarize the next rookie can read.1. Export.First step:Operating system-Start-run input "cmd" into the DOS interface input

Unconditional insertionInsert all in Oracle refers to inserting the same batch of data into different tables, if there is one requirement: Insert the data from the T table into T1,t2, and if you do not know the insert all, you may insert 2 times

The tradeoff between performance and securityFor database tuning, there is no absolute performance or absolute security. Just as the fish and the cake can not be the same, it is not fully balanced, like the spear and the shield to eliminate the

Tag: ora-01081: "Cannot start already-running Oracle-shut it down first" applies to: oracle server - enterprise edition - version: 8.1.7.4  to 11.2.0.2.0 - Release: 8.1.7 to 11.2Generic  UNIX when checking for Oracle instance background process

 The PL/SQL programming language is the fastest operating database language in Oracle, and the stored procedure is essentially PL/SQL, so it is most effective to crud the database through stored procedures.JDBC is no longer used for CRUD

Do not write INSERT statements, because there are too many database fields, what is the simple point of the efficient method?Public void Multiinsertdata (DataSet ds){string connt = "Connection string for Oracle";String sql = "Select Id,name,... from

　　　　transaction_read_uncommitted 1This isolation level is the lowest, dirty read, non-repeatable read, Phantom read will occur, I use the Oracle, and does not support this level, do not do research.　　transaction_read_committed 2　　This is the default

The syntax of Merge is as follows: MERGE [hint] INTO [schema .] table [t_alias] USING [schema .] { table | view | subquery } [t_alias] ON ( condition ) WHEN MATCHED THEN merge_update_clause WHEN NOT MATCHED THEN merge_insert_clause;What is MERGE and

Recently, I have been studying Oracle PLSQL's series of XML operations. Combine the knowledge and references used in the work to sort out the following content: 1. How to generate an XML file:1. Use dbms_xmlquery and utl_file built-in packages

I. Overview: 1. The pipeline function is a function that can return a set of rows (nested table or array varray can be used). We can query it like a physical table or Assign a value to the set variable. 2. Pipeline functions are executed in parallel.

The previous blog introduced how to use the Navicat tool to back up Oracle. This blog introduced how to use the PL/SQL Developer tool to import and export Oracle databases. PL/SQL Developer is one of the main tools used by Oracle databases to import