Featured Post

Python Regex: The 5 Exclusive Examples

Image
 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

PL/SQL Sample code and error handling mechanism

SAMPLE PL/SQL


CREATE TABLE dummy
( dummy_value       VARCHAR2(1));
DECLARE
  -- Define local variable.
  my_string VARCHAR2(1) := ' ';
  my_number NUMBER;
BEGIN
  -- Select a white space into a local variable.
  SELECT ' ' INTO my_string FROM dummy;
  -- Attempt to assign a single white space to a number.
  my_number := TO_NUMBER(my_string);
EXCEPTION
 WHEN no_data_found THEN
   dbms_output.put_line('SELECT-INTO'||CHR(10)||SQLERRM);
END;
/

Output and Error:
The program returns the following output, which illustrates formatting user- defined exceptions. 

The CHR(10) inserts a line return and provides a clean break between the program's SQLCODE and SQLERRM messages:

RAISE my_error SQLCODE [1] 
SQLERRM [User-Defined Exception]

Comments

Popular posts from this blog

Explained Ideal Structure of Python Class

6 Python file Methods Real Usage

How to Decode TLV Quickly