Oracle

Create a temporary table spaceCREATE temporary tablespace test_temptempfile ' C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf ' SIZE 32MAUTOEXTEND ONNEXT 32M MAXSIZE 2048MEXTENT MANAGEMENT LOCAL;Create a user table spaceCREATE tablespace

The database design paradigm is a very important concept, but this important degree is only suitable for reference. Using the database design paradigm, you can make the data table better to save the data, because the reasonable design, if the data

A view is a very important database object in the form of a normal table, and we can query the data from the view.In fact, it is a virtual table built on a table that does not store real data in the view, but simply saves a SELECT statement, and

Resume oracle.sh in/etc/profile.d/The contents are as follows in Nls_lang setup encoding1 oracle_home=/usr/lib/oracle/12.1/client642 c_include_path=/usr/include/ oracle/12.1/client643 ld_library_path= $ORACLE _home/lib4# RememberThis was the client

1. Create a stored procedure for sending messagesCREATE OR REPLACE PROCEDURE send_mail (p_recipient VARCHAR2,--Mail recipientP_subject VARCHAR2,--Mail headerp_message VARCHAR2--Message body) is--The following four variables should be assigned

The three complex type variables that are frequently encountered in the actual project. Combine some of the project examples to do a collation, the specific following: Record type: A record type can contain one or more members, and each

The system global Area (SGA), also called the shared global zone. 1. Data buffer (Cache):Used to store data read from a disk data file for all users to share. After the user modifies the data, the modified data is first saved in the database

1. Query the current date and timeSelect from dual;2. Check the last day of this monthSelect from dual;3. How many months before and after querySelect add_months (sysdate, from dual;4. Check the specific date of the week of the following week

1, to have a unique index or primary key as a precondition, reduce the number of data conflicts, such as the example of red places: 2, when there is in the query, try to use exists, this can improve query efficiency: CREATE TABLE tf_f_user_diff1

Oracle: Turn on monitoring--lsnrctl startOracle: Start/Close Database--sqlplus/nolog--conn/as SYSDBA--startup (Open)--shutdown (OFF)Oracle: Create a table space1. Create a temporary table space--create temporary tablespace XXX (name) tempfile ' xxxx.

To the company on the first day, there is nothing to do, the manager said today need to make the report, need to write a few Oracle statements, used to query all types of people under themember number and proportion of the total population.

Problem descriptionFor example, the developer on the employee table to make an UPDATE statement, but after the update, only to find that the updated statement is incorrect, you need to undo the update operation just now. such as (update employee E

The Oracle default port number is 1521. It's easy for hackers to scan and remember your database every day.So it's necessary to modify the default port number.1. Check the listening status firstLsnrctl status2. Turn off monitoringLsnrctl stop3.

The user presses, the string decomposition in the Oracle programming can use in the word, the word parsing, then may implement the word search merger, is the basic code.The code below, the author retains ownership.Create or Replace function

InStr (String1,string2,start_position,nth_apperance)String1: The source string to look up in this string;String2: The string to find in the String1;Start_position: The starting position of the search in String1;Nth_apperance: To find the first

--Create a sequenceCreateSequence Zonecode_seq Start with 1Increment by 1; --Create a triggerCreate or Replace TriggerZonecode_trigger beforeInsert onorg_hospitalzone_dict forEach rowbegin SelectZonecode_seq.nextval into: New. Hosp_zonecode

Below is a description of the Scheduled cleanup archive log file operation under Oracle.Assumption: The archive log is full and the archive log is emptied as follows.First step: Create a Rman_del.txt file under C driveStep two: Do a batch file named:

Oracle Operation Problems LinuxOracle11.2.0.3Problem:When sqlplus/assysdba executes starup, an error is returned: A: Check whether this parameter is set in sqlnet. ora. If SQLNET. AUTHENTICATION_SERVICES exists, it is set to ALL. If not, it does not

Detailed introduction to ORACLE sqlplus commands (to) and oraclesqlplus 1. ORACLE startup and Shutdown1. to enable or disable the ORACLE System in a single-host environment, you must first switch to the ORACLE user, as shown below:Su-oracleA. Start

Go to: Query oracle slow sessions and SQL, oraclesession -- Query the slowest SQL statement Select * from (Select parsing_user_id, executions, sortsCommand_type, disk_reads, SQL _text from v $ sqlarea order by disk_reads desc) Where rownum -- Query