Archives: 12/31/2011

ECOMMERCE PLUGIN

Esistono diverse soluzioni per estendere wordpress e farlo diventare un vero e proprio ecommerce, tra queste molti plugin suddivisibili in 3 categorie: Gratuito: plugin gratuito Freemium: plugin con funzionalità avanzate a pagamento A pagamento: Plugin totalmente a pagamento Quale plugin usare? Il miglior plugin è quello che risponde alle esigenze del tuo negozio online. Devi conoscere…

DOWNLOAD FILE FROM URL

This is a script that downloads a binary file using XMLHTTP and saves it using an ADO stream. This is handy for nightly downloads and will work within SQL Server DTS packages. main() Sub main() countsi=0 countno=0 For i = 10 To 11 For j=1 To 12 For k=1 To 31 path = “http://www.mysite.com” &…

FLASHBACK TECHNOLOGY

Oracle Flashback Technology is a group of Oracle Database features that that let you view past states of database objects or to return database objects to a previous state without using point-in-time media recovery. With flashback features, you can do the following: • Perform queries that return past data • Perform queries that return metadata…

SELECT INTO CLAUSE

The SELECT INTO clause of SQL is used to retrieve one row or set of columns from the Oracle database. The SELECT INTO is actually a standard SQL query where the SELECT INTO clause is used to place the returned data into predefined variables. – An issue with using SELECT INTO statement is that SELECT…

HOW TO GET DDL METADATA

In our oracle database 10g there was a schema called “CUSTOMER” that owned a lot of tables, sequences, indexes, procedures etc. I want to recreate the “CUSTOMER” schema from scratch but unfortunately the scripts are lost and i can’t really go on one object after another to find the script and create it. I just…

OVER STATEMENT (TOP OR LIMIT CLAUSE EQUIVALENT)

Fetching a limited number of rows from Oracle is much harder than SQL Server or MySQL. This article explains how to do it using a subquery and the row_number function: – In SQL SERVER, you can use the keyword TOP to restrict the number of rows returned by your query, like this: SELECT TOP 10,…

Go Top