Oracle

http://blog.csdn.net/weiwenhp/article/details/8093661We find that our lives are all about passwords, and you have to remember all kinds of passwords. such as bank cards, mail, QQ, Weibo, games, various website members.The use of the database is no

http://blog.csdn.net/weiwenhp/article/details/8094739Directory (?) [-] SQL Server Rights Management The difference between login and user Role roles granting permissions Compare Oracle vs. SQL Server with a

http://blog.csdn.net/weiwenhp/article/details/8088979We know the database, as the name implies. The most important thing is to manage the data, and the data in the system is mainly stored in the table, so the database almost all the mechanisms and

1. Log in to SYSDBA database2. Querying snapshots based on point-in-timeSELECT * from source$ as of TIMESTAMP to_timestamp (' 2014-02-24 05:10:32 ', ' yyyy-mm-dd HH24:MI:SS ') where source like '%CP _eas_costbreakdown_info% ';

1. Generate Test tables and data:CREATE TABLE MyTest(ID int PRIMARY KEY,NodeName varchar (20),PID int);Insert into mytest (id,nodename,pid) VALUES (1, ' A ', 0);Insert into mytest (id,nodename,pid) VALUES (2, ' B ', 1);Insert into mytest

Tricks One:1. View the locked table:2. Select P.spid,c.object_name,b.session_id,b.oracle_username,b.os_user_name from V$process p,v$session A, V $locked _object b,all_objects C where p.addr=a.paddr and A.process=b.process and c.object_id=b.object_id3

When the query to the results of complex processing, you can use the union query, sub-query, etc. to get the desired results. The following is a specific classic question, hoping to inspire readers.1. Title Requirements:Table NBA records the

Orabbix monitoring Oracle Database 1 Downloads:http://www.smartmarmot.com/product/orabbix/download/2 permissions granted to a file for execution#chmod +x /opt/orabbix -R#chmod +x /opt/orabbix/run.sh3 Create a file named Config.props, you can refer

(1). Table space and the concept of partitioned tablesTable Space:is a collection of one or more data files, all of which are stored in the specified table space, but are primarily tables, so called table spaces.Partition table:When the amount of

The Oracle Wm_concat (column) function allows us to use it frequently, and below teaches you how to use the Oracle Wm_concat (column) function to implement a field merge if you have an Oracle Wm_concat (column) If you are interested in the use of

Static registration and Dynamic Registration summaryFirst, what is registration?Registering is registering the database as a service to the listener. The client does not need to know the database name and the instance name, but only needs to know

There are two simple examples to illustrate the efficiency issues of "exists" and "in"1) SELECT * from T1 where exists (select 1 from T2 where t1.a=t2.a);When the T1 data volume is small and the T2 data is very large, the query efficiency of T12)

stored Procedure : is a set of SQL statements that are used to complete a specific database function, which is compiled and stored in the database system. At the time of use, the user invokes and executes a stored procedure name that has already

1.JDBC connecting MySQL:String Connurl = "Jdbc:mysql://localhost:3306/testdb";String connuser = "root";String connpwd = "root";Class.forName ("Com.mysql.jdbc.driver");Connection conn = drivermanager.getconnection (CONNURL,CONNUSER,CONNPWD);2.JDBC

--(Take the system time as an example, the actual situation can be replaced)1 Read system time –sysdateSelect sysdate from dual;2 Read time information (year, month, day, hour, minute, second)Select To_char (sysdate, ' Yyyy-mm-dd hh24:mi:ss ') as

First, generate a random dateFor example, generate an arbitrary date within 2015 years:/** Analysis: Any date within 2015 years, that is, the date range is (2015-01-01, 2015-12-31)* Can be converted to 2015-01-01 + (0, 365),* of which, 2015-01-01 is

、、、、、、、、、、、、、、、、 create tablespace \ Assign role \ create data table \ Insert data \ Create sequence \ Add Comment 、、、、、、、、、、、、、、、、、、、、、、、、、、、--Create TABLE spaceCreate Tablespace New_tabspaceDataFile ' E:\File_Orc\File\A.DBF 'Size 100mCreate

Oracle uses imp and exp to import and export dataUse the cmd command to export data. The details are as follows:1: There is a tnsname. ora file in the directory G: \ Oracle \ product \ 10.1.0 \ Client_1 \ NETWORK \ ADMIN. The content is as

Oracle modifies port 8080 to port 8001Zookeeper 1. log on to the database with the sys account Run the following command under SQL plus: conn sys as dba; press enter and enter the password. Tip: If the connection is successful, proceed to step 2.

Oracle uses orderby to sort null values When order by is used in Oracle for query and sorting, if there is a null value in the sorting field, the sorting result may not reach the expected result. For example: Select * from test order by age desc;