Auto mail attachment

<pluginParam name="mailServer">mail.***.com:25</pluginParam>

 

 

E:\DevSuiteHome_1\BIN\rwrun report=E:\DevSuiteHome_1\BIN\Buyer_Wise_Shipment_Summary_Report.RDF userid=labserp/***@dba desformat=pdf destype=mail DESNAME="masumbillah@lantaburgroup.com,ahasan@lantaburgroup.com,delowar@lantaburgroup.com,sakhawat@lantaburgroup.com" CC="mdalamin@lantaburgroup.com" from="ERP@lantaburgroup.com" SUBJECT="Shipment Status"

Form Builder 12c linux

yum install oracle-database-server-12cR2-preinstall 

export ORACLE_BASE=/u01/app/oracle

export MW_HOME=$ORACLE_BASE/product/12.2.1

export ORACLE_HOME=$MW_HOME

export WLS_HOME=$MW_HOME/wlserver

export WL_HOME=$WLS_HOME

export FR_HOME=$ORACLE_HOME

export ORACLE_INSTANCE=$DOMAIN_HOME/config/fmwconfig/components/FORMS/instances/

forms1

export FR_INST=$ORACLE_INSTANCE

export DOMAIN_HOME=$ORACLE_BASE/config/domains/mydomain

export JAVA_HOME=$ORACLE_BASE/jdk1.8.0_301

#export OHS_INST=$DOMAIN_HOME/config/fmwconfig/components/OHS/instances/ohs1

# Forms compilation

export PATH=.:$FR_HOME/bin:$FR_HOME/forms/mesg:$PATH:$ORACLE_INSTANCE/bin

export LD_LIBRARY_PATH=$FR_HOME/oracle_common/lib/amd64:$FR_HOME/lib:$FR_HOME/

oracle_common/lib:$FR_HOME/oracle_common/jdk/lib/amd64/server

#:$FR_HOME/lib/stubs

export FORMS_BUILDER_CLASSPATH=$FR_HOME/jlib/

export FORMS_PATH=/u01/app/oracle/product/12.2.1/forms

#export REPORTS_PATH=

#export TWO_TASK=ORCL

export TNS_ADMIN=$DOMAIN_HOME/config/fmwconfig/

export TERM=vt220

export ORACLE_TERM=$TERM

Random Value

 select dbms_random.value(1,10)original_value,
ceil(dbms_random.value(1,10))ceil_valie,
round(dbms_random.value(1,10))round_value,
floor(dbms_random.value(1,10))floor_value
 from dual
/

DECLARE
A NUMBER;
BEGIN
FOR I IN 1 .. 10 LOOP
DBMS_RANDOM.SEED('TEST2');
A:=ROUND(dbms_random.VALUE(1,1000),0);
DBMS_OUTPUT.PUT_LINE(A+I);
END LOOP;
END;

Connection String Dot Net

 String conString = "Data Source = localhost:1521 / orcl; User Id =labs;Password = labs;";
            OracleConnection con = new OracleConnection(conString);
            con.Open();
            
            OracleCommand cmd = new OracleCommand("insert into TEST_APEX(NAME,GENDER,CONTACT,EMAIL,CITY,COUNTRY) values('" + Name.Text+ "'," + "'" + Gender.SelectedValue + "'," + "'" + Contact.Text + "',"+"'" + Email.Text + "'," + "'" + City.Text + "'," + "'" + Country.Text + "')", con);

            cmd.ExecuteNonQuery();
            Name.Text="";
            Gender.SelectedValue = "";
            Contact.Text = "";
            Email.Text = "";
            City.Text = "";
            Country.Text = "";
            Response.Write("Employee inserted sucessfully.<br />");
            con.Close();

Manual Waiting in Loop

 begin
for i in 1 .. 1
loop
dbms_output.put_line(to_char(sysdate, 'mi:ss'));
dbms_lock.sleep(.5);
end loop;
end;
/

File Transfer Using Oracle

 DBMS_FILE_TRANSFER.COPY_FILE(
   source_directory_object       IN  VARCHAR2,
   source_file_name              IN  VARCHAR2,
   destination_directory_object  IN  VARCHAR2,
   destination_file_name         IN  VARCHAR2);


BEGIN
DBMS_FILE_TRANSFER.COPY_FILE('DMPDIR',"expdp_28-07-Tue_23.00_PM.zip", 'DMPDIR',
                                   "expdp_28-07-Tue_23.00_PM2.zip");
END;

create or replace directory DMPDIR AS 'G:\';

create or replace directory DMPDIR2 AS 'G:\NEW';


BEGIN
  DBMS_FILE_TRANSFER.COPY_FILE(
   source_directory_object      => 'DMPDIR',
   source_file_name             => 'IMPORT.LOG',
   destination_directory_object => 'DMPDIR',
   destination_file_name        => 'IMPORT2.LOG');
END;
/


begin
UTL_FILE.FCOPY ('DMPDIR', 'expdp_28-07-Tue_23.00_PM.zip', 'DMPDIR', 'expdp_28-07-Tue_23.00_PM2.zip');
end;
/

Physical file existence check

DECLARE
  l_file_exists BOOLEAN;
  l_file_len    NUMBER;
  l_blocksize   BINARY_INTEGER;
BEGIN
  utl_file.fgetattr(
    location    => 'UTL_DIR',
    filename    => 'MM.TXT',
    fexists     => l_file_exists,
    file_length => l_file_len,
    block_size  => l_blocksize);
  IF l_file_exists THEN
    dbms_output.put_line('File found, size=' || l_file_len);
  ELSE
    dbms_output.put_line('File not found.');
  END IF;
END;