,=3000 when sale value =1000 translation to a , if other values are translated as other;SQL is as follows:Select Monthid,decode (sale,1000, ' D ', +, ' C ', +, ' B ', 4000, ' A ', ' other ') sale from outputSpecial cases:If you are comparing with only one valueSelect Monthid, decode (sale, NULL, '---', sale) sale from outputAnother: Decode can use other functions, such as the NVL function or the sign () function, etc.Compare size function Signfunction Syntax:Sign (n)Function Description:Take the
job= ' ANALYST ') as Analyst_job,3 (select sum (SAL) from EMP where Emp.deptno=e.deptno and job= ' clerk ') as Clerk_job,4 (select sum (SAL) from EMP where Emp.deptno=e.deptno and job= ' MANAGER ') as Manager_job,5 (select sum (SAL) from EMP where Emp.deptno=e.deptno and job= ' President ') as Persident_job,6 (select sum (SAL) from EMP where Emp.deptno=e.deptno and job= ' salesman ') as Salesman_job7 from EMP E8 GROUP BY E.deptno;DEPTNO analyst_job clerk_job manager_job persident_job salesman_j
(default value) End If Note: The default value can be either the column name you want to select, or the other values you want to define, such as other; To illustrate: Now defines a table named output, where two column definitions are Monthid (VAR) and sale (number type), translated to d,=2000 when translated to c,=3000 when sale value =1000 translation to a , if other values are translated as other; SQL is as follows: Select Monthid, decode (sale,1000, ' D ', +, ' C ', +, ' B ', 4000, ' A ', '
value)End IfNote: The default value can be either the column name you want to select, or the other values you want to define, such as other;To illustrate:Now defines a table named output, where two column definitions are Monthid (VAR) and sale (number type), translated to d,=2000 when translated to c,=3000 when sale value =1000 translation to a , if other values are translated as other;SQL is as follows:Select Monthid, decode (sale,1000, ' D ', +, ' C ', +, ' B ', 4000, ' A ', ' other ') sale f
coordsize value dynamically. Note that the reduced value is equal to the enlarged value, and the increased value is equal to the reduced value. You can refer to the following script:
Var xx= 6000;
Var yy = 6000;
Function zoom (h)
{
Group1.coordsize = xx/h + "," + yy/h;
}
In the preceding xx, yy refers to the coordsize value in the default state. Use zoom (n) when calling this function, where n is a multi
Cisco System Inc. identifies Cisco switch models in the network industry. With its IOS (Internet Operating System), Cisco is an absolute leader in the multi-protocol router market. Currently, nearly 80% of routers on the Internet come from Cisco. In fact, Cisco also has a full range of network devices, including hubs, switches, access servers, hardware and software firewalls, and network management software. Cisco pays great attention to the tracking of New Technologies. Through a series of coop
query
The is null keyword can be used to determine whether the field value is null ). If the field value is null, the query condition is met and the record is queried. If the field value is not a null value, the query conditions are not met. The syntax rules are as follows:IS [NOT] NULL"NOT" is an optional parameter, and "NOT" indicates that the condition is met when the field is NOT null.Is null is a whole and cannot be replaced with "= ".
3. use aggregate functions to query data
3.1 groupAs f
The is null keyword can be used to determine whether the field value is null ). If the field value is null, the query condition is met and the record is queried. If the field value is not a null value, the query conditions are not met. The syntax rules are as follows:IS [NOT] NULL"NOT" is an optional parameter, and "NOT" indicates that the condition is met when the field is NOT null.Is null is a whole and cannot be replaced with "= ".3. use aggregate functions to query data 3.1 and group by gro
.
Errors in file/soft/oracle/diag/rdbms/a1qzdb/a1qzdb1/trace/a1qzdb1_arc2_15073292.trc:
ORA-27037: unable to obtain file status
Ibm aix risc System/6000 Error: 2: No such file or directory
Additional information: 3
Renewal Point 2:
Tue Jul 31 03:02:50 2012
Control file backup creation failed.
Backup target file size found to be zero.
Errors in file/soft/oracle/diag/rdbms/a1qzdb/a1qzdb2/trace/a1qzdb2_ckpt_760261_trc:
ORA-27037: unable to obtain file st
1. Before calculating the denominator, it is to calculate the likelihood ratio of the observed data t_data and all other particles of the observed area of each particle to be updated. The energy of other particles is more diffuse than the past energy is compared;2, but in fact phd-tbd words will be all lattice as the target, that is, at most each lattice to do a potential target or have particles there, so the calculation should also be the potential target near the observation data and randomly
Use SOCKET directly as the client and UDP
ClientCode:
DEMO code Using System; Using System. Collections. Generic; Using System. LINQ; Using System. text; Using System. net. Sockets; Using Tcplabcommon; Using System. net; Namespace Udplabclient1 { Class Program {Static Void Main ( String [] ARGs) {Socket socket = New Socket (addressfamily. InterNetwork, sockettype. dgram, protocoltype. UDP); endpoint = New Ipendpoint (IPaddress. parse (" 127.0.0.1 ") 6
The TCP-based socket programming server program process is as follows:
1. Create a socket
Socketsocksrv = socket (af_inet, sock_stream, 0 );
2. Bind the socket to the local address and port
Sockaddr_inaddrsrv;
Addrsrv. sin_addr.s_un.s_addr = htonl (inaddr_any); // converts a u_long value to a network byte sequence.
Addrsrv. sin_family = af_inet;
Addrsrv. sin_port = htons (6000 );
BIND (socksrv, (sockaddr *) addrsrv, sizeof (sockaddr); // bind the c
client side.
We know that from client machine (192.168.56.101), the IP address 10.10.1.11 is non routable. But now if we issueHttp: // 10.10.1.11/In Firefox browser, its shows the 10.10.1.11 Apache server webpage.
Advantage:
One proxy server is enough to access the all services of remote machine and its sub-Net Services
Disadvantage:
We need to configure the proxy settings in client application, if application doesn't support the proxy then we can't access the service.
Local port forwarding
A + B per line
Description
Sometimes you may encounter this problem: You have a table showing the income of everyone in December, January, and February. The table is as follows:Name dec Jan ($)CM 200 314Ly 2000 332Qqm 6000 333Zym 5000 333BP 30 12
You need to know the total revenue of each person in the past three months. Then you need to add the number representing the income in the Table. Write a program to solve this problem.
Input
The input contain
accept the complete data packet every time.
Different databases can be connected to one machine, while the client is transparent.
Supports online reconfiguration without restarting
Only V3 protocol is supported. Therefore, the backend version must be greater than or equal to 7.4.
Start using pgbouncer
Basic INI file configuration (Suppose we have created a new INI File/usr/local/pgsql/CONF/pgbouncer. INI)
1. Add the connection string of the target database, which indicates the backend d
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.