I used Oracle three years ago and simply "used it". It mainly refers to some database operations and does not include the creation of some stored procedures. So I only know a little about Oracle, at that time, all the items in the database in that company were under the responsibility of those consultants. In addition, I just went to that company, so I just made some additions, deletions, changes, and queries.
I used Oracle three years ago and simply "used it". It mainly refers to some database operations and does not include the creation of some stored procedures. So I only know a little about Oracle, at that time, all the items in the database in that company were under the responsibility of those consultants. In addition, I just went to that company, so I just made some additions, deletions, changes, and queries.
I used Oracle three years ago and simply "used it". It mainly refers to some database operations and does not include the creation of some stored procedures. So I only know a little about Oracle, at that time, in that company, all the items in the database were under the responsibility of those consultants. In addition, I just went to that company, so I just did some operations to add, delete, modify, and query, it's really embarrassing to generate some reports. I have organized a simple development framework that only supports SQL Server databases. Two friends once contacted me to support Oracle, because the existing databases in their company are Oracle, it cannot be changed. Recently I am busy, so I want to see how difficult it is to use Oracle for this program. Today I installed the Oracle 10g version and wrote down some of the installation tips and steps, it would be better if you could help everyone. If you have any help, please click "recommendation". If you have any suggestions, please pay attention to them. Let's discuss and make progress together. The text is relatively small, because the picture is more realistic:
Because the environment is different, the size cannot be unified. Please wait...
First install Oracle
Create Database files through DCA,
After the database is created, we need to install the English version of Quest Toad for Oracle v9.1.0.62,
Use Quest Toad for Oracle to operate databases,
After the Quest Toad for Oracle v9.1.0.62 English version is installed, we create a user through SQLPLUS
Authorization is required after the user is created. Otherwise, the user cannot log on to the database, let alone operate the database:
Open Quest Toad for Oracle and enter the user name and password to connect to the database.
If the message "unable to parse the specified connection identifier" is displayed, you may need to configure a local listener,
To configure a listener, follow these steps:
If the connection fails, check whether the password is incorrect. Click "Change Logon" to change the user name and password.
First, create a table and select from the menu,
DataBase-Create-Table
After the data table is created, Insert a test record, as shown in. We can see that our records have been added. Note that if the current account is not authorized by SYSDBA, therefore, the table cannot be operated. At that time, I did not Insert the table. This SQL statement was executed all the time and no error was prompted. Later I found that I was not authorized to operate the table, therefore, you can use SQLPLUS to grant permissions.
You can also use the SQLPLUS command to operate the database.
Http://www.cnblogs.com/allen0118/archive/2012/12/07/2807435.html