Category: Root

Apr 04

Oracle : Auditing Database Activity

7 Auditing Database Activity This chapter contains: Ref: https://docs.oracle.com/cd/E11882_01/server.112/e10575/tdpsg_auditing.htm#TDPSG50511

Apr 03

Connect to Sql Server FROM JAVA

https://learn.microsoft.com/en-us/sql/connect/jdbc/connection-url-sample?view=sql-server-ver16

Apr 03

jOOQ Eamples

For Java Platform: Ref: https://www.jooq.org/

Mar 26

Oracle: Hierarchical Queries and Advanced Analytics Functions

•Hierarchical Queries •START WITH •CONNECT BY PRIOR •CONNECT BY FOLLOWING •ORDER by level •Analytics Functions •Windowing •PRECEDING, UNBOUNDED_PRECEDING •ROWS BETWEEN Unbounded Preceding •CURRENT ROW •RANGE BETWEEN INTERVAL 30 DAY PRECEDING AND INTERVAL ‘30’ DAY Following •ROWS BETWENN 1 PRECEDING and 1 FOLLOWING Other Analytics Functions and Clauses: •OVER() •PARTITION OVER •Over Partition By •Avg () …

Continue reading

Mar 26

PL/SQL Function Syntax in Oracle

REF: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/lnpls/CREATE-FUNCTION-statement.html

Mar 26

Stored Procedure in Oracle

Ref: https://docs.oracle.com/database/121/LNPLS/create_procedure.htm#LNPLS01373

Mar 26

What are some Data Integration Tools?

Tools for data integration, ETL (Extract, Transform, Load), and data management. 1. Apache NiFi 2. Pentaho Data Integration (PDI) 3. Apache Spark 4. Microsoft SQL Server Integration Services (SSIS) 5. Informatica PowerCenter 6. Apache Airflow 7. Matillion 8. Fivetran 9. Stitch 10. Apache Camel 11. Luigi 12. SnapLogic 13. DataStage (IBM) Ref: Internet

Mar 14

Oracle CASE within SELECT

From: https://docs.oracle.com/cd/B19306_01/server.102/b14200/expressions004.htm Syntax: Example: Write a SQL block that will categorize Customers’ Credit Limit. If the limit is > 5000, show high, when 100 show low otherwise show medium. Utilize CASE statement. SELECT cust_last_name, CASE credit_limit WHEN 100 THEN ‘Low’ WHEN 5000 THEN ‘High’ ELSE ‘Medium’ END FROM customers; CUST_LAST_NAME CASECR ——————– —— … Bogart …

Continue reading

Mar 14

Oracle ISOLATION Levels

Isolation => I in ACID Supported two types: However, there are other levels of ISOLATION such as: Read Uncommitted Repeated READ — Note: in Read Committed, dirty data is locked until committed. In Repeated Read, A row (being modified) is locked until committed. In Serializable, A block/dataset/table (being modified) is locked until Serialization Terminated. TCL/Transaction …

Continue reading

Feb 27

ChatGPT Prompt Engineering Concepts

Provide Context Provide Delimeters Use Detailed Instructions Refactor Prompts Let ChatGPT ask questions for clarifications Split complex Tasks Use Custom Settings (you can keep the context in the custom settings) : Use multi-modality (voice, image) Socratic Prompting Use Dall-E 3 “DALL·E 3 is built natively on ChatGPT, which lets you use ChatGPT as a brainstorming …

Continue reading