Database Administrator

Insert into tblsaudatable select distinct Firmnumber,Oowncode,'C','N' from sauda minus Select distinct cFirmnumber,cclientc...

Please check required Space on storage for DB FY1314 = 1.5  * Database size of last year database FY1213 And follow following steps to...

c:\> BatchSubstitute.bat "&Yourname" kshitij up78896.sql > up78896_new.sql ========== @echo off REM -- Prepare the Comma...

CREATE OR REPLACE TRIGGER email_nsef_bill AFTER insert on TBLLOCKTABLE DECLARE b VARCHAR2(3) := UTL_TCP.CRLF; l_subject VARCHAR2(50) := ...

Set Exclusive OFF Set Date BRITISH Set Century on Set Talk OFF Set Safety OFF Close ALL Clear All Clear lcFirmnum='NBS-000001' gnQry...

Client Master > Der+ Gen VI > Demat > Payout Status Quo Client Master > Der+ Gen VI > Default product > Status Quo AR >...

Select * From Tbllocktable Where Dcashbankfinancialentry Not Like ' '; ------------ CREATE OR REPLACE TRIGGER email_lock_table AFT...

Cheque is expired after 6 months 31 Mar 2011 20110331 update cashmain set bankreco=20110331 where firmnumber='ACML-00001' AND CBNUMB...

GRANT BRANCHCHANGE TO USER; GRANT BRANCHMASTER TO USER; GRANT BRANCHCHANGEREQUEST TO USER; GRANT EXECUTE ON SP_BRANCHMASTER TO USER;

LD YEAR END DATABASE CREATION FY 1112 STEPS FOR CREATING NEW YEAR DATABASE ‘1112 Step 1 : Create the Database ARI1112 using template LDLARGE...

CLient Master > Der+Gen VI > option brokerage on > UPDATE Cldetail SET Cderbroktype='P' ,CDERSBROKTYPE='P' WHERE FI...

01/04/2011 holiday existing 30/03/2011 financial posting is 05/04/2011 31/03/2011 financial posting is 06/04/2011 30/03/2011 old financial p...

LD ASP YEAR END PROCESS FY 1112 Before processing for New Year financial process for ASP. We have to log into the local LD and follow the fo...

Create Role ClientPassEdit ; Grant update on Accountemaildetail to ClientPassEdit ; Grant clientpassedit to cllvl; OTHERWISE ...

connect sys@ksh1112srv as sysdba CREATE DIRECTORY LDDGITAL AS 'd:\ldoutput\Lddigital'; grant read, write on directory LDDIGITAL to l...

1) export clientscannedimage table 2) drop table clientscannedimage; --- other master transmission take verc much time .. 3) impdb later 4) ...

Select Sauda.Oowncode as Oowncode, Sauda.Compcode as Compcode,' ' as Ndel, Rpad(' ',20) as Companyname, Sauda.Exchcode as...

This error happens when a connection is started (and working), but then closed by the other side of things before the SMTP conversation is c...

select distinct Brcode, sum(Grosspurch) Purchases, sum(Grosssales) Sales, sum(Totalvol) GrossTurnover, sum(Netpsvalue) NetTurnover, sum(Bro...

Select journal.jvdate as jv_date, ' ' as jvdate,Journdc.Jvoowncode as oowncode, journal.jvnumber as jvnumber,journal.jvnum...