Loading repository data…
petrfaltus / repository
Console applications for connection to the Oracle database, how to update rows, how to read the table and how to call the stored function and the stored procedure. Complete example collection including Docker and SQL init. Code for Java built by the Maven, for Java built by the Gradle, for C# built by the .NET Framework and for PHP.
A transparent discovery signal based on current public GitHub metadata.
This score does not audit code, security, maintainers, documentation quality, or suitability. Verify the repository and its current documentation before adoption.
Small example console source codes how to connect to the Oracle database, how to update rows and how to read the table.
git clone https://github.com/petrfaltus/oracle-database-connection-source-codes.gitThe subdirectory docker-database contains prepared Windows batches:
01-run-database.cmd - pulls the image (the download size is about 2GB) and runs the container at the first time (takes a time until ready)02-switch-database-OFF.cmd - stops the already existing container02-switch-database-ON.cmd - starts the already existing container (takes a time until ready)03-inspect-database.cmd - shows details for already existing container04-exec-connection-to-database.cmd - executes the SQL Plus terminal into running database containercontainers.cmd - lists currently running containers and list of all existing containersFor the connection to the database use either the SQL Plus terminal or the Oracle SQL Developer
User sys (default password )
Selected from shared topics, language and repository description—not editorial ratings.
petrfaltus /
Console applications for a network TCP and UDP socket communication over IPv4 and IPv6. Senders and receivers, complete example collection. Code for Java, for C# built by the .NET Framework, for PHP and for Python.
31/100 healthpetrfaltus /
Console applications for connection to the Microsoft SQL Server, how to update rows, how to read the table and how to call the stored function and the stored procedure. Complete example collection including Docker and SQL init. Code for Java built by the Maven, for Java built by the Gradle, for C# built by the .NET Framework and for PHP.
31/100 healthCONNECT sys AS SYSDBA;
ALTER SESSION SET "_ORACLE_SCRIPT"=true;
User testuser (default password T3stUs3r!)
CONNECT testuser;
ALTER SESSION SET "_ORACLE_SCRIPT"=true;
User sys (default password Oradoc_db1)
User testuser (default password T3stUs3r!)
CREATE USER testuser IDENTIFIED BY "T3stUs3r!";
GRANT ALL PRIVILEGES TO testuser;
CREATE TABLE CARS
(
MANUFACTURER VARCHAR2(40 BYTE) NOT NULL,
MODEL VARCHAR2(50 BYTE) NOT NULL,
DOORS NUMBER(2,0) NOT NULL,
CREATED TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP,
UPDATED TIMESTAMP(6),
REMARK VARCHAR2(80 BYTE),
ID NUMBER(6,0) GENERATED ALWAYS AS IDENTITY START WITH 1 INCREMENT BY 1 NOT NULL,
PRIMARY KEY (ID)
);
CREATE OR REPLACE TRIGGER CARS_UPDATE
BEFORE UPDATE ON CARS
FOR EACH ROW
BEGIN
:NEW.UPDATED := CURRENT_TIMESTAMP;
END;
INSERT INTO CARS (MANUFACTURER, MODEL, DOORS) VALUES ('Hyundai', 'Veloster', 3);
INSERT INTO CARS (MANUFACTURER, MODEL, DOORS) VALUES ('Skoda', 'Fabia', 5);
INSERT INTO CARS (MANUFACTURER, MODEL, DOORS) VALUES ('Volkswagen', 'Passat', 4);
INSERT INTO CARS (MANUFACTURER, MODEL, DOORS) VALUES ('Ford', 'Saloon', 4);
INSERT INTO CARS (MANUFACTURER, MODEL, DOORS) VALUES ('Ford', 'Focus', 5);
CREATE OR REPLACE PACKAGE CALCULATOR AS
FUNCTION FACTORIAL(N INTEGER) RETURN INTEGER;
PROCEDURE ADD_AND_SUBTRACT(A INTEGER, B INTEGER, X OUT INTEGER, Y OUT INTEGER);
END;
/
CREATE OR REPLACE PACKAGE BODY CALCULATOR AS
FUNCTION FACTORIAL(N INTEGER) RETURN INTEGER IS
RESULT INTEGER := 1;
BEGIN
IF N < 0 THEN
RETURN -1;
END IF;
IF N < 2 THEN
RETURN RESULT;
END IF;
FOR IJK IN 2 .. N LOOP
RESULT := RESULT * IJK;
END LOOP;
RETURN RESULT;
END;
PROCEDURE ADD_AND_SUBTRACT(A INTEGER, B INTEGER, X OUT INTEGER, Y OUT INTEGER) IS
BEGIN
X := A + B;
Y := A - B;
END;
END;
/
SELECT * FROM CARS;
SELECT COUNT(*) FROM CARS;
SELECT COUNT(*) FROM CARS WHERE ID!=1;
SELECT CALCULATOR.FACTORIAL(2) FROM DUAL;
SELECT CALCULATOR.FACTORIAL(3) FROM DUAL;
SELECT CALCULATOR.FACTORIAL(4) FROM DUAL;
SET serveroutput on;
DECLARE
a INTEGER := 12;
b INTEGER := 5;
x INTEGER;
y INTEGER;
BEGIN
dbms_output.put_line('a = ' || a);
dbms_output.put_line('b = ' || b);
CALCULATOR.ADD_AND_SUBTRACT(a, b, x, y);
dbms_output.put_line('x = ' || x);
dbms_output.put_line('y = ' || y);
END;
/
%JAVA_HOME% variable (must exist "%JAVA_HOME%\bin\java.exe")mvn.cmd locates) to the OS environment %PATH% variableThe subdirectory java-maven contains prepared Windows batches:
01-build.cmd - cleans, compiles and builds the Maven project02-run.cmd - runs the built Java archive (JAR)03-clean.cmd - cleans the Maven projectgradle.bat locates) to the OS environment %PATH% variableThe subdirectory java-gradle contains prepared Windows batches:
01-build.cmd - cleans, compiles and builds the Gradle project02-run.cmd - runs the built Java archive (JAR)03-clean.cmd - cleans the Gradle projectcsc.exe .NET C# compiler that is the part of Microsoft .NET Framework (part of OS)Oracle.ManagedDataAccess.dll from Oracle Data Provider for .NET in the csharp\bin directoryThe subdirectory csharp contains prepared Windows batches:
01-compile.cmd - compiles the source code (contains the path definition to the csc.exe compiler)02-run.cmd - runs the Windows executable03-clean.cmd - deletes the Windows executable%PHP_HOME% variable (must exist "%PHP_HOME%\php.exe")oci.dll, oraociei19.dll and oraons.dll from Oracle Instant Client to the PHP directory %PHP_HOME%To the php.ini in the PHP directory %PHP_HOME% add lines
[PHP]
extension_dir = "ext"
extension=pdo_oci
[Date]
date.timezone = Europe/Prague
The subdirectory php contains prepared Windows batch:
01-run.cmd - runs the code through the PHP interpreterNow in August 2020 I have the computer with Windows 10 Pro 64bit, 12GB RAM and available 50GB free HDD space
| Tool | Version | Setting |
|---|---|---|
| GIT | 2.26.0.windows.1 | |
| docker desktop | 2.3.0.4 (46911) stable | 2 CPUs, 3GB memory, 1GB swap, 48GB disc image size |
| Oracle Database Enterprise Edition image | 12.2.0.1 | default password for sys: Oradoc_db1 |
| Oracle SQL Developer | 20.2.0 | |
| Java JDK | 14.0.1 | Java(TM) SE Runtime Environment (build 14.0.1+7) |
| Apache Maven | 3.6.3 | |
| Gradle Build Tool | 6.3 | |
| .NET C# compiler | 4.8.3752.0 | |
| Oracle Data Provider for .NET | 12.2 | ODP.NET_Managed_ODAC122cR1.zip |
| PHP | 7.4.4 | 7.4.4-nts-Win32-vc15-x64 |
| Microsoft Visual C++ Redistributable for Visual Studio 2015, 2017 and 2019 | VC_redist.x64.exe | |
| Oracle Instant Client | 19.6.0.0.0 | instantclient-basic-windows.x64-19.6.0.0.0dbru.zip |
petrfaltus /
Console applications for JSON communication with my public available mortgage calculation REST service. Complete example collection. Code for Java built by the Maven, for Java built by the Gradle, for C# built by the .NET Framework, for PHP and for Python.
34/100 healthConsole applications for JSON communication with my public available bank account validator and converter REST service. Complete example collection. Code for Java built by the Maven, for Java built by the Gradle, for C# built by the .NET Framework, for PHP and for Python.
34/100 healthConsole applications for JSON communication with my public available state, territory, continent and area code REST service. Complete example collection. Code for Java built by the Maven, for Java built by the Gradle, for C# built by the .NET Framework, for PHP and for Python.
34/100 healthpetrfaltus /
Console applications for connection to the MySQL, how to update rows, how to read the table and how to call the stored function and the stored procedure. Complete example collection including Docker and SQL init. Code for Java built by the Maven, for Java built by the Gradle, for C# built by the .NET Framework and for PHP.
31/100 health