Find an Oracle learning tutorial.

Expert One on One is a must-see no matter what, programming, tuning or something. There are some things that are very useful, such as why foreign keys must be indexed, query scripts, and so on.

Oracle 10G The Art of Programming This is very related to optimization, a must-see, but you can watch it slowly.

Gai Guoqiang's: Inside and Beyond Oracle" and "Step by Step Oracle", these two books need to have a certain foundation before reading.

Others: Oracle 9i DBA manual, I don't know if this book has a 10G, 11G version, I read 9i, quite basic, but with the work is also quite checkable.

The three thinking notes mentioned upstairs are indeed readable, most of them can be understood at the entry level, and they can be checked if they are forgotten afterwards. Not bad.

In addition, it is necessary to collect some commonly used scripts, or write your own scripts. For example, check the waiting event and the tablespace usage.

In fact, some things about the operating system are also must-see. Must be familiar with at least 1 UNIX system. It is recommended to check out books related to operating systems such as AIX HP UNIX LINUX.

Linux, I recommend Brother Bird's private dishes. aix, I don't have anything to recommend to you. Because you can't just read a book, you can't get that thing, you have to get on the machine.

Others, if you are interested, you can check out the book on backup and recovery. Data Guard and RAC should also be properly understood.

But I still say that everything is equal to zero without practice. So it's useless to just read books. I've seen good-for-nothing OCPs, and I've seen college students who can do anything. Practice practice and practice is the only royal road.

Oracle is a block structure language, the oracle program is divided into several parts, and logical blocks are written in each part, each block is composed of three subparts.

Declaration section: This section starts with the keyword declare. This is an optional section and defines all variables, cursors, subroutines, and other elements to be used in the program.

Executable Command Section: This section is contained between the keywords begin and end, which is a mandatory section. Consists of executable oracle statements of the program.

There should be at least one executable ** line, which can be just a null command that means no action is performed.

Exception Handling Section: This section starts with the keyword exception. This is an optional section that contains exceptions that are incorrect in the handler.

Each oracle statement is preceded by a semicolon (; Ending. Oracle blocks can be nested within other oracle blocks using begin and end. The following is the basic structure of a poracle block.

hello world example:

end；The line represents the end of the oracle block. To run from the oracle command line, you need to type the character after the last line of the command. When the above ** is executed at the oracle prompt, it produces the following result:

Oracle Identifiers: Oracle identifiers are constants, variables, exceptions, procedures, cursors, and reserved words. The identifier consists of one letter, optionally followed by multiple letters, numbers, dollar signs, underscores, and numeric signs, and may not exceed 30 characters.

By default, identifiers are not case-sensitive. For example, you can use integer or integer to represent a numeric value. You can't use reserved keywords as identifiers.

If you have some SQL foundation, it is very easy to learn, and most of the database languages are very similar.

Learn standard SQL statements, Oracle has some special Oracle functions, others such as MySQL, SQL Server 2000 are different.

Oracle Beginner or Oracle Complete Handbook, borrow or buy.

Follow the above content on the machine operation, keep operating, and one day you will naturally understand.

Oracle masters are all operated, and practice is the truth.