Empowering World With Technology

 Imp Note => In table name only underscores are allowed.  CREATE TABLE "<SCHEMA_NAME>"."<TABLE_NAME>"  ( "PXCOMMITDATETIME  TIMESTAMP(6), "PXCREATEDATETIME" TIMESTAMP(6), "PXCREATEOPNAME" VARCHAR2(128 BYTE), "PXCREATEOPERATOR" VARCHAR2(128 BYTE), "PXCREATESYSTEMID" VARCHAR2(128 BYTE), "PXINDEXCOUNT" NUMBER(18,0), "PXINDEXPURPOSE" VARCHAR2(255 BYTE), "PXINSINDEXEDCLASS" VARCHAR2(255 BYTE), "PXINSINDEXEDKEY" VARCHAR2(255 BYTE), "PXINSNAME" VARCHAR2(192 BYTE), "PXOBJCLASS" VARCHAR2(96 BYTE), "PXUPDATEDATETIME" TIMESTAMP(6), "PXUPDATEOPNAME" VARCHAR2(128 BYTE), "PXUPDATEOPERATOR" VARCHAR2(128 BYTE), "PXUPDATESYSTEMID" VARCHAR2(128 BYTE), "PYLABEL" VARCHAR2(255 BYTE), "PZINSKEY" VARCHAR2(255 BYTE) NOT NULL ENABLE, "PXSAVEDATETIME" TIMESTAMP(6) ); COMMIT;

Oracle SQL Queries Change Table Name ALTER TABLE  "<TABALE_NAME>"  RENAME TO NEW_TABLE_NAME; COMMIT; Select Query For Index Table SELECT * FROM <TABLE_NAME> where pxinsindexedkey like '%C-105%'; Case Count In Index Table SELECT COUNT(*) FROM INDEX_IN_B_DATA_CONTROL; Drop Column Command ALTER TABLE  "<TABLE_NAME>"  DROP COLUMN   "<COLUMN_NAME>"; COMMIT; Add Column ALTER TABLE <TABLE_NAME>  ( "ADDRESSCOUNTRY" VARCHAR2(255 BYTE) ); COMMIT; Modify Column ALTER TABLE <TABLE_NAME> MODIFY  (LoanProvider VARCHAR2(255 BYTE)); COMMIT;

  Follow below steps After filling details above, click on Next. Thanks,

  In Report Definition we can set Column Heading using below Caption field inside filters in report definition rule For setting Alignment of Integer Type Property inside Report Definition Date Time Format dd/MM/yyyy

  In Parameters Tab of Data Transform Rule Define Parameters of Type Integers CounterCRSP        Data Type = Integer            Default Value = 0 CurrentCountCRSP         Data Type = Integer        Default Value = Not Required Now In Definition Tab of Data Transform Rule 1) Set  Param.CounterCRSP           equal to     Param.CounterCRSP+1 2) Set  Param.CurrentCountCRSP    equal to   Param.CounterCRSP We can use above logic inside Flow where we are looping one or multiple assignments based on conditions. Thanks,

 Hi All, In this Blog we will see real time implementation of Savable Data Page. 1) DEV Studio ---> Data Types --->Add data type 2) Add Data Type ---> Label = TVSerialDetails Parent class =>  HDFC-HDFCAuto-Data Add to ruleset = HDFCAuto 3) Go To Data Type ---> Click on Add field Button   Add field according to requirement. 4) Now Go to Records Tab ---> Actions Button --->Edit Columns    Make one field as Primary according to requirement. 5) In Sources Tab we can see 3 data pages automatically created by PRPC a) Read-Only  Data Page ---> Page list structure --->Source = Report definition               This data page does not have any parameter defined b) Savable Data Page ----> Page Structure ---> Source = Lookup ; Data save options = Database save Savable Data Page also have parameter, i.e primary key c) Read-Only Data Page ---> Page Structur ---> Source = Lookup  This ...

 Hi All, In this blog we will see Edit Validate Example 5 Java Code boolean valid = (theValue!=null) && (theValue.length()>0); if(valid) { try { String MultipleGUIDNumbers = theValue.toString(); for(int i=0;i<MultipleGUIDNumbers.length();i++) { if(!(MultipleGUIDNumbers.charAt(i)>='0' && MultipleGUIDNumbers.charAt(i)<='9' || (MultipleGUIDNumbers.charAt(i)==';'))) { theProperty.addMessage("Please Enter Numeric Value"); return false; } } String  GUIDNumbersArray[] = MultipleGUIDNumbers.split(","); if ( GUIDNumbersArray.length>20) { theProperty.addMessage("Only 20 Values are Accepted"); return false; } for (int i=0; i<GUIDNumbersArray.length;i++) { if(GUIDNumbersArray[i].length()<8 || GUIDNumbersArray[i].length()>9) { theProperty.addMessage("Booking contract number should be of 9 digits"); return false; } } } catch(java.lang.Exception ex) { theProperty.addMessage("Booking contract n...