For Java Platform: Ref: https://www.jooq.org/
Category: Root
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 () …
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 …
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 …
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 …
Feb 24
Requirements Management Software
From: https://thedigitalprojectmanager.com/ “10 Best Requirements Management Tools Shortlist Here’s my pick of the 10 best software from the 18 tools reviewed. From ChatGPT: “Here’s a list of the most advanced tools for managing business requirements in software development jobs. These tools focus on capturing, managing, and collaborating on business requirements efficiently: 1. Jira 2. Confluence …
