How to configure remote desktop in centos

yum -y install epel-release

yum -y install xrdp tigervnc-server

systemctl status xrdp

systemctl start xrdp.service

systemctl enable xrdp.service

firewall-cmd --permanent --zone=public --add-port=3389/tcp

firewall-cmd --reload

( rdp 3389 ) Correction is Server listens on TCP port 3389 and UDP port 3389

xrdp Remote Desktop Protocol

How to configure VNC server in Linux CentOS

 yum install tigervnc-server

cp /lib/systemd/system/vncserver@.service  /etc/systemd/system/vncserver@:1.service

ExecStart=/usr/bin/vncserver_wrapper root %i

PIDFile=/home/root/.vnc/%H%i.pid

vi /etc/systemd/system/vncserver@\:1.service

# systemctl daemon-reload

# systemctl start vncserver@:1

# systemctl status vncserver@:1

# systemctl enable vncserver@:1

# firewall-cmd --add-port=5901/tcp

# firewall-cmd --add-port=5901/tcp --permanent

vncserver

--Add new port 

# firewall-cmd --add-port=5902/tcp

# firewall-cmd --add-port=5902/tcp --permanent

vncserver

---When Not work

rm -rvf .X11-unix

How to see Sql Query in Toad

insert multiple image using from temp file

   CREATE TABLE "TEST"."EMPLOYEE_PHOTO" 

   ( "ID" VARCHAR2(100 BYTE), 

"FILENAME" VARCHAR2(1000 BYTE), 

"MIME_TYPE" VARCHAR2(1000 BYTE), 

"PHOTO" BLOB, 

"EMPLOYEE_ID" VARCHAR2(1000 BYTE)

   )

---

• P10_NEW  -file browse 
• P10_ID -- ID 
• upload Button 

--create page load dynamic action 

Execute PL/SQL Code 

delete from APEX_APPLICATION_TEMP_FILES;

--Processing (upload )

DECLARE

CURSOR C1 IS 

SELECT ID,FILENAME,MIME_TYPE,BLOB_CONTENT

FROM APEX_APPLICATION_TEMP_FILES;

    

BEGIN

FOR REC_C1 IN C1 LOOP

INSERT INTO EMPLOYEE_PHOTO (ID,FILENAME,MIME_TYPE,PHOTO,EMPLOYEE_ID)

VALUES (REC_C1.ID,REC_C1.FILENAME,REC_C1.MIME_TYPE,REC_C1.BLOB_CONTENT,:P10_ID);

END LOOP;

    delete from APEX_APPLICATION_TEMP_FILES;

    

    

    END;

Insert Multiple images in oracle apex using collection

Page 7

1.  P7_ID

2. Attachment   -Page link 8 

3. Save button 

Plsql Code-- Set Save button

IF apex_collection.collection_exists('DATA_COLLECTION_FILE') THEN------------

BEGIN

    INSERT INTO HOLDING_APPLICATION_ATTATCHMENT(HOLDING_APPLICATION_ID,IMAGE) 

    SELECT 101,(select blob_content from APEX_APPLICATION_TEMP_FILES   where  name =c001) 

    FROM  APEX_COLLECTIONS where COLLECTION_NAME='DATA_COLLECTION_FILE';

    END;

    begin

    apex_collection.delete_collection(p_collection_name =>'DATA_COLLECTION_FILE');

    end;

  END IF;

Page 8

• P8_IMAGE
• add
• refresh

--Dynamic Action 

 Execute Pl/SQl Code 

IF apex_collection.collection_exists('DATA_COLLECTION_FILE') THEN

apex_collection.delete_collection('DATA_COLLECTION_FILE');

end if;

--refresh region report 

• add button 

--Processing 

 Execute Pl/SQl Code 

  begin

if not apex_collection.collection_exists('DATA_COLLECTION_FILE') then

apex_collection.create_collection('DATA_COLLECTION_FILE');

end if;

apex_collection.add_member (

p_collection_name=>'DATA_COLLECTION_FILE',

p_c001=>:P8_IMAGE);

end;

---report in 8 page 

SELECT SEQ_ID,c001 FILE_NAME from APEX_COLLECTIONS where COLLECTION_NAME='DATA_COLLECTION_FILE';

Manual Insert Master detail

