Oracle

Oracle learns restore database and recover database restore only by using backup to restore, recover uses archivelog or online log for example: Suppose I have made A backup at A time point, at the time point, database B goes down to the restore

Oracle Chinese character to PinYin (get full spell/pinyin first letter/pinyin interception, etc.) effect: Oracle Character Set GBK no problem, UTF-8 need to modify the SQL code-oracle Chinese character to PinYin PACKAGE-- 1. Obtain the full spelling

The new feature of Oracle 12c paging query is expected in the upcoming oracle 12c release. This is the optimization of paging query. There are many paging query functions in the application. Previously we used rownum for this purpose.For example, to

The solution to the problem is that the database query time does not have time, minutes, And seconds. In a company project, the dynamic SQL method is used to query the Oracle database. When the Date type field is displayed, only the Date type field

Without installing the oracle client, you can also use plsql to connect to a remote oracle database. Every time you ask someone, can plsql directly connect to the server? They all say they want to install the client, I remember what kind of SQL

Oracle allows you to view the relationships between users, user permissions, user tablespaces, and user default tablespaces. Select username, default_tablespace from dba_users; 1. view table structure: desc table name 2. view the table of the

Oracle spatial Query SQL query all the elements of a certain distance from a certain point (that is, the general query) SQL: www.2cto.com select t. objectid, t. comp_type, t. datatype, t. comp_name, t. health_lic, t. shape. SDO_POINT.X as x, t.

Oracle limits the number of connections of an IP address in database management. It may limit the number of connections from an IP address to the database or the number of connections from a user to the database. To limit the number of connections

Oracle data export txt and import txt ORACLE data export TXT and import from TXT: Export to TXT file: 1. Open the CMD window with PL/SQL DEV. 2. spool d:/output.txt; 3. set heading off; -- remove header 4, select * from usergroup; 5. Import spool

We all know the role of the decode function in Oracle and Cognos Framework Manager. Now, we will introduce how to use the Decode function in the WHERE Condition Statement. Www.2cto.com is easy to understand .. SQL code with tmp as (select 1 val,

When Oracle uses plsql developer to connect, the following error occurs: The Host object name cannot be found. The solution is mostly because the computer name is modified. Www.2cto.com solution: Step 1: sqlnet under the directory C:/oracle/product/1

Pl/SQL 9.2 cannot connect to the oracle database. When oracle 11 GB is installed on the system and oracle 10 Gb is installed on the client, when pl/SQL is used to connect to the database, the connection fails. The reason is that the oracle home

Oracle 10g OEM regular error solving ------- Unknown host specified Oracle Enterprise Manager provides a web-based interface-based tool for managing a single oracle database. Since OEMs use web-based applications, therefore, http is used. When you

Oracle SQL loader uses quick Oracle SQL LOADER, which is an Oracle Data Loading tool used to load data from fixed text files to Oracle databases. It provides the fastest Loading Method (direct/parallel) and is a perfect tool for fast loading of big

Common SQL functions need to pay attention to the details. This is a question that a cool man asked us to think about. To tell the truth, I was so blind at the time. Although the function was clear, but it was not accurate to this level, the

Oracle TYPE OBJECT ========================= recently I learned advanced PL/SQL programming by myself, learn about object type ). Www.2cto.com specifically searched for the 10g official documentation, which is not based on: ==========================

Oracle migration in Different windows systems is an Oracle system running in a Windows operating system environment. Unfortunately, Oracle cannot be used when the Windows System of disk C is reinstalled. What will you do at this time. The most

Database PL/SQL script language function learning notes function build syntax rules: create [or replace] function function_name [(parameter,…)] Return datatype is variable declaration; begin statement ;... [Execption statement;…] The end;

Case when syntax in SQL statements and similar methods in Oracle I. Basic Concepts and examples case when is the syntax of SQL statements, rather than the language www.2cto.com of a specific database I: select num, name, (case classnowhen '1' Class 1

Differences between nocatalog and catalog in RMAN: The nocatalog method uses the control file as the catalog. Each backup must write a lot of backup information into the control file. More and more backup information will appear in the control file,