Preface: Generally do data statistics write stored procedures when I believe many friends have to deal with the date, this is my data processing, do statistics. At that time the request must show a date. Especially when the statistics of the week, especially disgusting, so I used to date the operation of the stored procedures in the SQL, to share with you. Hope to be able to be helpful to everybody. Not much nonsense, directly on the SQL.
Select A.* from (Select To_char (datetime, ' yyyy-mm ')
($ result );Break;Default:$ R = False;Break;}Return $ r;}/*************************************** **************************************** ****** Get the current record number (starting from 0)**************************************** **************************************** *****/Function CurRecNumber ($ result){$ R = $ this-> curRow [$ result];Return $ r;}/*************************************** **************************************** ****** Get the current row number (starting from 1)*******
Thinking Question: (Simulation Class tour collective leave), the school stipulates: For the class tour, the student submits the application form, must pass through the counselor, the Department director, the dean, the Headmaster signature confirmation can travel, now by you to design this business model simulates this demand, how should design?Answer: A very intuitive idea: I directly design a student class, an application for single class Requestnote, a counselor class, a Department director cl
This section of PHP to send mail code he took advantage of the PHP free mail send function mail to send, he will use two kinds of trial one is to determine whether the mail function is available, if the row on the use of it to send otherwise fsockopen to operate.*/
The code is as follows
Copy Code
Class Email{function email (){$this->__construct ();} function __construct (){@define (' CharSet ', ' GBK ');$this->set (Mail_server, Mail_port, Mail_user, Mail_pwd,mail_ty
Prefetch_abort:. Word prefetch_abort_ Data_abort:. Word data_abort_ Not_used:. Word not_used_ IRQ:. Word IRQ_ FIQ:. Word FIQ. Balignl 16, 0 xdeadbeef_ Text_base:. Word text_base. Globl _ armboot_start_ Armboot_start:. Word _ start. Globl _ bss_start_ Bss_start:. Word _ bss_start. Globl _ bss_end_ Bss_end:. Word _ endReset:/** Set the CPU to svc32 Mode*/Mrs r0, CPSRBic r0, R0, # 0x1fORR r0, R0, #0xd3Msr cpsr, R0Corresponding disassembly:00000000 [0xea000012] B 0x5000000004 [0xe59ff014] ldr pc, 0
Preface: Generally do data statistics write stored procedures when I believe that many friends have to deal with the date, which I was at that time to deal with the data, do statistical use. The date must be displayed when making the request. Especially on the week statistics, especially disgusting, so I used to date operation of the SQL in the stored procedure, to share with you. Hope to be able to help you. Not much nonsense, directly on the SQL.
Select A.* from (Select To_char (datetime, ' y
for the difference between these 3 functions, and is the most easily overlooked. See there are a lot of comparisons on this 3 functions on the web. These are rarely involved. What I'm going to say here is the difference between checking for variables that already exist.
code is as follows
nbs P;
$a =100; $b = ""; $c =null;nbs P //isset Check echo "Isset", "$a = $a", isset ($a)? " Define ":" Www.111cN.net undefine ", R
null.
Select * from perexl order by decode (danwei, null, 'unit is null', danwei)
Usage of standard rownum paging Query
Select * from (select c. *, rownum rn from personnel c) where rn> = 1and rn
Solution for sorting paging in oracle statement rownum
Select * from (select c. *, rownum rn from personnel c order by dat
different departments.
Select * from EMP order by job, deptno;
38 list the details of all departments allocated with the number of employees, even if the number of employees is 0.
Select * from Dept where deptno in (select distinct deptno from EMP)
Union
Select * from Dept where deptno not in (select distinct deptno from EMP)
39 list the minimum wage for various types of jobs.
Select job, min (SAL)
From EMP
Group by job;
40 list the minimum salaries of managers in each departmen
Base64 encodes binary data into four-byte readable characters per three bytes. The encoded characters are about 136.1% characters in length. Character range is A-Z A-Z 0-9 \ +. However, the encoded string is not suitable for URL transmission. The garbled characters after Chinese encryption are also caused by this reason: When the string is transmitted in the URL, the plus sign will be replaced with a space; a newline "\ n" is added for every 76 characters, which will be lost.
For example:Haha .
.
Select * From perexl order by deCODE (danwei, null, 'unit is null', Danwei)
-- Usage of standard rownum paging Query
Select * from (select C. *, rownum rn from personnel C) Where rn> = 1and rn
-- Solution for sorting paging in Oracle statement rownum
-- However, if order by is added, the data is incorrectly displayed.
Select * from (select C. *, rownum
Preface
React native (RN for short) is not here for its origins, advantages, installation and use. You can Google/Baidu on your own. I sorted out the notes recorded in the previous study of Rn and analyzed some technical ideas in the RN framework based on the RN source code. This is helpful for understanding and better
See link in the original: http://http//bubblexc.com/y2011/310/slightly revised.Straight, flatBefore talking about the super plane, let's talk about the straight line and the surface in Rn space.A point p and a nonnegative vector vin the given Rn space? Meet i=TV? +PThe set of point I is called a straight line in Rn space.T in the above formula is a
The ASE64 encoding converts binary data to four byte readable characters per three bytes, and the encoded character length is approximately 136.1%. The character range is a-Z a-Z 0-9 \ +. But the encoded string is not very suitable for the use of URL transmission, Chinese encryption after the garbled also many because of this cause: in the URL of the transfer when the + number will be replaced by a space, and every 76 characters will be added a newline "\ n", the line-break match will be lost.Fo
Full Mail Send class
Class SMTP
{
/* Public Variables */
var $smtp _port;
var $time _out;
var $host _name;
var $log _file;
var $relay _host;
var $debug;
var $auth;
var $user;
var $pass;
/* Private Variables */var $sock;
/* Constractor */ Function smtp ($relay _host = "", $smtp _port = +, $auth = False, $user, $pass) { $this->deb UG = FALSE; $this->smtp_port = $smtp _port; $this->relay_host = $relay _host; $this->time_out =//is used in Fsockopen () $this->auth = $auth;//auth $this->user =
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.