1. get_pk

declare 

    v1 number;

    v2 number;

begin

   select to_number(count(1))+1 into v2 from IT_ITEM_RCV_MAST where to_date(RCV_DT)=to_date(sysdate);

    if  v2>1 then   

        select distinct('RCV-NUM-'||''||to_char(sysdate,'RRMMDD'))||''|| v2 into :P30_RCV_NO from SYS.DUAL;

    else 

         :P30_RCV_NO:='RCV-NUM-'||''||to_char(sysdate,'RRMMDD')||''||1;

    end if;

    

end;

select nvl(max(to_number(SL_NO)),0)+1 into :P30_SL_NO from IT_ITEM_RCV_MAST;

-----------

--Sequence 

   CREATE SEQUENCE  "IT"."IT_ITEM_RCV_CHILD_SLNO"  

   MINVALUE 1 

   MAXVALUE 99999999999999999999999999 

   INCREMENT BY 1 

   START WITH 23 NOCACHE  NOORDER  CYCLE  NOKEEP  NOSCALE  GLOBAL ;

2. Direct Insert master Table

3. Insert Detail  Table

if :P30_RCV_NO is not null and :ITEM_CD is not null and :QTY is not null then 

insert into IT_ITEM_RCV_CHILD

(

RCV_NO

 ,  SLNO

 ,  ITEM_CD

 ,  BRAND

 ,  ITEM_SERIAL

 ,  QTY

 ,  UNIT_COST

 ,  MAF_DT

 ,  EXPIR_DT

 ,  WARRNTY

 ,  ITEM_DESC

 ,  MODEL_NM

 ,  RCV_DTLNO

)

values

(

 :P30_RCV_NO

  , it.IT_ITEM_RCV_CHILD_SLNO.nextval

 , :ITEM_CD

 , :BRAND

 , :ITEM_SERIAL

 , :QTY

 , :UNIT_COST

 , :MAF_DT

 , :EXPIR_DT

 , :WARRNTY

 , :ITEM_DESC

 , :MODEL_NM

 , :RCV_DTLNO

);

else

null;

end if;

4. Process form update

begin 

if :RCV_NO is not null then 

Update IT_ITEM_RCV_CHILD

  set 

            SLNO=:SLNO

           ,ITEM_CD=:ITEM_CD

           ,BRAND=:BRAND

           ,ITEM_SERIAL=:ITEM_SERIAL

           ,QTY=:QTY

           ,UNIT_COST=:UNIT_COST

           ,MAF_DT=:MAF_DT

           ,EXPIR_DT=:EXPIR_DT

           ,WARRNTY=:WARRNTY

           ,ITEM_DESC=:ITEM_DESC

           ,MODEL_NM=:MODEL_NM

           ,RCV_DTLNO=:RCV_DTLNO

where 

    RCV_NO=:P30_RCV_NO;

     end if;

    

 End; 

5. New Insert 

if :SLNO is null and :P30_REQ_NO is not null then 

insert into IT_ITEM_RCV_CHILD

(     

   RCV_NO

,  SLNO

,  ITEM_CD

,  BRAND

,  ITEM_SERIAL

,  QTY

,  UNIT_COST

,  MAF_DT

,  EXPIR_DT

,  WARRNTY

,  ITEM_DESC

,  MODEL_NM

,  RCV_DTLNO

) 

values

(

  :P30_RCV_NO

,  it.IT_ITEM_RCV_CHILD_SLNO.nextval

,  :ITEM_CD

,  :BRAND

,  :ITEM_SERIAL

,  :QTY

,  :UNIT_COST

,  :MAF_DT

,  :EXPIR_DT

,  :WARRNTY

,  :ITEM_DESC

,  :MODEL_NM

,  :RCV_DTLNO

);

else 

null;

end if;

install oracle weblogic 12c

 https://blogs.oracle.com/fusionmiddlewaresupport/creating-and-starting-a-standalone-reports-server-in-12c-v2

A. Create the components

1- Execute wlst.cmd/wlst.sh from ORACLE_HOME/oracle_common/common/bin

2- Connect to AdminServer.

    connect("weblogic","weblogic1","localhost:7001")

3- Run the following wlst command.

   createReportsToolsInstance(instanceName='reptools1',machine='AdminServerMachine')