Home
Search results “Sql exist in oracle”
EXIST Function in SQL
 
08:04
Join Discussion: http://www.techtud.com/video-lecture/exist-function-sql IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 38115 Techtud
How to use exists statement
 
03:30
Hello Friends In this video i'm going to show you how to use exist in subquery step by step. #exists #oracletutorial #sql
Views: 6384 OCP Technology
IN VS EXISTS VS JOIN, performance
 
05:04
This video demonstrates the performance effects of using an exists clause instead of an IN clause, also it shows how we can update a simple sub query having an IN clause with an EXISTS or JOIN statement. It also shows that joining would consider the null data, where as an IN clause would neglect null values. If you want more such videos of exciting and amazing 'difference between' concepts, check out the links below : union and union all : https://youtu.be/n9FqQOd8liY char and varchar2 : https://youtu.be/039qzwjWf4k replace and translate : https://youtu.be/HKYF77BGzOE procedure and function : https://youtu.be/q3LmOenL120 rank and dense_rank : https://youtu.be/WGSX998hZ9M delete and truncate : https://youtu.be/u76wMm2byXo %type and %rowtype : https://youtu.be/MlLUFeZ_3eM
Views: 12706 Kishan Mashru
The SQL EXISTS clause
 
08:52
How to use the EXISTS clause in SQL. For beginners.
Views: 24046 Database by Doug
SQL Tutorial for beginners: Difference Between IN and EXISTS Operators in Oracle
 
06:58
Difference Between IN and EXISTS Operators in Oracle SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 827 TechLake
SQL tutorial 41: How to UNLOCK USER in oracle Database
 
04:13
SQL tutorial on How to unlock user or schema in oracle database or how to unlock hr account/user/schema in oracle database using alter user SQL command. you can use the steps to change the password of any user in oracle database explained in detail. Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------- Blog Link: http://bit.ly/unlock-user-in-oracle -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/ Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 39876 Manish Sharma
095- Oracle SQL 12c: Correlated Subquery / Exists /not exists
 
12:54
تعلم اوراكل حتى الاحتراف EXAM 1Z0-061 EXAM 1Z0-071
Views: 1904 khaled alkhudari
SQL Error ORA-00942 Table or View Does Not Exist in Oracle Database
 
05:03
How to use Tab View (Data Dictionary) of Oracle Database to solve the SQL Error ORA-00942 Table or View Does Not Exist error in Oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/ora-00942 Previous Tutorial ► ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 7737 Manish Sharma
Урок 27. SQL. Подзапрос EXISTS
 
06:54
Oracle SQL.Подзапрос EXISTS является наиболее сложным типом подзапроса в SQL. Но мы попробуем разобраться, здесь очень важно Осознать, что подзапрос EXIST Является предикатом, возвращает нам либо истину либо ложь, то есть в подзапрос EXIST это критерий того, будет на экран выведена данная строка либо нет. Также подзапрос EXISTS подразумевает внешнее объединение то есть внутренний подзапрос связывается определённым отношением с внешним запросом учебная среда https://apex.oracle.com/pls/apex/ схема: SQLADV польз: student1 пароль: student1 будут работать (student2/ student2, student3/ student3 .... student11/ student11) меню SQL Workshop , SQL Command или используйте http://sqlfiddle.com/ скрипт бд для загрузки в sqlfiddle http://sqladv.ru/dev/sql.txt урок и задания http://sqladv.ru/dev/sqlbasic/l27.txt
Oracle Database 12c Tutorial  2: How To Unlock HR schema in Oracle Database 12c
 
07:18
Learn how to unlock HR user / Schema in Oracle Database 12c. Step by step procedure of unlocking the HR Schema in Oracle 12c By Manish Sharma a.k.a RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/how-to-unlock-hr-user-in-oracle-database-12c Previous Tutorial ► Tut 60: How To Install 12c On Windows 7: http://youtu.be/T-rCbe1MMG4 ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 85977 Manish Sharma
Oracle da SQL asoslari 34 NOT IN, NOT EXISTS
 
03:25
Darslar rivojiga hissa qo'shishni istovchilar uchun PayMe: 8600 1309 2342 8959 WEB MONEY ID: Z193564615070 yoki R769659687039
SQL tutorial 60: SQL View in Oracle Database By Manish Sharma RebellionRider
 
