Apache Hive

  • String/Character Manipulation functions in Oracle PL/SQL, Apache Hive

    Function Name Description Example Usage Result CONCAT Concatenates two strings. SELECT CONCAT(‘Oracle’, ‘PL/SQL’) FROM dual; OraclePL/SQL ` ` (Concatenation) Concatenates two strings. LENGTH Returns the length of a string. SELECT LENGTH(‘Oracle’); 6 LOWER Converts all characters in a string to lowercase. SELECT LOWER(‘ORACLE’); oracle UPPER Converts all characters in a string to uppercase. SELECT UPPER(‘oracle’);…

  • Date and Time manipulation in Oracle SQL, Apache Hive QL, Mysql

    Date and Time manipulation in Oracle SQL In Oracle SQL, date and time manipulation is essential for many database operations, ranging from basic date arithmetic to complex formatting and extraction. Here’s a guide covering various common operations you might need. 1. Basic Date Arithmetic Adding/Subtracting Days: Adding/Subtracting Months: Adding/Subtracting Years: 2. Extracting Components from Date…

Subscribe