daily sunspot number data

Create or Replace procedureProc_p_abc isV_sumday Number:=0; I Number:=0; V_calendar_date Number:=NULL; V_day Number:=NULL;begin SelectTo_date (To_char (Sysdate,'RRRR'),'yyyy')-To_date (To_char (Sysdate,'RRRR')-1,'yyyy') intoV_sumday fromdual; whileIV_sumday LOOP--begin SELECTTo_char (TRUNC (Sysdate,'y')+I'YYYYMMD

first, clean up the daily backup of the data table 1, background: the system table space occupancy rate has exceeded 90%. So do a related garbage data to clean up the work. 2, the query needs to clean up the list: Because the day-to-day operation of the database, often do some backup tables. Consult with the previous system administrator, who usually adds a dat

count count(2周内)2015-12-01 0 02015-11-29 0 02015-11-30 1 12015-11-31 0 12015-12-01 1 22015-12-02 2 42015-12-03 3 7 ` The purpose is to take out the same day registration and push forward 14 days of registration number The current practice is to cycle count` $lasttime=strtotime(date("Y-m-d",time()))-14*3600*24;$firsttime=strtotime(date("Y-m-d",time()))+3600*24;$result = array()for($i=13;$i>=0;$i--){ $first=date

Ask a database question. there is a table containing the data stored every day and how to retrieve the number of data entries per month. This is the ec_ip_article table, and iptime is the daily timestamp. Is there a simple way to get an SQL statement every month, and then count the

Our demand for this example is to write a script that runs at 0 o ' Day. This script extracts data from a database that is updated in real time. Run an Excel table every day, showing the difference between 0 points of the day and yesterday 0 o'clock. In fact, a very simple demand, the key problem encountered is the amount of data. The amount of data in this case

The error message indicates that the maximum memory is exhausted. how can this problem be solved? The following small series will solve the problem of memory depletion during a large number of data loops in PHP. For more information, see the following problems encountered during the development of a PHP program: PHP Fatal error: Allowed memory size of 268 435 456 bytes exhausted The error message shows tha

How to solve the problem of memory depletion during a large number of data loops in PHP Recently I encountered the following error when developing a PHP program: PHPFatalerror:Allowedmemorysizeof268435456bytesexhausted The error message shows that the maximum allowed memory is exhausted. I was surprised at first when I encountered such a mistake, but it was not surprising in the twinkling of a

Solve the problem of memory depletion during a large number of data loops in PHP. php is exhausted. To solve the problem of memory depletion during a large number of data loops in PHP, php depletion recently encountered the following problems when developing a PHP program: PHPFatalerror: allowedmemorysizeof2684354 solv

The error message indicates that the maximum memory is exhausted. How can this problem be solved? The following small series will solve the problem of memory depletion during a large number of data loops in PHP. For more information, see the following problems encountered during the development of a PHP program: PHP Fatal error: Allowed memory size of 268 435 456 bytes exhausted The error message shows tha

1, first login to the micro-trust public platform, in the left of the statistics inside the user analysis 2, in the user analysis can see the user growth and user attributes, and can see yesterday's key index 3, the page below also has the number of trends and daily details of the data, if you want to retain the convenience of publicity, can lead