Oracle

--======================== --Differences between processes, sessions, connections --======================== When using Oracle database, connecting to the session is one of the words we often encounter. It looks like one thing, but the fact is

has been used substr () to intercept a part of the string, although know that there are SUBSTRB (), but did not use, also do not understand where to use them, today just test the two functions, do some summary: Let's start by introducing the two

Introduction to the Binding method (Binding Style) in Oracle EBS OAF VO (View Object) Development Wei Hongsheng In the development of oaf Vo, Binding style is primarily used to dynamically transfer values to VO's WHERE clause, which has a total of

When we do not want a job to run, it can be disabled and completed by calling Dbms_job.broken. The syntax for the Dbms_job.broken procedure is: Dbms_job.broken ( Job in Binary_integer, Broken in Boolen, Next_date in date default sysdate)

Unzip the Sqldbx.zip and put the sqldbx into the C: packing directory1.Path inside added: C:\SQLDBXPath is to find Tnsnames.ora.2. Add System variable: oracle_home, Path: C:\SQLDBXOracle_home was trying to find Oci.dll.3. When using sqldbx query, if

1. Environmental conditions1.1 Software Environment and installation methodSoftware Environment: Win7_64bit + Oracle 12c_64bit (12.1.0.2)Installation scenario: Install only database software, single instance database installation1.2 package download

Chr () and ASCII () functions in Oracle (attached: characters commonly used and ASCII table)keywords: chr ()Chr () function action: Special handling of "special" charactersThe corresponding loadline and special characters can be queried in PlsqlChr (

This article is original article, reprint please indicate source: http://write.blog.csdn.net/postedit/42424083This article is based on the Oracle 10.2.0.4 release for the following tests:Rman> list Backup of Archivelog all; omit a lot of the middle,

Oracle the issue of record is locked by another user when modifying records in a table There is no commitwhen manipulating the table, which causes the table to be locked and the row lock can be unlocked as long as the following two lines of

Yesterday I saw a colleague using the PL/SQL developer tool to move text data to Oracle tables, with two texts, one with 300,000 records, and 70,000 records.In the process of import, the error record also needs to click Confirm. But use black

This section explains the cursors in Oracle in detail. The example from this section is from the EMP Table Dept table under the Scott user in Oracle:First, the cursor: 1, Concept: The essence of a cursor is a result set resultset, mainly used to

Disable Oracle Services : Enter Computer Management, in the service, find all services at the beginning of Oracle, right-click to select Stop In the Start menu, locate Universal Installer, run Oracle Universal Installer, click Uninstall product

1.commit_formCommit to the data changes above the form and commit to similar update,insert statements in the code;If there is a conflict between the data changes in the form and the data in the code, then the interface will prevail.2.do_key ('

32-bit version:Http://us-downloads.quest.com/Repository/support.quest.com/Toad for Oracle/12.1/software/toad for Oracle 12.1.msiHttp://us-downloads.quest.com/Repository/support.quest.com/Toad for Oracle/12.1/software/toad DBA Suite for Oracle 12.1

Execute ALTER DATABASE move operation Error ORA-01516:sql> ALTER DATABASE move datafile '/u01/app/oracle/oradata/cdb/pdb/pdb_users01.dbf ' to '/u01/app/pdb_user01.dbf ';ALTER DATABASE move datafile '/u01/app/oracle/oradata/cdb/pdb/pdb_users01.dbf '

In the configuration of DG, there are related to the knowledge of additional logs, so do to organize.The supplemental log is not a separate log, it is a supplemental information to the change vectors in the redo record, which increases the amount of

Source: http://secyaher.blog.163.com/blog/static/389557720092935857930/ How to Write batch processing files to automatically import data to the oracle database Oracle database for automatic import and export has been widely used in many places. for

ORA-02055: distributed update operation failed; rollback required to solve a strange problem recently encountered by colleagues, the following is a great foreign problem reproduction and solution ‑ ORA-02055: distributed update operation failed;

After a database restore, set newname is attempted but the RMAN-06015 is reported. We can manually import the catalog in, in set newname.See the following test cases:-- 1. Pure set newname is acceptableRMAN> run {2> set newname for datafile 6 to '/u0

During his honeymoon in Dongguan today, a student said that the test library he managed had a problem and could not be opened. Let's first look at the problem:Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0Mem