A join is a query that extracts data from two or more tables, views or snapshots or we can say A join is a query that combines rows from two or more tables, views, or materialized views. Types of join INNER JOIN 1 Equi join 2 Non Equi join OUTER JOIN 1 Left outer join 2 Right outer join 3 Full outer join SELF JOIN CROSS JOIN Learn more on www.pravendragaur.com like my page https://www.facebook.com/pravendragaur.biz/
Views: 96 Pravendra Gaur
for more videos login on www.pravendragaur.com Aggregate functions return a single result row based on groups of rows, rather than on single rows. Aggregate functions can appear in select lists and in ORDER BY and HAVING clauses. They are commonly used with the GROUP BY clause in a SELECT statement.
Views: 48 Pravendra Gaur
Oracle Database11g tutorials 10 || SQL Single Row Function (SQL Functions ) by Pravendra Gaur. Like subscribe my channel Pravendra Gaur , I will teach you how to crack interviews and many other technologies. Like me on facebook https://www.facebook.com/pravendragaur.biz/ Email : [email protected] Oracel single row function. Character functions Upper Lower Initcap Concat Substr Instr Length Lpad Soundex Ltrim Rtrim Replace Regexp_count
Views: 102 Pravendra Gaur
Learn more on www.pravendragaur.com Constraints are the rules which applied on data columns on table. These are used to limit the type of data that can go into a table. This ensures the accuracy and reliability of the data in the database. Constraints could be column level or table level. Column level constraints are applied only to one column, whereas table level constraints are applied to the whole table. Types of Constraints 1. Unique 2. Not null 3. Primary Key 4. Check 5. Foreign Key
Views: 178 Pravendra Gaur