robboek.com
UPDATE Statements and Indexes
http://robboek.com/2009/05/29/update-statements-and-indexes
UPDATE Statements and Indexes. May 29, 2009. Middot; 2 comments. I ran into a database earlier this week with a lot of stored procedures that look like this:. FirstName, LastName =. LastName, EmailAddress =. Every table had similar CRUD procedures that had been generated. If any data in the Users table changed, say a user updated their email address, this procedure would handle the update. Is this a good idea? That don’t need to be updated. The reason? Let’s take a look at the following table:. If we kn...
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.
SOCIAL ENGAGEMENT