Oracle

1. Change the table name and field name to uppercase see-http://www.cnblogs.com/wenboge/articles/4121331.html2. Change the table name and field name to lowercase① change table name to lowercasebegin forCinch(SelectTABLE_NAME TN

FOREIGN KEY constraints guarantee referential integrity. A FOREIGN KEY constraint restricts the range of values for a column. An example is defining a state abbreviation in a finite value set, which is another control structure--a parent tableBelow

Search on the Internet, know that probably, can not be installed with APT, Oracle also no longer provide Deb package. can only under tar.gz pack oneself outfit.Download it down first

First, constraints? 1. Overview of ConstraintsBinding effect:(1) Define rules(2) Ensure completeness: including the accuracy and reliability of the data. To ensure that data does not go wrong, or to minimize errors.Type of constraint:(1) Non-null

I. Overview of database ManagementAfter completing the Oracle Software installation, the DBA should be responsible for organizing and managing the database, with the main tasks of:(1) Start and close the database;(2) Create a database;(3) Delete the

1. Single quotation markSo what if the contents of the field contain single quotes? For example: It ' s fine. Method also has three• Method One: Use escape charactersSQL > Select ' Test ' | | "From dual;Note: What does the "four single quotes" mean?

Oracle Database Object _ sequenceA sequence is a database object that is used to automatically generate a unique set of ordinal numbers.A sequence is a shared object in which multiple users can work with ordinal numbers in a sequence.A sequence is

We have an error in the Recover database times:Rman-06054:media recovery requesting unknown archived log for thread 1 with sequence 149 and starting SCN of 3507749here is a reminder to revert to an unknown SCN number.  we have only 148th in the

You need to convert the lowercase amount to uppercase when you print the contract report for EBS Development.Here is the conversion function I wrote myself.The main idea: first get the decimal position, in the distinction between integer and decimal

Oracle View Current User informationFirst, view the current user information:1. View the current user-owned Role Permissions information: SELECT * from Role_sys_privs;2. View the details of the current User: SELECT * from User_users;3. View the

First, set operation1.UNION : the set operation. Syntax structure:sql>Select Table 1, column 1, table 1, column 2 from table 1 Union select Table 2 column 1, table 2, column 2 from table 2;Table 1, column 1 and table 1, column 2 is the two columns

Oracle HA High Availability specific explanation (one, client, server-side service specific explanation): Http://write.blog.csdn.net/posteditWe've seen Taf. Oracle's session can be connected on its own initiative, and it needs to be explained. This

The previous article writes, installs the centos6.5 on the virtual machine, the result according to the article very smoothly installs, but uses the Yum installs the software, the error, the source has the question, cannot download, then pings the

1. Absolute value: ABS ()Select ABS ( -2) value from dual;2. Rounding function (Large): Ceil ()Select Ceil ( -2.001) value from dual; (-2)3. Rounding function (small): Floor ()Select Floor ( -2.001) value from dual; (-3)4. Rounding function

Oracle Loop statementsWhen you write a loop control structure, you can use three types of loop statements, such as the basic loop, while loop, and for loop, which describe the methods for using these three loop statements.1. Basic cycleLOOPStatement1

Oracle servers are primarily made up of instances, databases, program global, foreground processesExample: used to provide the ability to administer a databaseDatabase: Consists of an Oracle database file that is used to store system data, typically:

Environment: Role Machine name Operating system Ip Note Main Library Db1 CentOS 5.11 x86_64 192.168.2.241 Install Oracle, create a database Standby Library Db2

Go from Network1. NESTED LOOPThe nested loop connection is a good choice for cases where the subset of data being connected is small. Nested loop is to scan a table, each read to a record, according to the index to go to a table to find, no index is

Oracle Database sorts null values and the difference between mull and null strings. oraclemull Processing of null values in order by sortingWhen sorting business data, it is found that some field records are null values, and then there is a data

Oracle service cannot be started. If Windows cannot start OracleOraDb10g_home1TNSListener, error 1067: Unexpected Process Termination ., Run the Net Configuration Assistant in the Configuration and transplantation tool to configure the listener.