Oracle

Open powerdesigner-> menu bar "Database"-> database reverse engineering-> using an ODBC data source, select Browse-> connect to an ODBC Data Source-> machine data source select the data source you configured. (Note: If you need to configure the data

To simplify the SQL statement, you can divide the statement into several views for operation, but the created attempt will be saved as an object in the database. However, some statements are often used only temporarily, so there is a with as

Open the ACCESS database, select a table, change the table name to uppercase letters, and select the storage type as follows: ODBC database (). Next, if you have not created a DNS, you can create a new one. As prompted, creating an oracle DNS will

There are several methods for. Net to connect to the Oracle database. The oledb method, the Oracle component provided by MS, And the Oracle component provided by the Oracle company are used. The second and third methods both download and install the

This article describes how to handle system and SYS password in Oracle. One is OS verification and the other is password file verification. OracleTwo authentication methods are provided. One is OS authentication and the other is password file

// Create global temporary table temp_20061030 (ID int, name varchar2 (256) on commit Delete rows; Export ledboperation DBO = NULL; // export ledboperation is a custom class encapsulated for Oracle operations. You can use the operation classes and

Create or replace procedure tablepage_select (v_page_size int, -- the size of a page of listV_current_page int, -- the current page of listV_table_name varchar2, -- the talbe nameV_order_field varchar2, -- the order FieldV_order_sequence varchar2, --

Iii. SQL Optimization Database optimization is mainly performed by DBA, and the optimization is divided into many steps. Based on experience, the first thing to adjust is Program A bad SQL statement written by a member can cause the entire Oracle

To do well, you must first sharpen your tools. Oracle itself has some auxiliary client tools, but they are not very easy to use. However, real DBAs like to use command line methods to operate databases. We are not DBAs, we are Program Personnel, so

Blob refers to the writing of a binary large object, that is, an English Binary large object;Clob refers to a large character object, that is, written by the English character large object.Therefore, these two types are designed to store a large

Note: The following operating environments are available in centos 6.4 + Oracle 11gr2 (Oracle is installed in oracle_base =/opt/Oracle, and ORACLE_HOME =/opt/Oracle/11g) After installing and configuring the Oracle database with oui, Oracle is

In the afternoon, a table structure is exported from the production database to test some problems. Because the production database is connected to tables of other users, the view is simulated locally, so a view is created: Create Or Replace

The configuration file was copied from the nhib.pdf release package and the simple connection character was modified. The configuration file is as follows: Code XML version = "1.0" encoding = "UTF-8" ?> This template was written

Set database startup instance Use operating system authentication to log on Rebuilding Scott user environment Switch to database DBA Specify a separate tablespace for Scott. C: \ Documents ents andSettings \ Administrator>Set oracle_sid =

Method 1 Step 1: log on to SQL/plus to execute the command (no sequence is available) Set Time on; (Note: Enable time display) Set autotrace on; (Description: Enable Automatic Analysis Statistics and display the running results of SQL statements)

In the Oracle PL-SQL, left and right connections are implemented as follows View the following statements: This SQL statement uses the right connection, that is, the other side of the "(+)" is the connection direction. All records on the right

Early in the morning, someone in the group yelled at Oracle to buy sun. Haha, the change was too fast and did not respond. Fortunately, today is not because of the attitude of yu'e to check and view Google... The first reaction was that IBM would

  V_count INT: = 0; V_num INT: = 0;   1: The tbl_mytable table must have a continuous and unique column FID.   Begin Select count (*) Into v_count From tbl_mytable;   Select trunc (dbms_radom.value (1, v_count + 1) into v_num

Http://blog.csdn.net/lanpy88/article/details/7580691 method: Export using PL/SQL developer : Menu bar ----> Tools ----> Export tables, for example, set the relevant parameters: Method 2: Export using cmd commands : 1: There is a tnsname. ora file

Create or replace type tb_strSplit as table of varchar2 (4000 ); Create or replace function to_table (pv_str varchar2, pv_split varchar2) return tb_strSplitAsLtab tb_strSplit: = tb_strSplit ();Pos integer: = 0;Ls varchar2 (4000): = pv_str;BeginPos: =