Posts

Showing posts with the label sql-functions

Featured Post

How to Compare Text in Python

Image
Python like other programming languages supports comparison operators. These primarily use to test the condition in the program. Here's a list of operators that you can use in python programs. Comparison operators List of operators < <= > >= == != Is is not How to use comparison operators Here, I have assigned 23 to a and 11 to b. Then, I did apply all the comparison operators. The output is self-explanatory, and If you are in doubt while programming, remember to visit this page. Examples a = 23 b = 11 print("Is a greater than b?", a > b)           #greater than print("Is a less than b?", a < b)              #less than print("Is a greater or equal to b?", a >= b)   #greater or equal print("Is a less or equal to b?", a <= b)      #less or equal print("Is a equal to b (option 1)?", a == b)         #test for equality print("Is a equal to b (option 2)?", a is b)         #test for equality print("I

4 Built-in functions in SQL Explained Superbly

Image
Here're four types of built-in functions in SQL. You don't need to create these functions, and these come with your SQL. I am discussing today the  SQL functions List . SQL functions DATE-TIME functions Numeric functions Char functions 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 SQL tips to improve Query performance Summar