Oracle

  Book DescriptionPro Oracle SQLUnlocks the power of SQL in the Oracle database-one of the most potent SQL implementations on the market today. to master it requires a three-pronged approach: learn the language features, learn the supporting

 For a long time, I have been using ms SQL Server/Access database, through. Net Access Ms home things almost never encountered any trouble. Recently, I used oracle as a database in my project. I learned some things about. Net accessing Oracle and

After Oracle 10 Gb is installed, a table is created to write Chinese data. It is found that the PL/SQL developer tool cannot display Chinese normally. To display Chinese characters properly, the server must be consistent with the client encoding.

This article mainly introduces the differences between Oracle versions. From Oracle database-related products, from oracle2.0 (no 1.0) to oracle7.3.4, it is a relatively simple version of Oracle, starting with oracle8, the identifier of a database

We usually use 32-bit machines for development and install 32-bit software, but our servers are generally 64-bit, so sometimes a VS debugging program needs to be installed in a 64-bit environment. Recently, a problem occurs when a colleague changes

The ORACLE tutorial is: A Brief Discussion on the Oracle database set replication method. Preface The increasing demand for distributed applications requires a better distributed software environment, which constantly promotes the development of

How to reset the password of oracle 10g SYS After installing oracle 10 Gb, the system password set during installation is forgotten. Solve the problem with the help of a colleague. 1. The oracle password file exists in: oracle_home/database/pwd .

The ORACLE tutorial is: Oracle Database and application optimization Developer Network Oracle. Introduction: work in detail. The difference between a master and a cainiao is that the master knows everything and the cainiao knows something. Computer

In many cases, our servers may experience performance problems with CPU consumption of 100%.Exclude system exceptions. These problems are usually caused by low performance or even incorrect SQL statements in the system, which consume a large amount

SQL where 1 = 1 and 0 = 1Where 1 = 1; this condition is always True. In the case of an indefinite number of query conditions, 1 = 1 can be a convenient standard statement.I. You do not need to worry about the problem where 1 = 1 in Multi-condition

Oracle PL/SQL non-predefined exceptions, custom exception handling, RAISE_APPLICATION_ERROR throwing exceptions Oracle has three types of exception errors: 1. there are about 24 Predefined ORACLE exceptions. To handle this exception, you do not need

Oracle Database Programming: Change Data and management items in PL/SQL change data and manage items in PL/SQL: returning clause of DML statements: to obtain the information after the insert, update, and delete statements are executed, you can add

In Oracle, the Decode () function is a powerful function in oracle pl/SQL. Currently, only oracle SQL provides this function, this function is not available for SQL implementations of other database vendors. The DECODE function is one of the

Performance Comparison of dynamic SQL, bind variables, and static SQL 1 the three stored procedures in the test example use three programming methods: dynamic SQL, bind variable, and static SQL. The specific content of the stored procedure is as

Rman Based on Time Incomplete recovery SQL> select sysdate from dual; SYSDATE-------------------2013-07-31 22:36:51 run {SQL 'alter session nls_date_format = "yyyy-mm-dd hh24: mi: ss "'set until time' 2013-07-31 22:45:51 'restore database; recover

Ora-28056 (Writing audit records to Windows Event Log failed) addressed ORA-28056 systems: windows XP Oracle version SQL> select * from v $ version; BANNER implements Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-ProductionPL/SQL Release

1: When performing multi-table join, use the Where statement to minimize the result set of a single table. Use the aggregate function to summarize the result set and associate it with other tables to minimize the data volume of the result set.2:

Copy codeThe Code is as follows:Create or replace procedure procsendemail (P_TXT VARCHAR2,P_SUB VARCHAR2,P_SENDOR VARCHAR2,P_RECEIVER VARCHAR2,P_SERVER VARCHAR2,P_PORT number default 25,P_NEED_SMTP int default 0,P_USER VARCHAR2 default null,P_PASS

Please pay attention to the abuse of 1and and where. The effect of the three paragraphs below must be different.(1)Copy codeThe Code is as follows:SelectA. a1, B. b3FromAleftjoinBOnA. a2 = B. b2WhereA. a3 = 1AndB. b3 = 2 First join left and then

1. Basic Concepts Two features: complete the constraints of complex business rules that are difficult to complete due to database integrity constraints; monitor various database operations to implement audit functions.Triggers are divided into: DML