exec

exec isis4d.GET_SHIPMENT_FOR_NEW_FW('02621',:b,:c,:d,:e,:f,:g,:l,:s,:j );

how to install mongodb in docker on ubuntu

  docker pull mongo

docker run --name database -d -p 27017:27017 mongo --noauth -bind_ip=0.0.0.0

docker ps

How to install docker on Ubuntu 18.04

• 
  
  
  
  • sudo apt update
  
  
  • sudo apt install apt-transport-https ca-certificates curl software-properties-common
  
  
  • sudo gedit /etc/apt/sources.list.d/docker.list
  
  
  • Copy this line in to the docker.list --> deb [arch=amd64]https://download.docker.com/linux/ubuntu artful stable
  
  
  • curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add -
  
  
  • sudo apt update
  
  
  • sudo apt install docker-ce
  
  
  • sudo docker run hello-world
  
  
  
  

CREATE MATERIALIZED VIEW

alter session set "_ORACLE_SCRIPT"=true;
CREATE USER BURAK IDENTIFIED BY s1;
GRANT RESOURCE, CONNECT TO BURAK;

ALTER USER BURAK QUOTA 100M ON users;

GRANT CREATE MATERIALIZED VIEW TO BURAK;

CREATE MATERIALIZED VIEW test_mv
AS SELECT * FROM BURAK.test_objects;

CREATE MATERIALIZED VIEW LOG ON BURAK.test_objects
INCLUDING NEW VALUES;

CREATE MATERIALIZED VIEW test_mv
BUILD IMMEDIATE
REFRESH FAST ON COMMIT
AS SELECT * FROM BURAK.test_objects;

plsql forall vs. for

1.

insert into test_objects
select object_name, object_type from dba_objects;

result : 91271 rows inserted.

2

/* Formatted on 1/7/2018 12:15:41 AM (QP5 v5.287) */
DECLARE
TYPE myType IS TABLE OF test_objects%ROWTYPE;

myObjects myType := myType ();
start_time NUMBER;
end_time NUMBER;
BEGIN

SELECT *
BULK COLLECT INTO myObjects
FROM test_objects;

-- Bulk Insert

EXECUTE IMMEDIATE 'TRUNCATE TABLE test_objects';

Start_time := DBMS_UTILITY.get_time;

FORALL i IN myObjects.FIRST .. myObjects.LAST
INSERT INTO test_objects
VALUES myObjects (i);

end_time := DBMS_UTILITY.get_time;
DBMS_OUTPUT.PUT_LINE (
'Bulk Insert: ' || TO_CHAR ( (end_time - Start_time) / 100));

-- without bulk insert

EXECUTE IMMEDIATE 'TRUNCATE TABLE test_objects';

Start_time := DBMS_UTILITY.get_time;

FOR i IN myObjects.FIRST .. myObjects.LAST
LOOP
INSERT INTO test_objects (object_name, object_type)
VALUES (myObjects (i).object_name, myObjects (i).object_type);
END LOOP;

end_time := DBMS_UTILITY.get_time;
DBMS_OUTPUT.PUT_LINE (
'Conventional Insert: ' || TO_CHAR ( (end_time - start_time) / 100));
COMMIT;
END;

 

result :

Bulk Insert: 0.06
Conventional Insert: 1.45