Skip to main content

Posts

Showing posts from April, 2014

PL/SQL Update Next Value of a Sequence

declare     deger number:=0; begin     select SCHEMA_NAME.SEQ_ENG_ENG_BILGILERI_ID.nextval     into deger     from dual;          dbms_output.put_line(deger); end; ALTER SEQUENCE PROBBYS.SEQ_ENG_ENG_BILGILERI_ID INCREMENT BY 1000; SELECT PROBBYS.SEQ_ENG_ENG_BILGILERI_ID.NEXTVAL FROM dual; ALTER SEQUENCE PROBBYS.SEQ_ENG_ENG_BILGILERI_ID INCREMENT BY 1;

C# Generics

//Main Program - Calling the GetResults Method string mesaiBitisSaati = CommonClass .GetResults< string >( SystemCodes .MZB, 1); //CommonClass - GetOneResult Method public static T GetResults<T>( SystemCodes sistemKodu, decimal parametreKodu) {             try             {                 object param = GetOneResult(sistemKodu, parametreKodu);                 return (T) Convert .ChangeType(param, typeof (T));             }             catch             {                 return default (T);             } } //CommonClass - GetOneResult Method   public static string GetOneResult( SystemCodes sistemKodu, decimal parametreKodu) {             try             {                 using ( ProbelTESTEntities context = EntityProvider < ProbelTESTEntities >.NewContainer())                 {                     TEST_TABLE param = context.TEST_TABLE.Where(x => x.SISTEM_ID == ( decimal )sistemKodu &&