Oracle

Create an index for an ORACLE data table In general, if the data volume of a data table exceeds several hundred entries, you should consider creating an index. After so long, we finally created an index for some of our larger data tables. First,

I spent more than an hour writing a little thing yesterday. Many people may have written it before, but let's take a look. Backup, you can generate a DataBaseBak folder in the application folder, and save the dmp file in this folder by time. I set

Error Code: ORA-01033: ORACLE initialization or shutdown in progress Fault description: A ORA-01033 error occurs during database connection because files such as database files ([NAME]. DMP)/log files are moved. Fault Analysis: [Point of view is

When Vista is installed with oracle10g, there are many problems, especially the database cannot be established. In the end, I found myself so stupid that I could immediately pull another version for vista.

Premise: run the CMD command   Export command: exp username/password @ database owner = username file = file storage path (for example, F: \ abcd. dmp) Test: exp ZM/sql123 @ ORCL owner = ZM file = F \ abcd. dmp   Import command: imp

How to Learn: Oracle SQL learning path (5): Summary of analysis functions The concept of window is very important in analysis functions. The author wrote this to the analysis function: I personally think that over () is the window function, which

Oracle status before Network Configuration 1. Information in the Registry ORACLE_BASE: ORACLE_HOME: 2. Oracle-related service information Modified Configuration 3. Text path of Network Configuration 4. sqlnet. ora content # This

Artifact SQL Plus SQL puls is an artifact. Apart from its powerful functions, SQL plus is available in severe cases. When SQL plus is unavailable, the system is finished. Let's recall how many accounts are available in our system? Sytem/Sys. use

Preface In this section, we need to clarify three concepts: users, permissions, and roles. Create user Two concepts are introduced in this example. 1. Users: We create users. Of course, this concept of users is introduced. 2. Permission.

Preface The previous figure shows all the content in this article. There is a broom symbol above, representing one-to-many. There is more than one over there. There is a logical structure on the left and a physical structure on the

Part 4 LOB type§ 4.1 LOB type4.1.1 LOB type classificationCLOB: character LOB. used to store a large amount of text information. It is stored using the default character set.NCLOB: used to store character LOB. It uses the National Character Set of

1: enable the Service: OracleServiceACCP and OracleOraHome92TNSListener 2: Start sqlplus in the running state to enter the Oracle editing window. 3: Open Table space: Create tablespace space name DataFile 'e: Control name. dbf' size 10 M space

Oracle stored procedures return record sets. The key is to use a cursor. We certainly have a lot of contact with database cursor. We can use OPEN, FETCH, and CLOSE operations to control the cursor for various convenient operations. I will not repeat

Create or replace procedure SEND_MAIL(As_sender in varchar2, -- email senderAs_recp in varchar2, -- email recipientAs_subject in varchar2, -- mail titleAs_msg_body in varchar2) -- mail contentISLs_mailhost varchar2 (30): = '***. ***'; -- address or

One data table: Student ( Studentid varchar2 Studentname varchar2 ) Data: Studentid studentname 001 002 002 002 003 2nd step package creation:Create or replace package PKG_SELECT_STUDENTASTYPE T_CURSOR is ref cursor;PROCEDURE Getusername(Us_id IN

Because the company requires traditional Chinese characters, the Chinese characters in the lower part are traditional.   Create or replace procedure send_mail (p_From IN VARCHAR2, P_To IN VARCHAR2, P_Subject IN VARCHAR2, P_Body IN VARCHAR2, P_Cc IN

SQL generation Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> -- 1. Create a table in tablesCreate table tb_users(Id number (4 ),UserName varchar2 (20 ),Password varchar2 (20))-- 2. Sequence

You can use the following SQL statement to determine whether a custom object exists in Oracle:Select * from user_objects where object_name = 'yourobobject ';In this way, all information of the object can be obtained. Note that:1. The object name in

Let's take a look at a picture.  This figure shows the architecture of Oracle 9i. It looks complicated. Yes, yes. Now let's take a look:I. Databases, tablespaces, and data files1. DatabaseA database is a data set..Oracle is a database

Oracle user role 1. What is a role?In the previous sections, I described permissions and users. Slowly, you will find a problem: if a group of people have the same permissions they need, it will be inconvenient to manage their permissions. Because