odbc configure in oracle database

ODBC configure & run time data sink in oracle database
--------------------------|||||------------------------


# install fingerTech 
  #finally create new database.. video mistec
# connect to punch machine ip
# Create system dns face


C:\Oracle12c\app\OracleHomeUser1\product\12.2.0\dbhome_1\hs\admin

HS_FDS_CONNECT_INFO = face
HS_FDS_TRACE_LEVEL = off

C:\Oracle12c\app\OracleHomeUser1\product\12.2.0\dbhome_1\network\admin
listener.ora

(SID_DESC =
(SID_NAME = face)
(ORACLE_HOME = C:\Oracle12c\app\OracleHomeUser1\product\12.2.0\dbhome_1)
(PROGRAM = dg4odbc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\Oracle12c\app\OracleHomeUser1\product\12.2.0\dbhome_1\bin\oraclr12.dll")
)

tnsnames.ora

FACEDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SID = face))
      (HS=OK)
  )


conn sys as sysdba

create user root identified by root;

grant connect,resource,dba to root;   

conn root/root@orcl

DROP PUBLIC DATABASE LINK FACELINK;

CREATE PUBLIC DATABASE LINK "FACELINK"
 CONNECT TO "root"
 IDENTIFIED BY "root"
 USING 'FACEDB';

restart pc and check --

select * from auditdata@facelink;

select "serialno",to_char("checktime",'DD-MON-RR HH24:MI:SS') from auditdata@facelink;

Top Rank

WITH cte_products AS (
select pack_size,b_code,p_name,nvl(totww-ttee,0) ssss,
RANK() OVER(ORDER BY nvl(totww-ttee,0) DESC) price_rank
from
(
 select c.pack_size,b.b_code,c.p_name,nvl(sum(qty),0) totww, nvl(sum(rqty),0)  ttee
     from jpldba.INVOICE_MAST@fremote10g a, jpldba.INVOICE_CHILD@fremote10g b, jpldba.price@fremote10g c
         where a.inv_no=b.inv_no
             and b.b_code=c.b_code
               and a.empcode='CTG169'
                 --and b.b_code='HSTS2'
                 and inv_date between '01-FEB-20' and '28-FEB-20'
                     group by c.pack_size,b.b_code,c.p_name
))
SELECT
pack_size,
b_code,
 p_name,
 ssss,
 price_rank
FROM
 cte_products
WHERE
 price_rank <= 5
 order by price_rank
/

How to configure ords on weblogic 12c

ords on weblogic 12c

1-----------------CMD
cd D:\apex_19.2\apex
sqlplus
sys as sysdba

@apexins.sql sysaux sysaux temp /i/
@apxchpwd.sql
@apxldimg.sql D:\apex_19.2
@apex_rest_config.sql
@apex_epg_config.sql D:\apex_19.2

2-----------------Download

Download Ords
Paste in D:\ORDS
Paste images filder from apex to ords

3-----------------CMD

Microsoft Windows [Version 10.0.18363.418]
(c) 2019 Microsoft Corporation. All rights reserved.

C:\Users\Administrator>cd D:\ords

C:\Users\Administrator>D:

D:\ords>java -jar D:\ORDS\ords.war static D:\ORDS\images
WAR Generation complete
 WAR location     : D:\ords\i.war
 Context path     : /i
 Static resources : D:\ORDS\images
Ensure the static resources are available at path: D:\ORDS\images
on the server where the WAR is deployed

D:\ords>java -jar D:\ORDS\ords.war
This Oracle REST Data Services instance has not yet been configured.
Please complete the following prompts


Enter the location to store configuration data: D:\ORDS\config
Enter the name of the database server [localhost]:
Enter the database listen port [1521]:
Enter 1 to specify the database service name, or 2 to specify the database SID [1]:
Enter the database service name:orcl
Enter the database password for ORDS_PUBLIC_USER:
Confirm password:
Requires to login with administrator privileges to verify Oracle REST Data Services schema.

Enter the administrator username:sys
Enter the database password for SYS AS SYSDBA:
Confirm password:

Retrieving information.
Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.
If using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]:
Enter the database password for APEX_PUBLIC_USER:
Confirm password:
Enter 1 to specify passwords for Application Express RESTful Services database users (APEX_LISTENER, APEX_REST_PUBLIC_USER) or 2 to skip this step [1]:
Enter the database password for APEX_LISTENER:
Confirm password:
Enter the database password for APEX_REST_PUBLIC_USER:
Confirm password:
Mar 04, 2020 4:02:12 PM
INFO: reloaded pools: []
Installing Oracle REST Data Services version 19.2.0.r1991647
... Log file written to C:\Users\Administrator\ords_install_core_2020-03-04_160212_00785.log
... Verified database prerequisites
... Created Oracle REST Data Services proxy user
... Created Oracle REST Data Services schema
... Granted privileges to Oracle REST Data Services
... Created Oracle REST Data Services database objects
... Log file written to C:\Users\Administrator\ords_install_datamodel_2020-03-04_160222_00521.log
... Log file written to C:\Users\Administrator\ords_install_apex_2020-03-04_160223_00989.log
Completed installation for Oracle REST Data Services version 19.2.0.r1991647. Elapsed time: 00:00:12.678

Enter 1 if you wish to start in standalone mode or 2 to exit [1]:2

D:\ords>

4---------------------configure
in weblogic development  section

5---------------------sqlplus


SQL*Plus: Release 12.2.0.1.0 Production on Wed Mar 4 16:09:46 2020

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SELECT resource_name, limit
FROM dba_profiles
WHERE profile = 'DEFAULT'
AND resource_type = 'PASSWORD';

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;


SQL> alter user ords_public_user identified by Munshi#1 account unlock
  2  /

User altered.

SQL> alter user APEX_PUBLIC_USER identified by Munsi#1 account unlock
  2  /

User altered.

SQL> alter user ORDS_PUBLIC_USER identified by Munsi#1 account unlock
  2  /

User altered.

SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;

User altered.

if not ok then
Finally  Copy and apex images forlder to  ords

download ords 

https://www.oracle.com/database/technologies/appdev/rest-data-services-v192-downloads.html

configure guide
http://info.aimstar.com/blog/deploying-ords-on-weblogic-for-apex

sms apex

sms

var iuser   = "jayson";
var ipass   = "98n<9I84";     
var isid    = "JaysonNonEng";     
var sms_txt = "Send Test SMS";
var Mob_No  = "+8801744642682";
//
var xhttp = new XMLHttpRequest();
var parameters="user="+iuser+"&pass="+ipass+"&sid="+isid+"&sms[0][0]="+Mob_No+"&sms[0][1]="+sms_txt+"&[0][2]=1234567891";
//
xhttp.open("POST","http://sms.sslwireless.com/pushapi/dynamic/server.php", true);
xhttp.setRequestHeader("Content-type","application/x-www-form-urlencoded");
xhttp.send(parameters);