Oracle

1. Tools: Download Oracle Client Address:Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html such asSelect the corresponding version,Http://www.oracle.com/technetwork/topics/winsoft-085727.html find the corresponding

What does Oracle forget about Sys/system/scott user's password?A. Forget the login password for users other than SYS and system users.Login with SYS (or system) User: CONN Sys/pass_word as SYSDBA;Use the following statement to modify the user's

Recently in Oracle 11G. An issue was found when importing data exports: Oracle does not export empty tables with no data. The data found that this is the case only in Oracle 11g, the process is as follows: Sqlcommand:alter system set

When we upgraded our products from SPC100 to SPC200, we needed to write SQL scripts to complete the database upgrade because the data types of the database table columns changed. The primary key column ID for table t_mobile_indvconfig needs to be

What is a stored procedure?A stored procedure (Procedure) is a set of SQL statements that are compiled to complete a particular function, stored in a database, and executed by specifying the name of the stored procedure and giving parameters.Stored

Use start with a= ' starting ID ' connect by prior a= BA is a subkey and B is the parent.Select F_ca_code,f_ca_parentcode,'0 Query Result:Where level is the Oracle built-in functionIf you join a query, you need to include it in front of start with:

Each table in Oracle has a ROWID, which is a 18-bit character string, for example: Aaangbaabaaao/kaaa. The string it contains consists of a-z,a-z,0-9,+,/of these characters. is 64 binary.Where A-Z corresponds to the 0-25,a-z corresponding to the 26-5

http://blog.csdn.net/lili72Background: For historical reasons, some of the company's business is still being used in Oracle . A problem is a lot of trouble. Due to the long-term use of MySQL and hive,Hbase , etc., some Oracle The order slowly is

The overall structure is divided into three parts: Sga,pga,file fileby function:Storage structureStorage structure Correspondence RelationshipMain documents:Data files: Each data file is associated with only one database A table space

First, the packageA package is a database object that encapsulates the related plsql types, subroutines, cursors, exceptions, variables, and constants. The package contains two parts:1, Package Specification: You can declare types, variables,

An inner join (inner join), an outer join (outer join) has been learned in SQL Server, and an outer join is divided into a left outer join (outer join) andRight outer join (outer join). An outer join between two tables or several tables in Oracle is

A subquery can present a SELECT statement inside a SELECT, UPDATE, DELETE statement. The result of the internal SELECT statement can be used as part of the conditional clause in the outer statement.It can also be used as a temporary table for

How does oracleASM Add a new disk to a disk? Applicable platform: AIX hp linux win Solaris Applicable versions: all databases 10.1.0.2 to12.1.0.1 Applicable to rac and standalone Take the RAC environment as an example: Assume that oracle is an

Oraclelike fuzzy query In some queries, you may not be sure about the exact value to be queried. For example, when Baidu searches, you can enter keywords to query the relevant results. Such queries are called fuzzy queries.Fuzzy search uses the

Ora-00054: resourcebusyandacquirewithnowaitspecified Solution When a database user inserts, updates, or deletes data from a table in a database, or adds a table's primary key, or the table's index, a ora-00054 often occurs: resource busy and acquire

Index (learning notes), index learning notes The tablespace can be omitted. B-Tree Index Reverse Key Index Function Index Bitmap Index Delete Index   B-Tree Index Example 1,Create a table and use the PL/SQL data generator to import 0.1 million

Oracle Performance Optimization Operation 16: Using partition Indexes When you use analysis commands to analyze partition indexes, the range of data values of each partition is stored in the Oracle Data dictionary. Oracle can use this information

Oracle connection Query I have learned inner join and outer join in SQL Server. outer join is divided into left outer join andRight outer join ). In Oracle, the external connection between two or more tables is represented by (+. Code Demo: Check

View (learning notes), view learning notesViewA view is a table exported from one or more entity tables (or views. Unlike an object table, a view itself is a virtual table that does not contain any real data. The database only stores view

Oracle12c cannot access http: // localhost: 1158/em. The em of oracle12c is simplified and much smaller than 11g, and the login method has also changed. The original http: // localhost: 1158/em or https: // localhost: 1158/em login will always