vvx 1500

1. Select * from EMP; 2. Select Empno, ename, job from EMP; 3. Select empno number, ename name, job work from EMP; 4. Select Job from EMP; 5. Select distinct job from EMP; 6. Select distinct empno, job from EMP;Note: Because the employee number is not duplicated, it is not possible to eliminate duplicate columns by proving that all the columns are not duplicated at this time. 7. Query the employee's number, name, work, but display the format: 7369 employee, name is: Smith, work is: clearSe

Oracle query syntax 1. Select * from EMP; 2. Select empno, ename, job from EMP; 3. Select empno number, ename name, job from EMP; 4. Select job from EMP; 5. Select distinct job from EMP; 6. Select distinct empno, job from EMP;Note: Because employee numbers are not repeated, it is proved that all columns are not repeated at this time, so repeated Columns cannot be eliminated. 7. query the employee ID, name, and work, but the displayed format is: 7369 employee, name: Smith, and work: ClearSelect

This article summarizes the good, from: http://hi.baidu.com/to_wait/blog/item/3e855931a5a51717eac4af22.html The TCP/IP protocol involves four layers: link layer, network layer, transmission layer, and application layer.The Ethernet data frame is at the link layer.IP packageAt the network layerTCP or UDP PacketsAt the transport layerData in TCP or UDP(Data) at the application layerTheirLink isData frame {IP packet {TCP or UDP packet {data }}}-------------------------------------------------------

1. Select* From EMP; 2. Select empno, ename, job from EMP; 3. Select empno number, ename name, jobWorkFrom EMP; 4. Select job from EMP; 5. Select distinct job from EMP; 6. Select distinct empno, job from EMP;Note: Because employee numbers are not repeated, it is proved that all columns are not repeated at this time, so repeated Columns cannot be eliminated. 7.QueryEmployee ID, name, work, but displayed in the format of: 7369 employee, name: Smith, job: ClearSelect ':' | empno | 'employee, name:

1. select * from emp; 2. select empno, ename, job from emp; 3. select empno number, ename name, job from emp; 4. select job from emp; 5. select distinct job from emp; 6. select distinct empno, job from emp;Note: Because employee numbers are not repeated, it is proved that all columns are not repeated at this time, so repeated Columns cannot be eliminated. 7. query the employee ID, name, and work, but the displayed format is: 7369 employee, name: smith, and work: clearSelect ':' | empno | 'employ

I. CAT4006 engine module WS-X4013 configuration listThese include: Basic settings, VLAN configuration, Channel configuration, and port Image Port 1/2 to connect to gigabit IDS) Cisco Systems, Inc. Console Enter password:CAT4006> enable Enter password:CAT4006> (enable)..................................................................................... Begin!# ***** NON-DEFAULT CONFIGURATION *****!!# Time: Mon Apr 11 2005, 22:02:13!# Version 6.1 (1)!!# System web interface version (s)Set password

I recently learned about UDP programming and got a big head. I have found a lot of materials and consulted many colleagues. I think the following information is well written, so I collected it for reference.1. During UDP programming, the most common question is how many bytes are sent at a time?Of course, there is no unique answer. The answer to this question varies with the requirements of different systems.For example, if you want to analyze the situation of sending chat messages like ICQ, you

Connection query category 1. Self-join query, connecting to the same table2. internal join query, [divided into: Natural join (that is, equivalent join removes duplicate rows, or select the column to be represented after select, instead of using "*" to list all columns), equijoin (that is, use "=" for logical judgment after where), non-equijoin] [During inner join, the returned result set is only the rows that meet the query and connection conditions .]3. External Connection query, which can

. Compare the transmission time of A 3.4G ISO from server A scp to server B.Data goes through the Business Link and bonding technology is not used.############# No Binding ##############[Root @ rac-node01 tmp] # time scp rhel-5.1-server-x86_64-dvd.iso 10.168.0.202:/tmpRoot@10.168.0.202's password:Rhel-5.1-server-x86_64-dvd.iso 100% 3353 MB 44.1 MB/s 0 Real 1m20. 105 sUser 0m34. 752 sSys 0m11. 002 s############# FastThe data follows the heartbeat link and uses the bonding technology. The mode is

