Oracle

1. View the database instance basic information:Sql> SELECTdbid,name,created,log_mode,open_mode,force_logging,current_scn,flashback_on fromv$DATABASE;D bid NAME CREATED log_mode open_mode force_logging current_scn flashback_on---------- --------- ---

To understand the occurrence of row-level locks through experiments1. Create the required tablesSql> Conn/as SYSDBAis connected.Sql> CREATE TABLE Dept as select * from Scott.dept;The table is created.Sql> CREATE TABLE EMP as SELECT * from

Original: How to create a new Oracle databaseThree ways to create a new Oracle database:1. Create a configuration or delete a database by running the Oracle database configuration Assistant (you can also enter DBCA at the command line);2. Create a

Original: Installation and configuration of Oracle 11g client.The database and the client are on different machines.Before installing, navigate to the following directory on the server where the Oracle database is installed.Change localhost in

SELECT(--SELECT REPLACE (sbpt. parkstime| | ' ~ ' | | Sbpt. Parketime, ', ') replace can also SELECTWm_concat (sbpt. Parkstime||'~'||sbpt. Parketime) Saree fromSys_berthandtype SBT Left JOINsys_berthtypeparktime sbpt onSBT. Berthtypeid=Sbpt.

In the Oracle relational database, let's take a look at the following question:A transaction: Select from T where ID > Ten and ID B Transaction: Update T Set id = 45000 WHERE id = 4501Two transactions are performed in the following order:A

For Oracle stored procedures, throwing exceptions can be thrown into code or logged with a table. If your system application has a lot of nodes, like 40 of our nodes, if the wrong throw into the code, the error can not be found at all, it is best to

In an Oracle database, you can merge fields using the Wm_concat (column) function The Oracle Wm_concat (column) function allows us to use it frequently, and below teaches you how to use the Oracle Wm_concat (column) function to implement a field

Yesterday at the time of the test, it was found that a program written by a developer in the development library is good, but in the test library there will be a problem. Developers have been unable to find the cause of the problem. So it took some

Original: Decode in OracleThe Decode function is equivalent to a conditional statement (IF). It compares the input value to the parameter list in the function and returns a corresponding value based on the input value. The parameter list of a

Basic syntax:select where start with connect by ;: Filter condition for filtering all records returned. : The limit of the root node at which the query results are re-started. : Connection conditions The data table is structured as follows:CREATE

Original: Oracle Common view table Structure commandGet table: Select table_name from User_tables; The current user's tableSelect table_name from All_tables; All users ' tablesSelect table_name from Dba_tables; including system tablesSelect

Planning: ip:192.168.213.199 mask:255.255.255.0 gateway:192.168.213.1 dns1:202.101.172.35 Disk Partitioning: Total disk Size: 25G /U01 5*1024 5120M Database software partition is at least greater than 5G /oradata 12*1024 12288M Database file

A deep understanding of oracle transaction isolationIn Oracle relational database, let's look at the following question:A transaction: select from T where id> 10 and id Transaction B: update T set id = 45000 where id = 4501The two transactions are

Hibernate and hibernate Level 1 Cache Hibernate cache is divided into three levels: Level-1 cache: the transaction-level (memory)-based Cache can also be session-level cache. Level-2 Cache: It depends on a third party. When requesting an object,

Some query statements in Oracle and their execution sequenceQuery condition:1) LIKE: fuzzy query. Two Wildcards are required. %: represents 0 to multiple characters; _: identifies a single character.2) IN (list): used to retrieve data that matches

Oracle inserts timestamp data Table Structure: create table TEST( ID INTEGER, BIRTHDAY TIMESTAMP);Insert a date to a TIMESTAMP field using JDBC   Import java. SQL. connection; import java. SQL. driverManager; import java. SQL.

Oracle Stored Procedure record exception For Oracle stored procedures, an exception can be thrown to the code or recorded in a table. If your system application has many nodes, such as our 40 nodes, if an error is thrown into the code, the error

Oracle 11g histogram row-to-Column I have written a line-to-column article: Oracle simple column-to-row SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise

Oracle11g bytes row-to-column Conversion I have written a line-to-column article: Oracle simple column-to-row SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g