Archives: 06/28/2010

“Special copy” context menu command (Pl/Sql Developer)

IF YOU ARE USING PL/SQL DEVELOPER TO WIRTE SQL AND PL/SQL CODE THAT YOU SUBSEQUENTLY WANT TO USE IN OTHER TOOLS, IT MAY BE THAT YOU NEED THE CODE IN A SLIGHTLY DIFFERENT FORMAT. Let us assume that you wrote and tested a SQL statement like this in PL/SQLDeveloper: select deptno, sum (sal) mgr_sal from…

How to import data from file (Pl/Sql Developer)

PL/SQL Developer Tools -> Text Importer –> Select a data file to import –> Select matched table

How to create a bootable usb drive (Unetbootin)

Go to Unetbootin n.b: prima di partizionare il computer, lanciare un defrag

Troubleshoot TCP/IP conectivity

Strumenti di base: Diagnostica di rete in linea e supporto tecnico [Network Diagnostics in Help and Support]: [premere F1] Contiene iInformazioni dettagliate sulla configurazione della rete e sui risultati di verifiche automatizzate. Altre wizard sono disponibili nel Pannello di controllo in Sistema e Sicurezza voce Trova e risolvi problemi. Cartella connessioni di rete [Network Connections…

How to force index Oracle hint

Oracle provides a SQL hint to force a full-index scan. The cost-based optimizer will make the decision about whether to invoke the fast full-index scan in accordance with the table and index statistics. You can also force a fast full-index scan by specifying the index_ffs hint: es:   SELECT /*+ index(t index_name) */  field1, field2, fieldN…

How to use HttpHandler in Asp.Net

DOWNLOAD FILE DI TESTO 1) WEB.CONFIG: <system.web> <httpHandlers> <add verb=“GET” path=“corrispettivoTelematico.aspx” type=“corrispettivoTelematico“/> </httpHandlers> </system.web> 2) APP_CODE (corrispettivoTelemarico.cs) : public class corrispettivoTelematico: IHttpHandler { public corrispettivoTelematico(){} public void ProcessRequest(HttpContext context) { HttpApplication app = context.ApplicationInstance; app.Response.Clear(); app.Response.ContentType = “text/plain”; app.Response.AddHeader(“Content-Disposition”, “attachment; filename=”nomefile.txt”); FileContent = “…..”; app.Response.Write(FileContent); context.ApplicationInstance.CompleteRequest(); } public bool IsReusable { get { return true;…

How to use Delegate in asp.net

1) Evento che scatta nella MASTERPAGE padre forza esecuzione funzione nel figlio: MASTERPAGE       public delegate void MyDelegate(string param1); public partial class MasterPage : System.Web.UI.MasterPage {          public event MyDelegate myFunc;    protected void Page_Load(object sender, EventArgs e) {   string myParam1 = “dddd”;   this.myFunc(myParam1);      } } CHILDPAGE…

iText PDF tutorial

Go to PDF file

C# 4.0’s PDF book

Go to PDF file

Insert/Update command using statement

ORACLE MERGE CLAUSE (EX1) MERGE INTO sigo_magmov m USING (select l.vl_costo costo_lotto, m.rowid fede from sigo_magmov m inner join sigo_lotti l on m.nr_lotto = l.nr_lotto where cd_causale = 76 and m.dt_tem >= ‘20120101’ and not m.nr_lotto is null and m.nr_lotto = 73840) magmov_lotti ON (m.rowid = magmov_lotti.fede) WHEN MATCHED THEN UPDATE SET vl_costo = costo_lotto;…

Go Top