Oracle

In oracle, the deleted data database is retrieved in a timely manner. select * from whir $ t3068 as of timestamp to_timestamp ('2017-03-30 9:00:00 ', 'yyyy-mm-dd hh24: mi: ss') select * from whir $ t3068 as of timestamp sysdate-750/1440; flashBack

Oracle year, quarter, month, week, day, grouping Java code table 1: Date (exportDate) Quantity (amount) -------------- ----------- 14-2 month-08 20-3 month-08 2 14-4 month-08 6-6 month-08 75 24-10 month-09 23-11 month-09 45 04-8 month-10 5 04-9

Oracle exp/imp Data Backup 1. Oracle11g does not allocate segment to empty tables by default. Therefore, empty tables are not exported when exp is used to export Oracle11g databases. Solution: After the deferred_segment_creation parameter is set to

How to confirm the time zone of 11.2 RAC Grid Infrastructure this document describes how to modify the time zone settings of the GI after installing 11.2 Grid Infrastructure. Once the OS default time zone is modified, make sure that the following

Import data to ORACLE through exp, reported a ORA-00257 error a few days ago to help colleagues installed an ORACLE database server, after loading him with the data exported before the import test, it turns out that the files that only took 7 or 8

Online redefinition tables ORACLE databases support online (off-database) Modification of various physical and logical attributes of a table, including partitions, tablespaces, adding columns, deleting columns, and changing a table to an IOT table.

Environment where sys cannot log on remotely: the database ORACLE 10 Gb is installed on the data Server A (Red Hat Enterprise Linux Server release 5.5 (Tikanga, however, we cannot log on to the database remotely from machine B with the DBA account.

Oracle Database SQL --- one of selectPrefaceI have already explained in the previous article that the best learning is practice! Therefore, my learning is based on practice. In all SQLThe most basic statement is the query statement. Therefore, I

Oracle's PLSQL single-line functions and group functions are a program with zero or multiple parameters and a return value. Oracle has a series of built-in functions in SQL, which can be called SQL or PL/SQL statements. functions are mainly divided

Oracle integrity constraints are used to enhance data integrity. Oracle provides five integrity constraints: Check not null Unique Primary Foreign key integrity constraints are a rule, it does not occupy any database space. Integrity constraints

SQL single row function in Oracle Database --- to_date to_charDate display formatFirst, let's take an example of the date display format ("19:35:35 ")Year:Yy: show two years show 13Yyy: show three years display 013Yyyy: Display four-digit year

RMAN Recovery Window retention policy tipsAssume the following retention policy specified strated in Figure rw01.The retention policy has the following aspects: ■ The recovery window is 7 days.■ Database backups are scheduled every two weeks on

The database of the Oracle 11g virtual column Acme contains a table named SALES, as shown in the preceding figure. The table structure is as follows: SALES_IDNUMBERCUST_IDNUMBERSALES_AMTNUMBER some users want to add a column named SALE_CATEGORY to

PL/SQL usage habits 1. After logging on, the My Objects Tools menu -- Brower Filters will be automatically selected by default. The order window of Brower Filters will be opened and "My Objects" will be set to the default one. 2. when PL/SQL is

A cainiao's oracle path -------- II (continued) case 16 which employees do not receive 400,500,100 yuan in bonuses and are not empty. [SQL] select ename, bonus from emp_xxx where bonus not in () or bonus is null; // when not in is used for

Oracle analysis function RANK ()RANK () is both an aggregate function and an analysis function.The syntax is as follows:Aggregate Function Syntax: Syntax of the analysis function: RANK calculates the level of each value in a group value and returns

Oracle_DAY 01 operation statement SQL> enter the oracle operation environment to query data -- DB -- orders Table External table is the basic unit of data storage in the database. The basic unit of data storage in the table is a row of table

Using ibatis to migrate databases from oracle to mysql. Our project needs to migrate data from oracle to mysql under the company's big strategy. Our project uses ibatis, some modifications required on the ibatis layer are as follows: the unit test

Sqlplus environment configuration (login. SQL) in Oracle, two files can be used to set the SQL * Plus environment: (1) Global setting file: $ ORACLE_HOME/sqlplus/admin/glogin. SQL (2) Personalized setting file: login. SQL, and then the operating

The three configuration files of ORACLE are described in the installation directory $ HOME/network/admin of oracle. ora tnsnames. ora listener. ora files except tnsnames. ora, the detailed usage of the other two files is not well understood by many