Oracle

Synonyms concept The Oracle synonym (synonyms) is literally the meaning of the alias, and similar to the function of the view, is a mapping relationship. It can save a lot of database space, the operation of different users of the same table does

Some of the most common errors in JDBC access to Oracle databases. The example in the sample code and/or comment column shows the type of SQL statement that caused the error or additional comments about the specific error that is displayed on the

1. Preface At present, all use Oracle as database support platform application, most of the data volume of the system, that is, table data volume is generally in millions above data volume. Of course it's a good choice to create partitions in Oracle,

Environment WinXP Oracle 10g (Installation path d:/oracle/product/10.1.0/) Error phenomenon Yesterday in using Oradim to remove an unused SID service, there was an error starting the database today,ORA-01033: ORACLE initialization or shutdown in

ALTER session SET Nls_sort = Binary_ci; ALTER session SET Nls_comp = linguistic; ref:http://yangtingkun.itpub.net/post/468/460324 In Oracle, both command and object names are case insensitive because Oracle converts all names and commands to

To_date format (in time: 2007-11-02 13:45:25 for example) Year: YY two digits two-digit year display value: 07 YYY three digits three-digit year display value: 007 YYYY four digits four-digit year display value: 2007 Month: MM number two-bit month

6.2.1 Pfile FileThe Pfile (Parameter file) file is a text-formatted parameter file that contains configuration parameters for the database.Oracle 9i establishes a pfile for each database at installation time, the default name is "init+ routine name.

Foreground: Nothing wants to play Linux, think of the future can deploy their own web project up, and then I want to install an oracle ... I didn't know anything about Linux before, only that the company's projects were deployed on top, and then it

In fact, for a database, each table represents a database object, and the database object refers to all the operations of the DDL definition, for example: tables, views, indexes, sequences, constraints, and so on, all belong to the object, so the

Characteristics:Ubuntu 6.10 is a very old Ubuntu, it should be based on the Tesing/unstable branch of Debian 4. So, there are more problems.How do I install oracle10g?Several key technical points:Because Ubuntu 6.10 x is still X11R6 (followed by

When an application uses a database connection pool for data connections, the firewall's settings can cause the connection to time out or be reset. When reading data from the database, it is possible to Connection timed out, this is because the

You want to modify the primary key of a table that already has data, and you don't want to affect the original data. Usually there are the following practices1. When the primary key is not namedCREATE TABLE T2 (ID Integer PRIMARY KEY,Status varchar (

This knowledge point applies only to versions of Oracle 9i or more.To view data changes in a table, use the SQL statement: SELECT * from User_tab_modifications;The fields of the User_tab_modifications table are as follows, and from this table it is

Statistical function Statistical functions include: count (): Sum of Statistics (): Calculate sum min (): Compute Minimum AVG (): Averaging Max (): Calculating the total number of people in the EMP table, average wage, total wage, minimum wage With

In the database in order to facilitate user development, often provide a series of support functions, the use of these functions can be used for data processing. One, String functions         String functions can be processed for strings in the

Borderpowerdesigner:15.1.0.2850Oracle:win32_11gr2_client1 Even Oracle libraries1.11.2 Operation stepsA. Install the Win32_11gr2_client client "install win32_11gr2_client Select administrator Mode"1. Configure TNSB. Configuring a data source(1) Open

--View the amount of data generated per day for archived logsSource: http://blog.51cto.com/bjiokn/321878Alter session set nls_date_format= ' Yyyy.mm.dd hh24:mi:ss ';Select Trunc (completion_time) as Arc_date,COUNT (*) as Count,Round ((SUM (blocks *

There are some problems in the recent project, which can be avoided. Strongly recommended to build the core database do not install to win, simply say a few of the reasons for the fatal.1, win+10g, in the virus, backup machine is also win, the same

Https://www.cnblogs.com/kerrycode/archive/2012/05/13/2454614.htmlWhat do you know about Oracle constraints? Is it more vague or quite thorough? If you are familiar with the following questions, congratulations, you have already mastered the

好久没写东西了，今天写一篇凑个数吧，来公司一年多了，感觉自己到了一个小瓶颈期了。 以前每天很多新东西，都是忙着学，感觉没时间写博客总结一下，大部分都是写笔记，现在又是没东西可以写，每天干着95%都是重复的工作，大部分时间在运维，但我内心是把自己当做dba的，毕竟当初老大把我从java开发拉倒系统组^_^ 上次一个技术把表中的数据删除，这次是另一个技术把正确的包给覆盖了，我给恢复了，哈哈哈---有用的话看一下Reference Blog: 6761458虽然包恢复原理一样，但是操作差异一点，