sqlexpertese.blogspot.com
SQL Expert: May 2009
http://sqlexpertese.blogspot.com/2009_05_01_archive.html
Tuesday, May 19, 2009. In the following way we can know the name of the current month:. SQL select to char (SYSDATE, 'month') from dual mon. In principle there is nothing strange. But looking at the length of the result is a surprise: it's much bigger than we expected! SQL select length (to char (SYSDATE, 'month') from dual Leng. SQL select length (to char (SYSDATE, 'fmmonth') from dual Leng. Monday, May 18, 2009. SQL select to char(fecalt,'RRRR') "year",. 2 to char(fecalt,'MM') "month",. But by chance, ...
sqlexpertese.blogspot.com
SQL Expert: EXTRACT command
http://sqlexpertese.blogspot.com/2009/05/extract-command.html
Monday, May 18, 2009. Developers often find that we must use the data from the form such as a date would Wharehouse. While there is no choice in doing so because it is data and statistics to be queried often, it must be taken into account the performance, especially when the database is very large and/or have many users connected and on the contrary we have many resources. So a small improvement in the code is always welcome. SQL select to char(fecalt,'RRRR') "year",. 2 to char(fecalt,'MM') "month",.
sqlexpertese.blogspot.com
SQL Expert: Have a table of a million records
http://sqlexpertese.blogspot.com/2009/05/have-table-of-million-records.html
Thursday, May 7, 2009. Have a table of a million records. To have a table of a million records is enough to:. SQL select rownum as id. Subscribe to: Post Comments (Atom). PARTITION BY versus GROUP BY. Utilities of CONNECT BY. How to find information with COLLECT. ORDER BY as we needed. Have a table of a million records. Oracle SQL Developer Collaborative Blog. Oracle SQL und PL/SQL . Relational Databases and SQL. René Nyffenegger on Oracle.
sqlexpertese.blogspot.com
SQL Expert: PARTITION BY versus GROUP BY
http://sqlexpertese.blogspot.com/2009/05/partition-by-versus-group-by.html
Wednesday, May 13, 2009. PARTITION BY versus GROUP BY. The practice of programming, we often find ways to write codes that are better than others. Many cases can not always remember the best. It also found that the differences are very little like the subject matter of this post: the difference (or similar) in the GROUP BY clause and PARTITION BY. SQL select ttf.REM IDEREM, ttf.SMF NUMSMF,. 2 comNUMCOC, count(com.NUMCOC) as num. 3 from TGTR SMSTTF ttf, TGTR TRAMITE TRF trf,. 12 com.LSTTIPCOC = 'TL'.
sqlexpertese.blogspot.com
SQL Expert: how to find information with COLLECT
http://sqlexpertese.blogspot.com/2009/05/trobar-informacio-amb-collect.html
Friday, May 8, 2009. How to find information with COLLECT. To find what is a table column can do the following:. SQL SELECT column name,. 2 COLLECT(table name) AS taula. 3 FROM user tab columns. 4 WHERE column name = 'FECENV'. 5 GROUP BY column name;. SYSTPaU AVf1HDNjgQAB/AQAnvA= ('T DETALLE DEL', 'T AFILIACION TGS', 'T CABECERA IRP ANU', 'T DETALLE COT TGS', 'T DETALLE IRP ANU', 'T FICHERO FAN DET', 'T PARTE TGS', 'T DETALLE DEL', 'T FICHERO AFI DET', 'T DETALLE FIC HAC', 'T DELTA', 'T CONTRATO INE').
sqlexpertese.blogspot.com
SQL Expert: ORDER BY as we needed
http://sqlexpertese.blogspot.com/2009/05/order-by-as-we-needed.html
Thursday, May 7, 2009. ORDER BY as we needed. We see how to sort data as we needed not only in ascending (for defete) or descending. We have for example the following query:. SQL select distinct object type. 2 from user objects. 3 order by object type. Now I want object type beginning with the letter P to go first, then those that start with T, and finally the other ascending order by default:. SQL select distinct object type, substr(object type,1,1) lletra. 2 from user objects. Utilities of CONNECT BY.
sqlexpertese.blogspot.com
SQL Expert: WITH command
http://sqlexpertese.blogspot.com/2009/05/with-command.html
Friday, May 15, 2009. We show for each company the total number of employees and amount of total payroll:. SQL select emp ideemp,. 2 count(*) num,. 5 group by emp ideemp. EMP IDEEMP NUM IMPORT. 183536 61 55026.66. 424730 185 180439.46. 296842 67 52364.82. 2182 2205 42545281.7. 139399 1661 1539903.89. 268299 53 42102.51. 191034 17 321411.43. We now companies with more than one hundred employees and what is the total amount of payroll for each of these companies:. SQL select emp ideemp,. 2 count(*) num,.
sqlexpertese.blogspot.com
SQL Expert: Oracle data flashback
http://sqlexpertese.blogspot.com/2009/05/oracle-data-flashback.html
Thursday, May 14, 2009. 11:23:48 SQL select count(*) from vtemporal;. 11:23:52 SQL insert into vtemporal. 11:24:06 2 values (1,'sdhgfh');. 11:24:15 SQL commit;. 11:24:20 SQL flashback table vtemporal to timestamp systimestamp-interval '1' minute;. 11:24:35 SQL select count(*) from vtemporal;. Subscribe to: Post Comments (Atom). PARTITION BY versus GROUP BY. Utilities of CONNECT BY. How to find information with COLLECT. ORDER BY as we needed. Have a table of a million records. Oracle SQL und PL/SQL .
sqlexpertese.blogspot.com
SQL Expert: DATE format
http://sqlexpertese.blogspot.com/2009/05/date-format.html
Tuesday, May 19, 2009. In the following way we can know the name of the current month:. SQL select to char (SYSDATE, 'month') from dual mon. In principle there is nothing strange. But looking at the length of the result is a surprise: it's much bigger than we expected! SQL select length (to char (SYSDATE, 'month') from dual Leng. SQL select length (to char (SYSDATE, 'fmmonth') from dual Leng. If there is a change in the search engine algorithms, it is also up to the service provider to keep a. You could ...