07:30
SQL View in Oracle Database. In this tutorial you will learn how to create a vie as well as how to replace a view along with the examples of all the DML e.g. DESCRIBE, SELECT, UPDATE, INSERT and Delete on view by Manish Sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/sql-view-in-oracle-database Previous Tutorial ► Tut 5: SELECT statement http://youtu.be/f_mVBVgnqmM ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 43259 Manish Sharma
Database - SQL WITH Clause
 
08:40
Using the With Clause for complex queries in SQL
Correlated Subqueries with EXISTS & NOT EXIST operators - Oracle SQL Certification Course
 
21:14
Full Playlist link : https://www.youtube.com/playlist?list=PLovUiB6V4l0qdB1MEnHXCUuW6qH5y4FMp Don’t just learn the SQL Language, Become Job-Ready and Launch Your Career as a Certified Oracle SQL Developer! What you’ll learn Become Job Ready to Start Contributing as Database Developer Day 1 Pass the Oracle SQL Fundamentals Examinations Program in the SQL Language to solve a variety of Database Problems Be a SQL Ninja and understand how the Oracle Database Works
Views: 1 UNIQLY TUT
GROUP BY with Multiple Columns (Introduction to Oracle SQL)
 
04:03
Learn how to group with multiple columns using GROUP BY in SQL. The full Introduction to Oracle SQL course is available here: https://www.databasestar.com/introduction-to-oracle-sql-course/
Views: 1852 Database Star
35. SQL EXISTS, how EXISTS differ from IN
 
18:49
The SQL EXISTS clause How to use the EXISTS clause in SQL. For beginners. How to use exists statement Hello Friends In this video i'm going to show you how to use exist in subquery step by step.
Views: 985 ProSchool
서브 쿼리 SubQuery IN ANY SOME ALL EXISTS : 오라클 강좌 2016 SQL & PL/SQL 잠자리채널 jamjalee oracle
 
11:02
잠자리 오라클 SQL & PL/SQL 2016에 대한 강좌입니다. 단일행 서브 쿼리, 다중행 서브 쿼리 IN ANY SOME ALL EXISTS 연산자 ▶ https://goo.gl/NmQBOL ▶ 자세히 보기 ▶ ※ 유튜브 잠자리채널 youtube jamjalee channel ▶ http://goo.gl/YluPrC ※ 잠자리채널 구독 jamjalee channel subscribe ▶ https://goo.gl/qx2Jbp ※ 홈페이지 jamjalee homepage ▶ http://goo.gl/nRYDti ※ 동영상 재생목록 youtube jamjalee channel playlist ● 잠자리 소프트웨어 아키텍처 2016 ▶ https://goo.gl/WYeEUD ● 잠자리 오라클 SQL & PL/SQL 2016 ▶ https://goo.gl/NmQBOL ● 잠자리 자바 8 프로그래밍 java programming tutorial ▶ https://goo.gl/YlHDcy ● 잠자리 워드프레스 사용법 wordpress tutorial ▶ https://goo.gl/PXCD91 ● 잠자리 마인크래프트 2016 사용법 minecraft 1.8.3 tutorial ▶ https://goo.gl/pHTs3d ● 잠자리 더 위쳐 와일드 헌트 The Witcher 3 Wild Hunt tutorial ▶ https://goo.gl/AHkSgK
Views: 2102 잠자리코딩
PL/SQL tutorial 60: Collection Method EXISTS in Oracle Database by Manish Sharma
 
05:21
RebellionRider presents you the latest PL/SQL Tutorial 60 on Collection method EXISTS by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/exists-function Previous Tutorial ► ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 7741 Manish Sharma
Oracle Sql : Exists Clause
 
21:26
Topic : Exists Clause 19th Video of this Series Comments/Suggestions are welcome get in touch with us, by mailing [email protected] for Upcoming trainings. This is an Unedited Video from the Live sessions on Sql (RDBMS) I will be posting a complete series of these tutorials on this channel, If you would like to be notified every time i post something ; Please subscribe to this channel and press the bell icon.
Views: 56 CodeSmith 001
Difference between IN and EXISTS clause in database
 
04:18
Difference between IN and EXISTS clause in database
Views: 744 Techie Savy
insert data that not exist in second table in oracle sql.
 
