Edu Flee | Online Learning Portal

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

Introduction to basics of oracle SQL course Let's start a brief introduction about the basics of oracle SQL course, which was already revised in the sql basic courses. In this second part of the basics we going to discuss some important operators, alias name usage and others etc.. Overview to basics of Oracle SQL course Basic is the root of all interviews and also useful for Oracle certification courses. In this part we cover the below listed topics in basics of oracle SQL course : Alias name Dual Table (also called as Dummy Table) Operators in oracle Comment What is mean by NULL ? Usage of CONCAT ( || ) Brief explanation about the basics of Oracle SQL course The above listed overview are explained briefly below, so if any doubts means take a screenshot and send to official mail of eduflee. Alias Name Alias Name is used to rename the column heading. while we are writing any expression means it will shows in column heading instead we can use alias Name. WITHOUT ALIAS NAME WITH ALIAS

Basics of Oracle PLSQL Basics of Oracle PLSQL, helps to know more about PLSQL and its importance, before going for PLSQL be clear with SQL basics . What is PLSQL and its abbreviation ? PLSQL stands for Procedural Language extensions to Structured Query Language. In SQL we can't able to write business logics and there will be lot of limitations are there, so to overcome those limitations we go for PLSQL. So this can be proceeded by loop the list of SQL statements inside the single block and it will be executed. Advantages of Using PLSQL Performance wise it is high. As well it will reduce Network Traffic. It is one of the embedded language. Portable - so you can use it anywhere. Easily accessible, readable and friendly  Some Important basics of Oracle PLSQL List of some important points to be noted in basics of Oracle PLSQL which are listed below. PLSQL OBJECTS  As we already know more about the SQL objects, so in the same way PLSQL objects are there that can be stored in a database