oracle discoverer plus

oracle| Create | page Create an HTML page with Oracle's Sql*plus tool Author: fenng Oracle's Sql*plus tools have some interesting options, reasonable use, can give us unexpected consequences. One of the "-M" options can be created to create HTML reports that are useful in practical applications. Let's take a look at some of the options for Sql*

Label:From:http://soft.doit.com.cn/article/2012/0105/2850851.shtml --Addition --plus 1 yearsSELECT sysdate,add_months (sysdate,12) from DUAL;--Add JanuarySELECT sysdate,add_months (sysdate,1) from DUAL;--plus 1 weeksSELECT Sysdate,to_char (sysdate+7, ' Yyyy-mm-dd HH24:MI:SS ') from DUAL;--plus 1 daysSELECT Sysdate,to_char (sysdate+1, ' Yyyy-mm-dd HH24:MI:SS ') f

1. Open SQL Plus login directly, require username and passwordStart-"program-" oracle-"Application development-" SqlplusMy computer is "start"-"oracle-oradb11g_home1"-"Application Development"-"SQL Plus"After the database installation is complete, there are two system-level users:System default password: ManagerSYS def

Tags: Oracle time add_months interval1, Function: Add_months (Date,integer)--Add the specified time to a few monthsFor example:SELECT add_months (sysdate, 1) from DUAL; -The current time plus 1 months, that is, one months after the time. SELECT add_months (sysdate,-1) from DUAL; --The current time minus 1 months, that is, one months ago.2, add and subtract a time for the sysdate.For example:SELECT sysdate +

Label:Oracle -built table names and field names are automatically converted to uppercase. Double quotation marks are case-sensitive in Oracle ,Oracle is case-sensitive, and all caps are default when double quotes are not used. Many people may mistakenly think that Oracle is case-insensitive, because when we write query statements, the case does not matter, the re

(SAL),Count (*), COUNT (Job), COUNT (Distinct (job)),Sum (SAL) from the EMP group by DEPTNO;2) Department 30 maximum wage, minimum wage, total number, number of jobs, number of jobs and sum of wagesSelect Deptno, Max (ename), Max (SAL),Min (ename), Min (Sal),AVG (SAL),Count (*), COUNT (Job), COUNT (Distinct (job)),Sum (SAL) from the EMP group by DEPTNO have deptno=30;3.stddev returns the standard deviation of a set of valuesSelect Deptno,stddev (SAL) from the EMP group by DEPTNO;Variance return

'- timestamp ' 2014-03-11 13:55:29.000 ') year to MONTH from dual Select (timestamp ' 2015-04-10 14:52:19.000 '- timestamp ' 2014-03-11 13:55:29.000 ') Day (3) To SECOND from dual Once we have the time interval, we can extract the components of the time interval through the EXTRACT function. [SQL]View PlainCopy Select EXTRACT (Year from (date ' 2015-04-10 ' – date ' 2014-03-11 ') year to MONTH) from dual S

Requirements: There is a column name, VARCHAR2 type, the content is as followsThe above is sorted by the order by name, but not the result we wantNow you need to sort by numbers onlyFirst step: Extracting numbersSince the number has a two-bit one, it's not good to intercept with substr.We can use the regexp_substr function to extract substrings from a string using a regular expression.REGEXP_SUBSTR (Name, ' [0-9]+ ')second step, convert the number of the varchar type to a number of type intCAST

Label:Select User_sequence.nextval Form DualThe above attributes describe:keyproperty= "id": a property in a classOrder: Build Policy: (insert into before or after execution): default is After executionSequence in the User_sequence:oracleTo create a sequence:Create sequence User_sequenceStart with 1Increment by 1NomaxvalueMinValue 1NocycleCache 10;MyBatis (Oracle) How to use the primary key automatically plus