Oracle

1. What is registration?Registration is to register the database as a service to the listener. The client does not need to know the Database Name and Instance name. It only needs to know the service name provided by the database to external users

Oracle developer is famous for its rapid data processing and development, and its exception handling mechanism is also relatively complete.1. Advantages of exceptionsIf no exception exists, check whether each command succeeds or fails in the program,

Any database may have certain security risks during its long-term use. For database management Personnel should not only hope for the safe operation of computer operating systems, but establish a complete set of database backup and recovery

Many people know that the Oracle listener has always had a security risk. If security measures are not set, users who can access the listener can close the listener remotely.Example:D: \> lsnrctl stop eygleLSNRCTL for 32-bit Windows: Version 10.2.0.3

Recently, we need to optimize the efficiency of the Oracle database, and then check a lot of efficient methods on the Internet to determine whether the record exists.There are many suggestions for the first method on the Internet. I did a test, but

In normal project development, the paging stored procedure uses a large number of stored procedures. top is often used in the SQL Server paging stored procedure, and RowNum is often used in Oracle. Now, there is a UserInfo table, where one field is

Oracle EBS provides multiple forms of report development and output. MS Excel has obvious advantages in data processing, and opening report output in Excel is a common development item. However, because Excel is "too intelligent and not intelligent",

Parse the oracle select locking method and the query of the lockI. oracle select locking methodCopy codeThe Code is as follows:Create table test (a number, B number );Insert into test values (1, 2 );Insert into test values (3, 4 );Insert into test

1. Convert string type to timestampCopy codeThe Code is as follows:Select to_timestamp ('01-October-08 07.46.41.000000000 AM ', 'dd-MON-yy hh: mi: ss. ff am ')From dual;2. Convert timestamp to date typeCopy codeThe Code is as follows:Select cast (to_

Some time ago, after installing oracle for the old girl, I found that the computer name of the old girl was long and difficult to remember. So I changed the name of my computer and did not expect this operation, but it's time to break down the old

Round (x [, y]) [Function] returns the rounded value.[Parameter] x, y, numeric expression. If y is not an integer, the y integer is truncated. If y is greater than 0, the rounding is y decimal, if y is less than 0, it is rounded to the y place to

During development, a cursor containing a table that does not have fields may be declared to solve special problems. This article will introduce such problems in detail. For more information, seeData. * is a table, and then the fields in other

[SQL]Copy codeThe Code is as follows:Create table wlbtest1 (Username varchar2 (2 ),DeptID number);Create table wlbtest2 (DeptName varchar2 (10 ),DeptID number);Insert into wlbtest1 values ('A', 1 );Insert into wlbtest1 values ('B', 1 );Insert into

Lpad usage in oraclePad Translation: FillThe lpad function adds the specified string to the left of the string. Usage:Www.jb51.netLpad (String, truncation length, added String ).It is said that adding strings is not accurate. A more accurate

When deleting a user in Oracle, the following statement is prompted: ORACLE cannot delete the current connected user:SQL codeSQL>Copy codeThe Code is as follows: select username, sid, serial # from v $ session;Username sid serial #-------------------

1. IntroductionScript: a script is an executable file written in a certain format in a specific descriptive language, also known as a macro or batch processing file.Ii. BackgroundRecently, the oracle database has been installed in Windows. Because

1. intersect is the intersection of multiple query results;2. query the SQL statements recorded in the table within two basic periods;Select * from shengjibiao t where t. createtime between to_date ('2017-7-26 ', 'yyyy-MM-dd') and to_date ('2017-7-29

The principle is to declare constants, including the number of columns, number of rows, and attributes of each column, and then use these constants to control Cells in other procedures of the program. Very convenient for modification and

The implementation of Oracle regular expressions is in the form of various SQL functions and a WHERE clause operator. If you are not familiar with regular expressions, this article will show you about this new extremely powerful yet mysterious

Insert view conditions:1. if a view is generated based on a basic table, this is called a non-join view. All non-join views can be updated, that is, they can be performed on the view, INSERT, UPDATE, DELETE operation.2. for a connection view, follow