03:28
this tutorial in insert data that not exist in second table means you can select the who table. in oracle you have to learn about all concept and query that help full in features. #insert #oracletutorial #oracleprogramming #multiinsert
Views: 13 EasyWay Coding
ORACLE SQL AND PL/SQL INTERVIEW QUESTION : SUBQUERY WITH IN / EXISTS OR SELF JOIN
 
09:31
This video demonstrates the solution of the oracle sql interview question like, find the employees where there manager's salary is more than 15000. This is a classic example of using a subquery or a self join to get the result.
Views: 2756 Kishan Mashru
Let's Learn SQL! Lesson 82 : EXIST and NOT EXIST Subqueries
 
03:37
Explore SQL with Tom Coffing of Coffing Data Warehousing! In this lesson, learn about EXIST and NOT EXIST Subqueries!
How to connect to an Oracle Database? - Database Tutorial 37
 
12:37
Video 37 - How to connect to a Oracle Database? - Database Tutorial 37 This video explains how to connection to an oracle database. The database, which is Oracle 11g has been installed in a Windows 7 computer.
Views: 122216 Sam Dhanasekaran
SQL SELECT - 13 - SUBCONSULTAS: EXISTS
 
03:57
Todo lo que necesitas en http://tutorialesnet.net
Views: 7158 TutorialesNET
Oracle PL/SQL - Why does it exist?
 
08:04
Oracle PL/SQL - Why does it exist?
Views: 2456 Chris Ostrowski
How to Start,Stop Pluggable database-Oracle 12C administration
 
09:32
How to Start,Stop Pluggable database-Oracle 12C administration =================================================== Important Command SQL= show con_name; CON_NAME ------------------------------ CDB$ROOT SQL-- sho pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 3 PDB MOUNTED SQL alter session set container=PDB;
Views: 6335 ANKUSH THAVALI
Oracle Database11g tutorials 14 : How to CREATE TABLE using sql developer and command prompt
 
08:36
Oracle Database11g tutorials 14 How to Create table using command prompt and Create table using sql developer Blog Link http://bit.ly/1TkY4Oe Time Line 0:25 Introduction of Tables in Database 1:03 What is Create Table (Introduction of create table) 1:30 Syntax of Create Table 2:08 How to create table using Command Prompt 4:55 How to create table using SQL Developer Links for Oracle Database tutorials 4: database connectivity using SQL developer and command prompt http://youtu.be/wSqoXRlXDUU You can have indepth knowledge about SQL create table here http://www.rebellionrider.com/sql-create-table.html Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com Today in this oracle database tutorial we will see How to CREATE A TABLE. if we have to define a table in layman language then we can say that Tables are just a collection of Rows and Columns but In RDBMS tables are database objects which help in organizing data into ROWS and COLUMNS. We can also say that SQL tables are kind of data structure which are used by database for efficient storage of data. To create a table in our database we use SQL CREATE TABLE command. SQL CREATE TABLE is a type of DATA DEFINITION LANGUAGE also known as DDL. To Create a table in your schema you will require CREATE TABLE system privilege. In our future videos we will see what are system and object privileges and how to grant them to a user. Today for this video we will be using Sample schema HR which already has all the necessary privileges. Ohk Let's see the syntax. CREATE TABLE table name ( column name1 Data-Type(size), column name2 Data-Type(size), ..... ); CREATE TABLE is an oracle reserved word or say an Oracle key word whereas There are 3 different ways of creating a table in Oracle database. Creating a table using Command Line Interface (CLI) in Oracle database For demonstrating how to create table in oracle database using CLI, I'll be using Command prompt. Thats how we create table using command prompt. you can check your table structure by DESCRIBE command for that just write DESC and your table name. Like this Another way of creating a table is by using Graphic user interface (GUI) in Oracle database To demonstrate how to create table using GUI we will use SQL developer. Lets open our SQL developer I am connected to HR schema if you do not know how to create a connection to database using SQL developer please watch my oracle database tutorial 4 that explains database connectivity using SQL developer and command prompt. Link for this video is in the description below. So lets create a table. Creating a table using SQL developer is very easy we do not have to fire any query here. Let's start First of all right click on your connection in which you want to create a table and choose schema browser. This will open a separate schema browser pane or you can expend your connection by clicking this + sign and then right click on table and choose New Table. However I prefer working with schema browser so let's skip to schema browser pane here from the first drop-down list you can choose connection name and in the second drop down list you can choose what database objects you want to work with we want to create a table thus I'll choose table and then click this arrow here and choose option for new table Ok we have created a table wizard first of all give a unique name to your table and add some column as well. For this, click the green plus button. Now we already have a column so give it some name. Also choose a datatype from the list and specify any size you can check this not null column if in case you want to make this a mandatory column you can also specify default value and constraint If you want to make this column a primary key you can click here In my future video i'll show you what are these constraints and different ways of applying them on a column in a table. for this video we will concentrate on create table only so when you are done with all your columns click ok Thats your table You can double click on your table here and can see its structure. Thats it
Views: 183405 Manish Sharma
DIFFERENCES BETWEEN IN AND EXISTS OPERATOR
 
