KUBILAYKARA.BLOGSPOT.COM

expertsql.blogspot.com

Expert en SQL: ORDER BY segons com ens convingui

http://expertsql.blogspot.com/2009/05/order-by-segons-com-ens-convingui.html

Dijous, 7 de maig de 2009. ORDER BY segons com ens convingui. Veiem com poder ordenar les dades segons com ens convingui i no només de forma ascendent (per defete) o descendent. Tenim per exemple la següent consulta:. SQL select distinct object type. 2 from user objects. 3 order by object type. I ara volem que els object type que comencin per la lletra P vagin en primer lloc, a continuació els que comencin per T, i finalment els altres ordenats per defecte ascendentment:. 2 from user objects.

expertsql.blogspot.com

Expert en SQL: Com trobar informació amb COLLECT

http://expertsql.blogspot.com/2009/05/how-to-find-something-with-collect.html

Divendres, 8 de maig de 2009. Com trobar informació amb COLLECT. Per poder trobar en quines taules es troba una columna concreta podem fer el següent:. 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;. Publica un comentari a l'entrada. Subscriure's a: Comentaris del missatge (Atom). Format d’una variable DATE. La millora amb EXTRACT. PARTITION BY versus GROUP BY. Utilitats del CONNECT BY. René Nyffenegger on Oracle.

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.

expertsql.blogspot.com

Expert en SQL: Format d’una variable DATE

http://expertsql.blogspot.com/2009/05/format-duna-variable-date.html

Dimarts, 19 de maig de 2009. Format d’una variable DATE. De la següent manera podem saber el nom del mes actual:. SQL select to char(SYSDATE,'month') mon from dual. En principi no hi ha res d’estrany. Però si analitzem la longitud del resultat en trobem en una sorpres: és molt més gran del que esperàvem! SQL select length(to char(SYSDATE,'month') leng from dual. SQL select length(to char(SYSDATE,'fmmonth') leng from dual. Publica un comentari a l'entrada. Subscriure's a: Comentaris del missatge (Atom).