Oracle

Go to: http://database.51cto.com/art/201011/232267.htmSimilar to other database systems, Oracle string connections use the "| |" string concatenation, which is used in the same way as the plus sign "+" in MSSQLServer.For example, execute the

----Database objects: A collection of logical structures----synonyms: Aliases for existing objects/*function:Simplifying SQL statementshide the name and owner of an objectprovides public access to an objectCategory: */--public synonym: can be

It's really unfamiliar with Oracle's various errors, documenting the final troubleshooting record of a long-troubled problem.First, the symptom description:Plsql Unable to connect to the database, prompting: "Ora-12154:tns: Unable to resolve the

Oracle stored procedure Returns a result set that requires a cursor as a stored procedure parameter1. Create PakageCREATE OR REPLACE Package pkg_query as TYPE cur_query is REF CURSOR; END Pkg_query;2. Create a stored procedure ()Create or Replace

Set the JDK environment variable, and the command line uses java-versionUse the service tomcat-web1 Start command to report the following errorNeither the Java_home nor the JRE_HOME environment variable is defined. At least one of these environment

Rman Backup times the following error:RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE, STACK follows ===============RMAN-00571: =========================================================

Actually find this article my main use of SQL is this sentence select * from User_cons_columns t where t.constraint_name like ' FK_CTS_CONT_REINS__CRR '; Cause: System testing when it is found that if a record has been quoted, this time to delete

Here are the steps and methods for Oracle batch script file execution1. Create script file (xx.sql):For example, file createtableCreate table tb1 (ID varchar2 (), Name varchar2 (50)); commit;/You can create multiple, but note that you want to end

I'm using a lite version of Oracle.1 Importing an Oracle driver packageOracle Down PathD:\oracle\app\oracle\product\11.2.0\server\jdbc\lib\ojdbc6.jar2 views ListenerduankouhaoD:\oracle\app\oracle\product\11.2.0\server\network\ADMIN\listener.ora3

in a query statement, an error often occurs:SQL Foundation: ORA-00918: Error with column not explicitly defined. There are two kinds of situations currently encountered. The reason is: when the query statement, the query table (dataset) has the same

1. Table data replication between different users2. Data replication with user tables3.transfer individual fields in b.x to the same field in B.y4.only duplicate table structure joins a condition 1=2 that can never be set up, then it represents only

Let's take a look at what jumbo frames is.We know that in the TCP/IP covariance cluster, the Ethernet Data Link layer communicates in frames (frame), the size of 1 frames is set to 1,518 bytes, the MTU of the traditional 10M nic frame (Maximum

First, create, delete databaseOracle oradb11g_home-> Configuration and porting tools->database configration Assistant-> You can then create or delete the databaseIi. establishing a table spaceCreate Tablespace inspur_tablespaceLoggingDataFile '

Statement block definition: SQL code Decalre --Variable declaration VAR1 number (2); --declaration only Var2 char (2): = ' 11 '; --Initialize at the same time as the declaration Begin --Statement End

In the actual IT project management, the management of the database is particularly important, in general, the management of the database will have the DBA staff in the company to be responsible. But what if you don't have to contact the DBA about

A data table is basically difficult to meet our query requirements, at the same time, all the data are saved in a table is obviously not a good database design, in order to avoid data redundancy, delete, update the exception, we usually need to

In order to handle the information obtained by the SQL statements, Oracle must allocate a region called the context to handle the above information. A cursor is a handle or pointer to a context, and PL/SQL can control the information that is

The failure of the head verification is due to the different version number, the experiment can be modified by the following methods: Open the DMP file with the notepad++ tool, you can see the header information--texport: V11.01.00, which is the

ORACLE section 4th Objective:  ? Use the equi and non-equi join to query data in multiple tables in the SELECT statement. ? Use self-connection. Use external connection to query data that does not meet the connection conditions   Oracle

Oracle creates a database in three steps and oracle creates a database in three steps In the past, mysql and SQL server were mostly used during development, while oracle was rarely used and unfamiliar. mysql and SQL server were used in a similar way,