Featured Post

Python Regex: The 5 Exclusive Examples

 Regular expressions (regex) are powerful tools for pattern matching and text manipulation in Python. Here are five Python regex examples with explanations: 01 Matching a Simple Pattern import re text = "Hello, World!" pattern = r"Hello" result = re.search(pattern, text) if result:     print("Pattern found:", result.group()) Output: Output: Pattern found: Hello This example searches for the pattern "Hello" in the text and prints it when found. 02 Matching Multiple Patterns import re text = "The quick brown fox jumps over the lazy dog." patterns = [r"fox", r"dog"] for pattern in patterns:     if re.search(pattern, text):         print(f"Pattern '{pattern}' found.") Output: Pattern 'fox' found. Pattern 'dog' found. It searches for both "fox" and "dog" patterns in the text and prints when they are found. 03 Matching Any Digit   import re text = "The price of the

4 Built-in functions in SQL Explained Superbly

Here're four types of built-in functions in SQL. You don't need to create these functions, and these come with your SQL.

sql built-in functions with examples

I am discussing today the SQL functions List.

SQL functions

  1. DATE-TIME functions
  2. Numeric functions
  3. Char functions
  4. Null-related functions

1. DATE-TIME functions
These are useful to get DATE and Time. Also, you can covert the DATE and TIME to Char. These are TO_CHAR, CURRENT_DATE, and CURRENT_TIME.

2. Numeric Functions
These functions you can use for numeric calculations. Those are TRUNC, SIGN, ROUND, ABS.

3. Char Functions
To handle string-related tasks you can use CHAR functions. The CHAR functions are like SUBSTR, CONCAT, LENGTH.

4. NULL related functions
To handle null values you can use different functions. Those are COALESCE, NVL, NULLIF

This post covered all your answers for the SQL functions list, SQL built-in functions in Oracle, and SQL functions in any DBMS.

Also, Read


I have explained in this post about four different types of SQL built-in functions for your quick reference.


Popular posts from this blog

Explained Ideal Structure of Python Class

6 Python file Methods Real Usage

How to Decode TLV Quickly