Oracle

CREATE OR REPLACE PROCEDURE procsendemail (P_txt VARCHAR2,P_sub VARCHAR2,P_sendor VARCHAR2,P_receiver VARCHAR2,P_server VARCHAR2,P_port number DEFAULT 25,P_NEED_SMTP INT DEFAULT 0,P_user VARCHAR2 DEFAULT NULL,P_pass VARCHAR2 DEFAULT NULL,P_filename

Query table Space usage 　　 Select A.tablespace_name "Table space name", 100-round ((NVL (b.bytes_free,0)/a.bytes_alloc) *100,2) "occupancy rate (%)", Round (a.bytes_alloc/1024/1024,2) "Capacity (M)", Round (NVL (b.bytes_free,0)/1024/1024,2

Maybe because work needs to be done frequently before different database tutorials, let's take a look at how to migrate MySQL data to Oracle. Because the previous project was using the MySQL tutorial database, now that the new company requires

Using shells under Linux and UNIX is easy to implement if the Windows environment can be combined with scheduled tasks 1. Create backup directory d:\backup, create Batch command Bak.bat, write backup script Exp USER/PASSWD@ORCL direct=y

First of all, basic usage:First press 11G beforeConn/as Sysdba;Create user test identifed by test; ORA-65096: The public user name or role name is invalid. Check the official document that "trying to create a generic user, you will need to use C #

Need to learn SDE configuration related knowledge, in which Oracle database installation encountered errors INS-30131, although not finally resolved, but found a preliminary thinking, recorded to provide you with reference. There may be errors or

Because you want to return a Table object, you declare the global type first, regardless of what method is followed, and the field variable type is object and cannot be a record: Create or replace type T_test as Object ( EMPNO number (4),

First, use rownum for record ranking: In the previous "Introduction to Oracle Development analysis function over", we understand the basic application of analytic function, now we consider the following questions: ① to rank all customers by total

1.ASCII returns the decimal number corresponding to the specified character; Sql> Select ASCII (' a ') a,ascii (' A ') a,ascii (' 0 ') zero,ascii (') space from dual; A A ZERO space--------- --------- --------- ---------65 97 48 32 2.CHR gives an

The Oracle tutorial you are looking at is: Automatically backing up Oracle databases. It is believed that a large number of system administrators are doing the same job every day-backing up the data. Once a day of negligence, and this day the system

Prerequisites for Recurrence: The output format is "text" of the Concurrent Program: effective responsibility and user. How to show Excel options when viewing output: System administrator installation browser options Add a row of "file format" to "

The Oracle database has recently begun to be studied for project reasons. Oracle is one of the most popular databases, powerful, excellent performance, relative to the difficulty of learning is not small. I am going to write down my learning process

When setting the password for a database instance, be careful not to start with a number, or you will experience an ORA-00988 missing or invalid password (password missing or invalid) error. After Oracle 10g installation is complete, you can use

After the Oracle 11g database is successfully installed, you will find that your computer is running slowly, with a lower configuration or even a very card condition, and that you can improve the speed of your computer by banning Oracle services

The Oracle tutorial being looked at is: PL/SQL implementation of Oracle database task scheduling. Absrtact: This article mainly on the database recovery and system task scheduling, combined with the general database background processing experience,

1. Account and Password settings To select User sys, SYSTEM, DBSNMP, and Sysman to use the same password, select "All accounts use the same password". Bi user, password Ch51*****,scott user. All of the above are the same password ch5******* Here,

The first thing that comes to mind is contains,contains usage as follows: SELECT * from students where contains (address, ' Beijing ') However, using the CONTAINS predicate has the condition that the column is indexed, that is, if the

11g Oracle Export table does not export data as null by default 1, oracle11g default to empty table does not assign segment, so use EXP export oracle11g database, empty table will not export.2, set the Deferred_segment_creation parameter is false,

Although Oracle's dynamic SQL statements are really handy to use, the process of assembling them is cumbersome. Especially when the date Type field is involved in the Assembly statement, the Assembly should be added To_char first to the character,

The principle is to declare constants, including the number of columns, the number of rows, the properties of each column, and then use these constants to control cells in other procedures of the program. Very convenient, easy to modify and