vadimtropashko.wordpress.com

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, ...

soulphysics.org

Get Started Playing Ehrenfeucht-Fraisse Games – Soul Physics

http://www.soulphysics.org/2009/02/get-started-playing-ehrenfeucht-fraisse

Soul Physics Google Plus. Philosophical Foundations of Physics. Get Started Playing Ehrenfeucht-Fraisse Games. Ehrenfeucht-Fraisse games are a very useful method in logic, when you’re trying to figure out if two models are elementarily (logically) equivalent or not. This may be of special interest to philosophers of science, since the ’empirical equivalence’ of two models is much better characterized by. Than it is by. At any rate, I’ve written a friendly introduction to this method ( PDF. Two L-structur...

soulphysics.org

Where the material conditional gets its truth conditions – Soul Physics

http://www.soulphysics.org/2009/12/where-material-conditional-gets-its

Soul Physics Google Plus. Philosophical Foundations of Physics. Where the material conditional gets its truth conditions. Oh, the material conditional. Some love it, some hate it. But can we all agree that explaining it to the uninitiated. Is a perennial headache? If you’ve taught baby-logic, you know how this goes. There you are, giving a just lucid. Shpeel on deductive systems, until you get to this part:. And the tires screech to a halt. Why. Are those bottom two values True? Why should it be that A.

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'.

davidsrakugaki.blogspot.com

David's Rakugaki: SQL and the Third Manifesto

http://davidsrakugaki.blogspot.com/2011/02/sql-and-third-manifesto.html

Random code snippets etc. Saturday, February 19, 2011. SQL and the Third Manifesto. Dave Voorhi developed an implementation of Darwen and Date's "Tutorial D", called "Rel". I decided to download it and play around to see how it works. Coming from the SQL world, I thought I'd give some brief comparisons. To demonstrate the differences, I will create a "zoo" database in MySQL and Tutorial D. The database consists of animals, which are members of a zoo. Each animal must also belong to a species.

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.