Oracle

To view the relationship between a user and a default table spaceSelect Username,default_tablespace from Dba_users;--View the tables that the current user can accessSELECT * from User_tables;--oracle Querying user tablesSELECT * from User_all_tables;

Project is urgent, need to deliver results in a short time, new team members, the database design is too low, it is difficult to understand the relationship between the database table structure, in order to enable new colleagues to better understand

Environment:mssql:2008ORACLE db:10.2.0.1no previous contact with MSSQL, recently due to the need for MSSQL access to the table in Oracle, the following is the configuration of the MSSQL connection Oracle.1. Install the Oracle client on the MSSQL

I. Related content1. Understand the concept, role, and type of triggers.2. Practice the creation and use of triggers.Second, the specific operationExperimental1. Use triggers to perform a security check on DML operations performed on the Scott.emp

There is a need to back up the data from the production library to the backup machine at 23 o'clock every night, the database of the backup machine can be used directly the next day, the data is the data of the production library yesterday.

http://jingyan.baidu.com/article/363872eccfb9266e4aa16f5d.htmlMethod/Step 1You can according to their operating system is how many bits (32-bit or 64-bit), to the official website to download the appropriate installation program, as shown in.One

"Cause/Trigger factor"This is due to the fact that "password_life_time=180 days" is set in the default profile in oracle11g."Impact and risk"EffectAfter the password expires, the business process connects to the database exception, affecting

Problem Description:Customer side of the front-end application of an operation hang, no error and no operation of the normal ending prompt.View the lock information as follows:Sql> with LK as (select Blocking_instance| | '. ' | | blocking_session

Recently, the company is doing Oracle database related products, here to summarize:ISNULL () functionGrammarISNULL (Check_expression, Replacement_value)ParametersCheck_expressionAn expression that will be checked for null. Check_expression can be of

We have an error in the Recover database times:Rman-06054:media recovery requesting unknown archived log for thread 1 with sequence 149 and starting SCN of 3507749here is a reminder to revert to an unknown SCN number.  we have only 148th in the

This article describes Oracle Analytic function usage, first building the library:SQL code CREATE TABLE earnings --working Money table ( Earnmonth VARCHAR2 (6), --Working month Area VARCHAR2 (a), --working areas Sno Varchar2 (Ten),

The Oracle Data Guard Logic Repository is a backup of the main library, which first establishes a physical standby and then converts it to a logical standby library. After this, the main library passes the log to the standby repository, which uses

I. Cursor action (or definition)1.pl/sql provides a cursor mechanism for processing multi-row record result sets; 2. A cursor is similar to a pointer, so that the application can process one row of records at a time , such as placing a cursor in a

1.pl/sql Developer 9 Check whether the client character set is consistent with the serverPreferences, options, check whether the client and server character sets matchChanges to 2.Windows environment variables take effect immediately3.ODAC12 change

With the popularization of computers and the development of the network, the database is no longer just the topic of the programmer. Oracle database is based on its excellent performance, easy to operate and flexible features, in the database market

Syntax for adding a field: ALTER TABLE tablename Add (column datatype [default value][null/not null],....);Modify the syntax of the field: ALTER TABLE tablename modify (column datatype [default value][null/not null],....);Syntax for deleting a field:

Insert operation: 1. Copy the table structure without adding data: --Copy table structure without inserting data create TABLE Emp_new as SELECT * from emp where 1 = 2;select * from emp_new; 2. With CHECK option, the mating view

Synchronizing some tables in SQLServer2005 to the Oracle database, data synchronization between different database types can be achieved using linked servers and SQLAgent.Instance:SQLServer2008 There is a table employ_epl that needs to be

1. Disk partition, set up 13 partitions, corresponding ORACLE13 files respectivelyFdisk/dev/sdc2. Edit the 60.raw,rules file#vi/etc/udev/rules.d/60-raw.rulesaction== "Add", kernel== "SDC1", run+= "/bin/raw/dev/raw/raw1%N"action== "Add", kernel==

Fuzzy queries are frequently used in database queries, and are commonly used in the following formats:(1) field like '% keyword% ' field contains ' keyword ' records even if the target field is indexed and not indexed, the slowest(2) field like '