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

Isolation => I in ACID

Supported two types:

• Read Committed
• Serializable

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

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 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

• Socratic prompting: it involves asking and answering questions. This is how it stimulates critical thinking and generate ideas. Ref: Internet

Personas: Tell VhatGPT who you are and then what you want

• Github CoPilot for Visual Studio: “Copilot Free and Visual Studio 2022 help you generate, refactor, and debug code, identify bugs and resolutions, optimize performance, and get context specific help throughout your coding workflow.” Ref: https://visualstudio.microsoft.com/
• “Visual Studio 2022 Mainstream TBD January 2032″: https://learn.microsoft.com/en-us/visualstudio/productinfo/vs-servicing
• Visual Studio: “As of February 24, 2025, the latest version of Visual Studio is Visual Studio 2022 version 17.13, released in February 2025.”
• “As of February 24, 2025, the latest version of .NET is .NET 9.0, released in November 2024.” ChatGPT
  • Features: AI Integration (.Net Aspire), Cross-Platform Improvements, C# 13 Support,
• .Net 9 Features: https://learn.microsoft.com/en-us/dotnet/core/whats-new/dotnet-9/overview
• C# web development latest technologies
  • ASP.NET Core (Cross Platform), Blazor (Interactive Web UI), Entity Framework Core (EF Core) (ORM), SignalR (Real time Web Functionality), gRPC (gRPC-Web) (Remote Procedure Call), Docker and Kubernetes with C#, Azure Web Apps and Azure Functions, MediatR (for separation of concerns), Razor Pages (Page Model, Web UI), IdentityServer and OpenID Connect (SSO, oAuth2), Swagger and OpenAPI, Nginx and C# Integration

From: https://thedigitalprojectmanager.com/

“10 Best Requirements Management Tools Shortlist

Here’s my pick of the 10 best software from the 18 tools reviewed.

1. 1. Jama Software — Best for enterprises
2. 2. ReqSuite® RM — Best for innovative, mid-sized companies
3. 3. ReqView — Best for end-to-end traceability
4. 4. Modern Requirements — Best for DevOps
5. 5. Visure Requirements — Best for enterprise-level customizability
6. 6. codebeamer — Best for out-of-box API integrations
7. 7. ReQtest — Best for agile requirements gathering
8. 8. xebrio — Best for requirements communication
9. 9. Doc Sheets — Best for scalability
10. 10. Perforce Helix RM — Best for test case management“

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

• Best for: Agile project management, requirements tracking, and issue tracking.
• Features: Customizable workflows, backlog management, real-time collaboration, and reporting.

2. Confluence

• Best for: Documentation and collaboration, especially when paired with Jira.
• Features: Wiki-style documentation, real-time collaboration, requirement templates, and version control.

3. Microsoft Azure DevOps

• Best for: End-to-end lifecycle management, including requirements, development, and deployment.
• Features: Boards for tracking user stories, advanced reporting, and integrations with other tools.

4. IBM Engineering Requirements Management (DOORS)

• Best for: Large, complex systems and highly regulated industries.
• Features: Traceability, version control, impact analysis, and compliance tracking.

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