18:11
IN AND EXISTS OPERATORS
Views: 2279 SAINAATTH PITTLA
MySQL Tutorial #12 in Hindi: SubQuery(Nested Query) with EXISTS and NOT EXISTS Clause
 
11:37
MySQL Tutorial #12 in Hindi: SubQuery(Nested Query) with EXISTS and NOT EXISTS Clause - Solved Examples MySQL tutorial for Beginners MySQL Installation Guide How to Install MySQL on windows 10
Oracle SQL Tutorial : Using execution plan to optimize query in oracle
 
12:54
Oracle SQL Tutorial Oracle tutorial: Explain plan for query optimization in Oracle PLSQL oracle tutorial for beginners using execution plan to optimize query sql query analyzer sql query cost analysis https://techquerypond.wordpress.com This oracle tutorial show you how to use EXPLAIN PLAN in oracle. This video covers how to check cost of the query from DBMS_XPLAN.DISPLAY . You can find the cost of the query using the Using EXPLAIN PLAN FOR and based on the result you can optimize the query for faster performance. Subscribe on youtube: https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA For more tutorial please visit #techquerypond https://twitter.com/techquerypond
Views: 13171 Tech Query Pond
SQL 136 Subselect, EXISTS with Subselects
 
03:37
Explains how EXISTS with subselects work. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.
Views: 4878 cbtinc
SQL Tutorial 12 Advanced Subqueries returning multiple columns
 
14:22
SQL Tutorial on Advanced Subqueries returning multiple columns Check out our website: http://www.telusko.com Follow Telusko on Twitter: https://twitter.com/navinreddy20 Follow on Facebook: Telusko : https://www.facebook.com/teluskolearnings Navin Reddy : https://www.facebook.com/navintelusko Follow Navin Reddy on Instagram: https://www.instagram.com/navinreddy20 Subscribe to our other channel: Navin Reddy : https://www.youtube.com/channel/UCxmkk8bMSOF-UBF43z-pdGQ?sub_confirmation=1 Telusko Hindi : https://www.youtube.com/channel/UCitzw4ROeTVGRRLnCPws-cw?sub_confirmation=1
Views: 64580 Telusko
IN v/s EXISTS v/s JOIN, which one will give better performance under what condition?
 
04:56
This video demonstrates the performance effects of using an exists clause instead of an IN clause, also it shows how we can update a simple sub query having an IN clause with an EXISTS or JOIN statement. It also shows that joining would consider the null data, where as an IN clause would neglect null values.
Views: 1153 Kishan Mashru
Using Exists Clause With Correlated Subquery in Oracle Database
 
08:07
Exists Clause in Correlated Subqueries with Oracle Database
Views: 35 Adam Tech
SQL CASE
 
05:44
Jamie King of Neumont University demonstrating CASE.
Views: 31920 Jamie King
Oracle sql materialized view refresh complete
 
25:01
Oracle sql materialized view refresh complete
Views: 7370 Sridhar Raghavan
Oracle Database11g tutorials 16: How to uninstall oracle 11g from windows 7 64 bit
 
08:49
How To Properly Uninstall oracle database 11g from windows 7 and 8 manually without formatting your Computer By Manish Sharma Rebellion Rider Blog Link http://bit.ly/uninstall-oracle-11g-from-win-7 Website: www.RebellionRider.com Manual Un-Installation of Oracle Database 11g. This video will show you proper process on uninstalling Oracle database 11g from windows 7 64 bit. How to uninstall oracle 11g on windows 7 / How to uninstall oracle 10g on windows 7 Read How to uninstall oracle 11g on windows http://www.rebellionrider.com/how-to-uninstall-oracle-database-11g-from-windows-7.html YouTube Video on How to create database http://bit.ly/create-database-using-DBCA Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Views: 258986 Manish Sharma
SQL Tutorial - 23: The LIKE Operator and Wildcard Characters
 
