

REF: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/lnpls/CREATE-FUNCTION-statement.html
Mar 26
Tools for data integration, ETL (Extract, Transform, Load), and data management.
Ref: Internet
Mar 14
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 Medium Nolte Medium Loren Medium
Mar 14
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 Control Language Commands
COMMIT
SET AUTOCOMMIT OFF/ON
ROLLBACK
SAVEPOINT
ROLLBACK TO SAVEPOINT
Feb 27
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
“DALL·E 3 is built natively on ChatGPT, which lets you use ChatGPT as a brainstorming partner and refiner of your prompts. Just ask ChatGPT what you want to …” DALL-E: Text to image Model. DallE: ask chat gpt to create image (this may use DALLE). DallE has multi-modality.
Use proper data controls (
“Data Controls offer you the ability to turn off chat history and easily choose whether your conversations will be used to train our models. They also give you the option to export your ChatGPT data and permanently delete your account. You can find Data Controls under the Settings menu in ChatGPT. ” Ref: https://help.openai.com/en/articles/8983077-what-are-the-data-controls-settings
) You can configure Data Controls from Settings.
Delimeters:
“Delimiters are a sequence of characters or symbols that help ChatGPT understand where important places or distinct sections are located in your prompt. They play a crucial role in helping the model to understand your prompt’s structure.Oct 8, 2024″ Ref: https://libguides.uvic.ca/promptdesign/delimiters
Personas: Tell VhatGPT who you are and then what you want
Feb 24
Feb 24
From: https://thedigitalprojectmanager.com/
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:
5. Aha!“
Tools for Enterprise software requirement management
From Chatgpt:
1. IBM Engineering Requirements Management DOORS
2. Jama Software
3. Microsoft Azure DevOps
4. Helix RM (formerly TestTrack)
5. Atlassian Jira
Feb 11
How to Get Started with Talend Open Studio for Data Integration
Source:
https://www.talend.com/resources/get-started-talend-open-studio-data-integration
