Oracle

When oracle was first used, toad and PLSQL developer were installed on 64-bit win7. After the installation, the server could not be connected (the connection string is correct ). After searching the Internet for a while, many people found that

@ Echo off @ echo ========================================== =================@ echo in Windows environment, the Oracle database's automatic backup script @ Echo 1. The current date is automatically used to name the backup and export files. @ Echo 2.

This script can be used to identify the character set of the Oracle server in PLSQL and display the local Oracle client characters in the CMD window.The following script can be directly copied to the PLSQL command window to run. If there is a better

SQL statement for querying and deleting duplicate records   1. Search for redundant duplicate records in the Table. duplicate records are determined based on a single field (ID ).   Select * from table where ID in (select ID from Table group

 I,Oracle bieeArchitecture Two major tasks: 1,Explain logical SQL queries and write corresponding physical queries to appropriate data sources; 2, PairPhysical result setProceedTransform and combine and execute final computing. II,Oracle

The following content is transferred from: http://www.cnblogs.com/royenhome/archive/2010/08/02/1790194.html After the installation of active perl5.10 is downloaded from the official website, a simple Perl script is written. Only one file copy

The sys user logs in as a DBA under cmd: Run sqlplus/nolog in cmd. ThenConn/As sysdba Note: 1. If it is enabled in tools such as PL/SQL, directly modify the followingCodeMedium[Italic bold Section]Run 2. Make sure the path exists,For

1.Query all tables under a user Select table_name from all_tables where owner = 'Scott '; query all tables belonging to the Scott user   2.QueryEMPAll fields (columns) in the table) Select * From all_tab_columns where table_name = 'emp ';  

Method 1: Package and procedure First, create a cursor for the returned result set: Create or replace package pkgaccq_tbuserprIsType result is ref cursor;End pkgaccq_tbuserpr; Use the result set defined above to multiply and put the result

Create a file named r5bak. BAT and use NotePad to edit the following content: @ Echo offECHO is backing up the Oracle database. Please wait ......Exp userid = R5/R5 @ orcl file = E:/newbak/DB/R5 _ % Date :~ 0, 4% % Date :~ 5, 2% % Date :~ 8, 2%.

ORA-29861: Domain index is marked loading/failed/unusable Cause: An attempt has been made to access a domain index that is being built or is marked failed by an unsuccessful DDL or is marked unusable by a DDL operation.

Today, I did a database experiment about creating new users and granting them permissions. Below are some of my summary: In the lab, since oracle is installed on each machine, we all enter the system as a DBA. First, we must know some basic

C # Use instantclient to connect to Oracle 10 GB 1. Download instantclient-odbc-win32-10.2.0.3.zip from the oracle.com. 2. decompress the package to the instantclient directory. 32.16double-hit odbc_install.exe 4. Control Panel->

To insert a date/time value into the Oracle table, you'll need to use the to_date function. The to_date function allows you to define the format of the date/time value. For example, we cocould Insert the '3-may-03 21:02:44 'value as follows:

Data library usage rules Terms: Site) Websites already established or to be established by the company, such as the Chinese site (China), the international site (Alibaba), and the Chinese site (China. OLPS Online Process system, an online processing

ArticleDirectory 1.1pl/SQL block type 2.1 scalar Variables 2.2 compound Variables 2.3 reference Variables 2.4 lob variable 3.1 annotations 3.2 PL/SQL coding rules 1. Introduction to PL/SQL Blocks Block is the basis of

1. Common functions Substr FunctionFormula: Select substr ('string', start position, truncation length) from dualExample: Select substr ('teacher',) from dualResult: Tea Lpad/rpad FunctionsFormula: Select lpad ('string', truncation length,

  1. Convert rows into columnsDrop table t_change_lc;Create Table t_change_lc (card_code varchar2 (3), Q number, Bal number ); Insert into t_change_lcSelect '001' card_code, rownum Q, trunc (dbms_random.value * 100) BAL from dual connect by

Address: http://steve-111.iteye.com/blog/750326 A few days ago, I accidentally truncate a table, and the data in the table is very important. In addition, the table data is not backed up, and the data backed up is not the latest. For a moment, I do

Used in Stored Procedures: -- defined in Spec TYPE type_refcursor is ref cursor; -- Write Procedure in the BodyPROCEDURE check_form_field (p_table_name IN VARCHAR2, o_curs OUT type_refcursor)ISBEGINIF p_table_name IS NULLTHENOPEN o_curs'SELECT ''no