07:36
In this tutorial we'll check out a few examples of the LIKE Operator along with the wildcard characters (% and _).
Views: 64922 The Bad Tutorials
Understanding Correlated Queries in SQL
 
08:13
Join Discussion: http://www.techtud.com/video-lecture/understanding-correlated-queries-sql IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 52129 Techtud
Difference between Case and Decode
 
10:14
This video tutorial explains on how case statement and decode function are different from each other. Though both of them are used in giving the if-then-else conditional functionality to sql statement, they differ much from each other, this video will walk through each of the difference with appropriate examples. If you want more such videos of exciting and amazing 'difference between' concepts, check out the links below : char and varchar2 : https://youtu.be/039qzwjWf4k replace and translate : https://youtu.be/HKYF77BGzOE procedure and function : https://youtu.be/q3LmOenL120 in and exists : https://youtu.be/REX4IjRYlFw rank and dense_rank : https://youtu.be/WGSX998hZ9M delete and truncate : https://youtu.be/u76wMm2byXo %type and %rowtype : https://youtu.be/MlLUFeZ_3eM
Views: 13046 Kishan Mashru
EXISTS Condition in Oracle Database
 
11:07
#Exists oracle exists vs in, if exists in oracle, oracle not exists vs not in, difference between in and exists in oracle, case when exists oracle, oracle check if record exists, if not exists in oracle, oracle update where exists
Views: 31 Adam Tech
Oracle DECODE Function
 
04:31
https://www.databasestar.com/oracle-decode-function/ The Oracle DECODE function lets you perform IF-THEN-ELSE functionality in your queries. It’s similar to a CASE statement. The syntax of the DECODE function is: DECODE ( expression, search, result [, search, result]... [,default] ) The parameters of the Oracle DECODE function are: - expression (mandatory): This is the value to compare. - search (mandatory): This is the value to compare against the expression. - result (mandatory): This is the return value if the search value matches the expression value. There can be multiple combinations of search and result values, and the result value is attached to the previous search value. - default (optional): If none of the search values match, then this value is returned. If this is not provided, the DECODE function will return NULL if no matches are found. If you compare this to an IF-THEN-ELSE statement, it would look like this: IF (expression = search) THEN result [ELSE IF (expression = search) THEN result] ELSE default END IF The parameters can be one of many different data types, and the return type is calculated from them. Earlier I mentioned it’s similar to CASE. So why would you use one and not the other? - DECODE is an older function, and CASE was introduced as a replacement for DECODE. - CASE offers more flexibility then DECODE - CASE is also easier to read and debug (in my opinion) The performance of these functions is the same, so if you’re considering using DECODE, I would suggest using CASE instead. For more information about the Oracle DECODE function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-decode-function/
Views: 746 Database Star
Understanding the use of GROUP BY clause in SQL
 
04:39
Join discussion: http://www.techtud.com/video-lecture/understanding-group-clause-sql IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 74026 Techtud
Oracle sql Interview Question : How to change rows to column
 
09:18
This video tutorial talks about the frequently asked oracle sql interview question of changing rows to the column. Based on the given scenario, we are asked to change the presentation of data in a table with 3 rows and 2 column to 3 columns and 2 rows. Decode Function in oracle https://youtu.be/YUAjPMjqMws Pivot and unpivot in oracle https://youtu.be/6s0DI1YcWIM
Views: 17021 Kishan Mashru
Pegadinha da Semana Ep. 17 P1 - SQL Exists e Not Exists - Prof. Eduardo Neves 2015
 
26:44
Esta é uma amostra em vídeo de um Curso completo sobre o tema. Mais informações em: http://www.ProvasdeTI.com.br/ Confira também nossa plataforma de simulados para quem está se preparando para Concursos Públicos ou Certificações na área de TI: http://www.Gabaritou.com.br/
Views: 1429 Portal Provas
3 Tips for Working with PLSQL in Oracle SQL Developer
 
06:33
See very quickly how to click to object declarations, test/execute SQL, and use the code outline in Oracle SQL Developer when working with PL/SQl.
Views: 1509 Jeff Smith