', 13000, NULL, 10);INSERT into EMP VALUES (1011, ' Jacky Chow ', ' clerk ', 1008, ' 2007-05-23 ', 11000, NULL, 20);INSERT into EMP VALUES (1001, ' ganning ', ' clerk ', 1013, ' 2000-12-17 ', 8000, NULL, 20);/* insert Salgrade table Data */INSERT into Salgrade VALUES (1, 7000, 12000);INSERT into Salgrade VALUES (2, 12010, 14000);INSERT into Salgrade VALUES (3, 14010, 20000);INSERT into Salgrade VALUES (4, 20010, 30000);INSERT into Salgrade VALUES (5, 30010, 99990);/*Insert Stu Table data*/INSER

] # time scp rhel-5.1-server-x86_64-dvd.iso 192.168.0.202:/tmpRoot@192.168.0.202's password:Rhel-5.1-server-x86_64-dvd.iso 100% 3353 MB 21.4 MB/s Real 2m47. 812 sUser 0m34. 965 sSys 0m19. 421 s[Root @ rac-node01 tmp] # netstat-I # @ ReceiveKernel Interface tableIface MTU Met RX-OK RX-ERR RX-DRP RX-OVR TX-OK TX-ERR FlgBond1 1500 0 5123831 2045 0 5138747 0 0 0 BMmRUEth0 1500 0 2847 0 0 0 703 0 0 0 BMRUEth2

I believe that the 99 SQL statements are handled, and the basic Oracle test is just like playing (the most comprehensive and most typical entry-level Oracle query statements in history) 1. select * from emp;2. select empno, ename, job from emp;3. select empno number, ename name, job from emp;4. select job from emp;5. select distinct job from emp;6. select distinct empno, job from emp;Note: Because employee numbers are not repeated, it is proved that all columns are not repeated at this time, so

UDP Packet Size Problem Post from: http://blog.csdn.net/buptzwp/archive/2009/12/22/5055487.aspx During UDP programming, the most common question is how many bytes are sent at a time? Of course, there is no unique answer. The answer is different from the requirements of different systems. Here we only analyze the situation of sending chat messages like ICQ, in other cases, you may be able to get some help:First, we know that TCP/IP is generally considered as a layer-4 protocol system, includin

Problem: PPTP is used to build a VPN Server on the Linux platform. After dial-in, the Intranet FTP is accessed. downloading files is extremely slow. When using PPTP as a gateway to access the Internet, most websites except Baidu are extremely slow to access, almost inaccessible. Solution: Add-I forward-P TCP -- SYN to the * filter table of iptables of the Linux service where PPTP is located.-I ppp +-J tcpmss -- Set-MSS 1356/sbin/iptables-I forward-p tcp -- syn-I PPP +-J tcpmss -- Set-MSS 1356 Ca

EMP VALUES (1011, ' Jacky Chow ', ' clerk ', 1008, ' 2007-05-23 ', 11000, NULL, 20);INSERT into EMP VALUES (1001, ' ganning ', ' clerk ', 1013, ' 2000-12-17 ', 8000, NULL, 20);/* insert Salgrade table Data */INSERT into Salgrade VALUES (1, 7000, 12000);INSERT into Salgrade VALUES (2, 12010, 14000);INSERT into Salgrade VALUES (3, 14010, 20000);INSERT into Salgrade VALUES (4, 20010, 30000);INSERT into Salgrade VALUES (5, 30010, 99990);/*Insert Stu Table data*/INSERT into ' Stu ' VALUES (' 1 ', '

Detailed parsing of Ifconfig commands 1. test environment: [Root @ lvskeep ~] # Cat/etc/redhat-release CentOSrelease 5.4 (Final) [Root @ lvskeep ~] # Uname-r 2.6.18-164. el5 [Root @ lvskeep ~] # Ifconfig # Local Network Configuration Eth0 Link encap: Ethernet HWaddr 00: 0C: 29: BC: 7A: 11 Inet addr: 10.0.0.30 Bcast: 10.0.0.255 Mask: 255.255.255.0 Inet6 addr: fe80: 20c: 29ff: febc: 7a11/64 Scope: Link Up broadcast running multicast mtu: 1500 Metric: 1

ENAME JOB MGR HIREDATE SAL COMM ------------------------------------------------------------------------- DEPTNO ---------- 7369 smith clerk 7902-12-80 800 20 7499 allen salesman 7698 20-2 months-81 1600 300 30 7521 ward salesman 7698 22-2 month-81 1250 500 30 EMPNO ENAME JOB MGR HIREDATE SAL COMM ------------------------------------------------------------------------- DEPTNO ---------- 7566 jones manager 7839 2975-81 20 7654 martin salesman 7698 28-9 month-81 1250 1400 30 7698 blake ma

addresses; three or more HAIP addresses; and four HAIP addresses ), evenly distributed on private network cards. Case:1. view the HAIP Resource Status$ Crsctl stat res-t-initNAMETarget state server STATE_DETAILS Cluster ResourcesBytes -------------------------------------------------------------------------------------------------Ora. cluster_interconnect.haipONLINE node2 12. view the HAIP address and distribution.# Ifconfig-Eth1 Link encap: Ethernet HWaddr 00: 0C: 29: 4B: B7: 66Inet addr: 192