Oracle

From:http://soft.doit.com.cn/article/2012/0105/2850851.shtml --Addition --plus 1 yearsSELECT sysdate,add_months (sysdate,12) from DUAL;--Add JanuarySELECT sysdate,add_months (sysdate,1) from DUAL;--plus 1 weeksSELECT Sysdate,to_char (sysdate+7, '

One, sys users and system usersThe Oracle installation automatically generates SYS users and system users(1), sys user is superuser, has the highest privileges, has the SYSDBA role, has the rights to create database, the user's default password is

Oracle's Best Flexible architecture (Optimal flexible Architecture, referred to as OFA) refers to the naming conventions and storage location rules for Oracle software and database files and folders. It can be used as a good set of habits, which

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),

1. Switch archive, perform rman full library backup2. On the transmitting server.3. Restore it--create a corresponding directory1. Modify the configuration file, proportionally modify the configuration parametersCreate a corresponding directory

That day to share the download and installation of Oracle process, the need for friends can learn from reference. It would be appreciated if there were any similarities!You can first download Oracle's latest version of Oracle database to Oracle's

For the use of case, the simple case function is a simple case expression that uses an expression to determine the return value.Grammar:Case Search_expressionWhen Expression1 then RESULT1When Expression2 then RESULT2...When Expressionn then

CREATE TABLE T1 as select * from Dba_objects;[Email protected]> select sysdate from dual;Sysdate-------------------2015-09-20 14:54:101 row selected.[Email protected]> Delete from T1;0 rows deleted.[Email protected]> commit;Commit complete.[Email

Instance-level monitoring, open and low overhead:To create a base table:create table sys.sesstat_history tablespace eol asselect c.username,        c.osuser,       a.sid,        c.serial#,       c.paddr,        c.process,       c.logon_time,    

Just the project at hand solves the problem of ADO connecting to Oracle database and records it to prevent forgetting.Project situation: Using 32-bit environment to complete the algorithm dynamic library, the results later need to upgrade to 64-bit

When you install Oracle, the default password is as follows if you do not reset the password for the following users:Username/Password Login ID descriptionSys/change_on_install SYSDBA or Sysoper cannot log on as NORMAL and can be used as the default

Stored procedure incoming table name in Oracle:First, the data of the table is purged dynamicallyCreate or Replace procedure p_deletetable (I_tablename in varchar2) as--Define variables to hold dynamic SQL statements Dynamic_drop_sql VARCHAR2 (500);

Today, we need to make room on this machine, found that Oracle has a DBF file accounted for about 30G, the data file corresponding to the user usually rarely used, and then want to handle it-delete table space operations.The native database is a

I. Oracle DATA dictionaryA data dictionary is where Oracle stores information about a database and uses it to describe the data. For example, the creator information of a table, create time information, the table space information, user access

How to face customer reviews the Oracle EBS interface is unsightly and does not conform to the operating habits first, I summarize the information on the Internet excerpt. Can be easily customized to modify the interface color of Oracle EBS.

first of all, to understand rank in English means: rank. That is, it is a function that determines the level of the data. Take sales as an example, there are regions, years, months, salespeople, sales, records of these five fields. We can sort

Oracle knowledge sorting notes, oracle sorting notes I want to help you with my learning notes on Oracle knowledge. 1. a brief comparison between SQL Server and OracleLet me show you a picture: After installing SQL Server, we can see that many

Input table name learning for stored procedures in OracleInput table name in Oracle stored procedure: 1. dynamically clear data of the table Create or replace procedure p_deletetable (I _tableName in varchar2) as -- Define the SQL statement dynamic_

Oracle GoldenGate 4. Data Filtering and data item matchingRead navigation write in before start 1 problem analysis 1.1 Business Requirements 2 requirements implement 2.1 source Extract Process configuration Extract table objects and data filtering 2.

Jdbc oracle blob ProcessingLOB (Large Objects) is a data type used to store a Large amount of binary and text data (a LOB field can store up to 4 GB of data ).LOB can be divided into two types: Internal LOB and external LOB.Internal LOB stores data