Oracle

The database design paradigm is a very important concept, but this important degree is only suitable for reference. Using the database design paradigm, you can make the data table better to save the data, because the reasonable design, if the data

A view is a very important database object in the form of a normal table, and we can query the data from the view.In fact, it is a virtual table built on a table that does not store real data in the view, but simply saves a SELECT statement, and

Java program Operation database, encounter deadlock: java.sql.sqlexception:ora-00060: Deadlock detected while waiting for resourceSteps to resolve:1. Find the Oralce Object (table) for the deadlock:Select object_name,machine,s.sid,s.serial#From

The following error was used today in the Oracle times: ora-28002:the password would expire within 7 days===============================================ERROR:Ora-28002:the password'll expire within 7 days==============================================

Oracle: Turn on monitoring--lsnrctl startOracle: Start/Close Database--sqlplus/nolog--conn/as SYSDBA--startup (Open)--shutdown (OFF)Oracle: Create a table space1. Create a temporary table space--create temporary tablespace XXX (name) tempfile ' xxxx.

Today I restored a copy of the database (there is no invalid object on the server), restored after the local there are more than 30 invalid objects, was very depressed, then I found the database after the restoration of missing tables!At first I

1. StringIt is case-sensitive and should be quoted when used.When specifying aliases, quotation marks can be added or not added.When you have spaces or special characters, you must enclose them in quotation marks.When you do not enclose the

I want to talk to you today about some of the knowledge I learned during this time using Oracle database.I recently came out to work, came to the company is used by the Oracle database, has been using SQL database, in the nature of the former is

1. Oracle is a large database and MySQL is a small and medium-sized database, Oracle has a market share of only about 20% 40%,mysql, while MySQL is open source and Oracle is very expensive.2. Oracle supports high concurrency, large traffic, and is

Configuration of swap on Oracle serverOn Oracle servers, setting the appropriate swap size can improve Oracle's performance, and for Oracle 11g, the physical memory on the Oracle server and the swap size to be set are as follows:If the physical

One, Oracle idle time automatic release connection settings1. Locate the profile file name for the login user, for example, "DEFAULT"2.ALTER profile "DEFAULT" LIMIT Idle_time 240 (min)3, alter system set RESOURCE_LIMIT=TRUE Scope=both;Ii.

Below is a description of the Scheduled cleanup archive log file operation under Oracle.Assumption: The archive log is full and the archive log is emptied as follows.First step: Create a Rman_del.txt file under C driveStep two: Do a batch file named:

as we all know, when too much use of database dialect related applications such as stored procedures, triggers, the portability of the application will become worse, especially in hibernate, it is ironic, but what companies in China today will be

Row to column should be the database is more common operation, in Oracle can use pivot, decode, can refer to the blog of the Melon:http://blog.csdn.net/ch7543658/article/details/41146809SELECT name, Max (DECODE (course, ' Java ', Gread)) as

SummaryThe NHibernate2.1.1 version can finally invoke Oracle's stored procedure, but must use the NHibernate.Driver.OracleDataClientDriver driver (Oracle.DataAccess.dll), but this will cause HBM2DDL.K Eywords throws an exception, so it's not perfect.

1. Insert Data syntax:INSERT into table_name (column1,column2,...) VALUES (Values1,values2,...); When column names are not written, the default is to insert data for each column.2. View the table structure:DESC table_name;3. Query the data in the

Java development process generally use LOG4J to log the program's running logs to the file, in the Oracle stored procedures also need to log, I will work in a log of my own package to share out, in fact, very simple, I hope that we have more

The method for handling the trigger and the concluding remarks during the trigger in a graph of Oracle, And the oracle trigger A trigger in Oracle is a very useful technology. Unlike stored procedures and functions, stored procedures and

Oracle Database language-Structured Query Language SQL, oracle database language I. Data Definition Language DDL 1. Create a tablespace: Creat tablespace lyy DATAFILE 'C:/app/lyy. dbf' SIZE 10 M; (create a 10 m tablespace and store it in the C drive

Oracle strange result survey memo, oracle memo Recently, I need to maintain an ASP. Net program developed more than a decade ago. I encountered various strange problems and recorded the following problems that are hard to find:   Question 1: The