Oracle

VBA Connection Oracle needs to add references:After that, the connection string is: Provider = msdaora.1; password=******; User Id=xxxxxxx;data source=dbid; Persist Security Info=trueThen use the standard package of ADO, 1, use ado.connection, open

Grouping functionsIn a grouping function, if there is a find item grouped, the other items must also be grouped, for example, the following statement will be an error because Sal is grouped, and ename is not grouped:1. Show the highest paid

As mentioned above to create a data restore point, the premise of data recovery is that we use the Delete command when deleted, delete will write the log during the deletion (so that our data can be recovered), of course, the write log will cause

Oracle's memory configuration is tied to Oracle performance. In general, it can be divided into two chunks: the shared portion (mainly the SGA) and the process-exclusive portion (mainly the PGA). In Oracle versions under 32-bit operating systems, it

Generating random data under SQL Server is much more dry, but I'm stupid under Oracle. Not used Oracle, do not know what to do? SQL Server relies on tablesample or checksum (NEWID ()) for random sampling, and Oracle has its own random sampling

The use of the--oracle trunc () function/************** Date ********************/1.select trunc (sysdate) from dual--2013-01-06 today's date is 2013-01-062.select trunc (sysdate, ' mm ') from dual--2013-01-01 returns the first day of the

1.Sequence n automatically generates a unique number n is a shared object n A typical primary key applied to a table N Alternative application code N Place the serial number value in the cache to increase access speed

Oracle uses virtual column rownum to query the number of records between a specified number.The first line of Rownum=1For example, we want to query the first five records, you can useSELECT * FROM table name where rownumBut if we use rownum>5, we

--create a stored procedureCREATE OR REPLACE PROCEDURExxxxxxxxxxx_p (--The parameter in represents the input parameter, out represents the input parameter, and the type can use the legal type in any Oracle. Is_yminch CHAR) as--Defining

1. Parse tables and indexes (analyze does not rebuild the index)Analyze table TableName COMPUTE statisticsEquivalent to analyze table TableName compute statistics for table for all indexes for all columnsStatistics for table exist in views:

1. High-availability rows(1) Ha (High availability ha)(2) RAC (Oracle Real application Cluster)(3) DG (DATA Guard)(4) Oracle Replication(5) Raid and mirrored drives2. Backup and Recovery(1) Collect backup and recovery policy requirements.(2)

Oracle optimizes or replaces several words in, exists, and union. Test No problem!Select the appropriate statement according to the actual situation. Assume exponential, or full table scan, in and not in should be used with caution. Doing so will

If a user fails to log on for three consecutive times, the user is locked out for two days and two days later before the user can log on again.To create a profile:Update your account:Users will be locked out after three login failures:How to unlock

A Installing OracleSTEP1 Download the Oracle compressed package and unzip it to the same folderSTEP2 Double-click setup.exe to installSTEP3: Enter the following interface configuration:Do not fill in the mailbox, remove the updateIn addition to

PLSQL cannot directly connect to a 64-bit Oracle11g Database After the Oracle 11g Database is installed today, plsql cannot be used to connect to the database. The Database drop-down box in the plsql client logon window is empty. See:     

Modify logon authentication mode in oracle By configuring the sqlnet. ora file, we can modify the oracle login authentication method.SQLNET. AUTHENTICATION_SERVICES = (CNT); operating system-based authenticationSQLNET. AUTHENTICATION_SERVICES =

How do Oracle beginners know common data tables such as EMP, DEPT, and SALGRADE? Graphic operation Oracle Database beginners often mention several common database tables in some books, such as EMP, DEPT, and SALGRADE. Where are these tables

ORACLE user name change Oracle user passwords have been frequently modified before, but few user names have been modified. In the past, only one user 1 can be created, user 2 data can be imported to user 1, and deleted by user 1. This is very

Oracle & amp; mysql Log InformationPreface The log information here refers to the log information used to perform command operations on the command line.Oracle1. Import and Export: imp omjx/ppet1205 @ xforcl full = y file = full path \ xf. dmp log =

Oracle retrieves data from each table and saves it to another table. Obtain data from each table and save it to another table: CREATE VIEWPARAMETER_viewWITHTall(SELECTP. PI_NO, -- product serial numberP. SERIALNO, -- product no.P. PI_NAME, --