Edu Flee | Online Learning Portal

Regular Expression in Oracle SQL Regular Expression in Oracle SQL is a pattern matching technique to retrieve sort of data based on the conditions given in Oracle database. Pattern Matching is similar to functions like, replace, substring and in string which are previously seen topics. At the end of this article there will be certain task to practice for this Regular Expressions. It is very important to be very clear about this topic, this are very helpful for many interview Questions. Using regular expressions with Oracle Database: Overview Regular Expression is one of the easiest way to learn with clear understanding if one are familiar with the below Basic string matching patterns, Quantifiers, Meta characters, Functions etc. Note : The above points should understand clearly means it will be very easy to write a query. Basic String Matching with Regular Expressions | Either or  () Group \ Escape ^ Start $ Stop Literals of regular expression in oracle sql [ a b c ] a, b, c [^ a

Data Types in Oracle SQL with examples Data Types in Oracle SQL is used to define the operations that can be used to any variable or any other parameters or any columns. List of Data Types in oracle SQL The below list of important data types in oracle sql are given below :- Character Data types Numerical data types long objects Date and time data types Character Data Types Character Data type is used for string based objects are variables, alphanumeric characters. And this Character Data type can be used in different data type. CHAR VARCHAR VARCHAR2 CHAR Char means Character, it is a data type that used in string of any variables or objects. It is a static data type, so the size of the data type is fixed Performance : Char data type is speed when compared to the VARCHAR2 data type, but memory wise it will consume more. VARCHAR Varchar is also a Character data type used for string of any variables or objects. It is a variable data type, so the size of the data type is not fixed. So this