Oracle

1. Set the Sql*plus promptSql> set Sqlprompt "_user ' @ ' _connect_identifier>"[Email protected]>In order to automatically set sqlprompt for all Sql*plus sessions, place the above command in the Glogin.sql file in the Oracle_home/sqlplus/admin

--oracle implement self-increment id--create a T _studentinfo table The CREATE TABLE t_studentinfo ("id" integer NOT NULL primary key, Xsname NVARCHAR2 (+) NOT NULL, Xsage integer NOT NULL, Mobile varchar (n), Email varchar (+), Address

1. EXP　　1a> Full Mode full=y2 3EXP User/[email protected] (as ROLE) buffer=64000 File=c:\full. DMP full=y4 5B> User Mode owner=User6 7EXP User/[email protected] buffer=64000 file=c:\user. DMP Owner=user8 9c> Table Mode tables=tab_*Ten OneEXP

During the logical standby database creation process based on physical standby: alter database recover to logical standby READDB; Our business is the passport application. It is very troublesome to stop or stop the application. In short, the drug

Running Environment: ubuntu + oracle 11.2.0 ORA-12547: TNS: lost contact error occurs when the command starts oracle. Good afternoon, no matter in the afternoon. If the link is invalid, it will not work after Shutdown and restart. Then google found

  Project requirements: Count the attendance rate of each inspector (USER_ID) for the current month and query related fields Sign-In rate formula: the unit is inspection personnel, (Total number of inspection points in all the points sign in this

0. completely uninstall Oracle10 (Windows) Installing Oracle Multiple times in Windows may cause confusion. to reinstall Oracle, you must first clean and uninstall the previous Oracle. 1. Back up data when necessary 2. Uninstall Step 1. Use DBCA to

I learned the operations related to query and create a management table from my previous notes. This time, I learned how to process data, including inserting data into the table and updating data) and DELETE data ). To save the original data of emp,

The index quality has a direct impact on the overall performance of the database. Good and high-quality indexes increase the database performance by an order of magnitude, while inefficient and redundant indexes make the database performance slow,

CursorInsufficient query results and records, difficult to express with variablesThe cursor can access the result set by row.Basic PrinciplesDML results are placed in the buffer zoneThe cursor is a pointer to the buffer.CategoryStatic cursorThe

The last time I took a note, I learned how to query multiple tables. This time I took a note to learn about grouping functions in Oracle. First, let's take a look at what group functions are: Group function: acts on a group of data and returns a

1. Install oracle11g. The installation diagram is as follows: 1. decompress the win32_11gr2_database_1of2.zipand win32_11gr2_database5of2.zip files. Note: extract the two files to the same directory, that is, merge the Components directories

Symptom: Reporting PRVF-5646 when installing Oracle grid 11.2.0.3/4: The DNS response time for an unreachable node exceeded "15000" MS on following nodes Solution: ? 1. Modify the/etc/named. conf file of the DNS server and add the fil "/dev/null";

1. Regular Expression of question 3rd Regular Expressions only search, replace, format, and other functions. Regular Expressions are usually used for back-reference formatting. length and concatenate are not calculated. 2. Delete columns with

How Does ORACLE 11G modify awr retention period less than 8 days? Oracle Database 11g has a system-defined Moving Window Baseline by default. This Baseline corresponds to all AWR data during the AWR retention period.Only one Moving Window Baseline

A pos system has a large application volume and a large data volume! Statistical analysis of historical transactions affects another application to a certain extent. The two applications are OLTP and OLAP respectively. In fact, many projects have

In the OLTP system, nested connections account for about 70%, hash connections account for 20%, and merge sorted connections account for 10%.Nested connection Algorithm: Nested join selects a small table as the driver table from two tables, and a

Character Functions1. ASCII (x) and chr (x)ASCII (x): returns the ASCII code of character x.Chr (x): returns characters with an ASCII code of x.2. concat (x, y)Used to add y to x, same as |3. initcap (x)Converts the first letter of each word in x to

1: executed per minute Interval => TRUNC (sysdate, 'mi') + 1/(24*60) Or Interval = & gt; sysdate + 1/1440 2: daily scheduled execution Example: Execute at every day Interval => TRUNC (sysdate) + 1 + 1/(24) 3: scheduled weekly execution

Copy codeThe Code is as follows:Create or replace Function GetInvitationNO (prev varchar2, num1 varchar2, num2 varchar2, sessionSetting varchar2) Return Varchar2 Authid Current_User Is PRAGMA AUTONOMOUS_TRANSACTION; -- you must use the "Current_User"