Oracle

Upload the Oracle installation file to the Linux server first1. Unzip the zipUnzip Linux.x64_11gR2_database_1of2.zipUnzip Linux.x64_11gR2_database_2of2.zip2. Create the installation directoryMkdir/opt/oracle3. Create a user group:Groupadd

I have to work overtime on weekends ... Do a lot of learning, and continue to watch the tutorial tonight, multi-table query1, Cartesian product: Multi-table should pay attention to2, outside the connection: Before a record, that is (+) This writing,

DescriptionOracle Database account Number: SticOracle Database Password: sticOracle DB instance: ORCLOracle database table: UserInfoColumns for Oracle tables: Id,nameThe code that does not handle the exception is as follows:Create a database

How do I create a tablespace in Oracle? There are two main ways: one is to use SQL commands, and the other is created by the Oracle Client Enterprise Manager console. Here are a few separate sections:1 Create a tablespace from SQL command1.1

--1. Querying Dblink Permissions Select * fromSys.user_sys_privs TwhereT.privilege like Upper('%link%'); --2. Granting Dblink Permissions Grant CREATE Public DATABASELINK,DROP Public DATABASELINK todemobase; --3. Query the created Dblink

DescriptionCreating a stored procedure is much like writing a normal PL/SQL program, such as including the life part, the execution part, and the exception part. But there are a lot of differences between the two implementations, such as: Creating a

-----------------Produce Cartesian product------------------------------------SELECT * from Emp,dept; --with no conditions, the number of records is 14*4 = 56 recordsSELECT * from the EMP Cross join dept;--crossover connection, IBID.Select COUNT (*)

1, check the user's proifle is which, is generally default:Sql>select username,profile from Dba_users;2. View the password expiration settings for the specified profile (such as default):Sql>select * from Dba_profiles s WHERE s.profile= ' DEFAULT '

Oracle text and format string mismatch resolutionDate-Time type for OracleRemember to use the To_date () method when inserting data into the date type of Oracle.such as insert into Cuslogs (STARTTIME) VALUES (to_date (' 2009-5-21 18:55:49 ', '

24. The name of the teacher who has more than 5 students who have enrolled in a courseSelect from where t.tno= and C.cno=and =( Selectfromgroupby hasCount(CNO)> 5 Group by T.tname25. Check the records of all students in class 95033 and

Sometimes write Oracle in the use of information such as cursors to loop processing logic, the exit, RETURN, continue is easy to confuse, the web search information is not very clear, so I wrote a small piece of code to test the three usage. The

Query and delete duplicate records of SQL statement 1, find redundant records in the table, duplicate records are based on a single field (ID) to determine the select * from table where Id in (the Select ID from table group Byid having count (ID) > 1

--row to column custom function, only for TABLE1 table--Paramtype is a parameter type that is used to determine that param1 and param2 are condition parametersCreate or Replace functionMy_concat (Paramtypeinch integer, param1inch varchar2,

DMP Format:Export in 1.dmp format can be done through client-side tool (PL/SQL) operations, through the menu bar---->tools---->export Tables, then set to tick the appropriate parameters, rows represent whether to export with the data2. The export

One: Start Oracle[Email protected] ~]# su-l Oracle[Email protected] ~]$ Sqlplus/nologSql*plus:release 10.2.0.4.0-production on Mon June 13 14:11:16 2016Copyright (c) 1982, Oracle. All rights Reserved.Sql> Conn/as SYSDBA Connected to an idle instance.

Http://www.cnblogs.com/chen1388/archive/2010/07/06/1771919.htmlDecode function:Decode (AA, 1, ' XS ', 2, ' ps ', ' MS ')Equivalent(Case AA If 1 then ' XS 'When 2 Then ' PS 'Else ' Ms

Prior to the online search by the order in the specified sequence of methods, according to Charindex to deal with the sorting, but the Oracle found no, because Oracle has no charindex function, and then use InStr instead of charindex, and then on

1. Attention PointsIn the process of querying, not determining the amount of data in the database table, first querying the data volume, the data volume is large, you can not directly query (SELECT * from EMP), if the data volume is large, direct

Main content: User and table space; tables and constraints; Query statements.I. OverviewOracle Installation: Visit the website, downloadSecond, the User and table spaceYou can log in to Oracle with SQL Puls in the Start menu when you install Oracle.1

1. Numerical functions　　Round (N[,m])　　　Rounded, M is 0 directly rounded n,m>0 take the decimal point after the M bit, m　Ceil (N)Take a minimum integer value greater than n　　Floor (N)Take the maximum integer value less than n　　ABS (N)Take the