Oracle

CREATE OR REPLACE PROCEDURE SCOTT. Html_email (p_to in VARCHAR2,--recipient address P_subject in VARCHAR2,--message subject p_html in VARCHAR2 DEFAULT NULL--message content supports HTML code) is L_boundary VARCHAR2 (255) DEFAULT ' A1B2C3D4E3F2G1 ';

When the Oracle archive log is full, you will not be able to log in to Oracle properly, and you need to delete a subset of the archived logs to log in to Oracle properly.First, delete the archive log physical files, archive logs are generally

1, if you use the table or view of other libraries, be sure to create a view in the current library to achieve cross-library operation, it is best not to use "Databsevv.dbo.table_name", because sp_ Depends cannot display the cross-Library table or

Starting and shutting down Oracle listeners is a fundamental task for DBAs, but Linux system administrators or programmers sometimes need to do some basic DBA work in the development database, so it is important for them to understand some basic

We often encounter situations that require table duplication, such as copying a partial field of a Table1 data into table2, or copying the entire table1 to table2, when we are going to use the SELECT INTO and INSERT into select tables to copy the

Recent projects in addition to a problem, the scenario is probably this, the project was developed abroad, in the project development process using a large number of Oracle function To_date, but the developer did not write a second parameter.So the

Overview:(a) What Oracle calls the User:　　A user is a name, defined in the database, can connect to and Access objects.The Oracle user connects to the database and accesses the database object. (the user is used to connect to the database to access

Oracle Database Expert Combat training courseRecommend a set of 0 Basics video Tutorials to start learning Oracle database expert Combat trainingThe course covers four versions of ORACLE9I/10G/11G/12C.The course is 0 basics, starting with the most

Oracle is the big guy for OLTP, and it's used by many industry applications. So in the process of development of the inevitable use of Oracle database, Oracle database version has a lot of, where the Express version is a free development version,

Oracle Network ConfigurationThree configuration Files Listener.ora, Sqlnet.ora, Tnsnames.ora, are placed in the $oracle_home\network\admin directory.1. Sqlnet.ora-----function similar to Linux or other Unix nsswitch.conf files, this file to

Some excerptsTuring Community: If your children are interested in computer science, what specific direction would you ask them to choose? JL: My children are not interested in computer science at all, not even in science. They majored in

The cause of triggering this error and related factorsis due to the default profile setting "Password_life_time=180 days" in oracle11g, which is in Oracle 11gThere is a password expiration issue.Second, the error phenomenon:ORA-28000 errors are

One: Oracle database notation: 1:select * FROM (select RowNum RN, * from table name where?rownum ? where a.rn>10 2:select * FROM table name where rownum Minus SELECT * FROM table name where rownum ? II: SQL Server database notation: 1:select Top *

The copy command enables the replication of data between different Oracle databases and enables data replication of the same database with the same performance and import/export.According to the 9i document, the Copy command will not be supported in

When SQL statements are executed, the Oracle optimizer determines how tables are accessed based on statistics, and generally, there are two basic ways to access data: 1) Full scan. In a full scan (full-table scan or fast full-index scan), multiple

Review before the study content, to public redo thread and private redo thread of use or is relatively vague, online collection of information is very limited, it seems that some good things do not jumps over is not.Say less nonsense, knowledge

Upgrade oracle11g Database Oracle support cycle   Oracle is also the same for its own products. For its own products in different periods, the support intensity is different.In general, the supported intensity is divided into three levels: Premier

Set plsqldev default format (uppercase keywords, other lower case), plsqldev keywords Plsqldev has always been known to have the Formatting Function. After writing the SQL statement, it is also customary to click a button to format it, but you have

Install 32-bit oracle software in 64-bit linuxIn some cases, sometimes we need to install 32 oracle software on a 64-bit system (for example, the customer's abnormal requirements ). Although theoretically, this method is feasible, but in the actual

Oracle cross-database query replication table data distributed query introduction, oracle Method 1: Currently, most databases require distributed queries. The following describes how to configure cross-database access in oracle.For example, there