Home
Search results “Decode oracle mysql”
How to Pivot (Flip) Tables with SQL CASE & DECODE
 
04:25
Pivoting tables (columns to rows, rows to columns) is a common data analysis requirement. Learn how to accomplish this with Oracle SQL CASE and DECODE
Views: 1740 SkillBuilders
DECODE FUNCTION IN ORACLE SQL
 
09:36
This video tutorial explains with proper example on how to write a decode statement, this video also demonstrates how the decode statement behaves on null values and implicit datatype conversion that happens in a decode statement.
Views: 2287 Kishan Mashru
SQL Tutorial : Difference Between Count(1) and Count(*)  in SQL Oracle
 
06:43
SQL Tutorial : Difference Between Count(1) and Count(*) in SQL 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: 2836 TechLake
SQL CASE
 
05:44
Jamie King of Neumont University demonstrating CASE.
Views: 29858 Jamie King
Oracle Database Tutorial - SELECT Operators - DECODE, CASE, NVL, NVL2, SUM, COUNT etc
 
21:30
This video tutorial on Oracle database provides detailed information on various operators used in SELECT statements. You can visit Oracle Database related videos here : https://www.youtube.com/watch?v=cDqlT7O8H0Q&list=PLRt-r4QiDOMfMmVU-8145pLcBxIdvAt8f&index=1 Website: http://guru4technoworld.wix.com/technoguru Facebook : https://www.facebook.com/a2zoftech/ Blog: http://dronatechnoworld.blogspot.com
Views: 82 Sandip M
SQL Tutorial - 34: ROUND() Function
 
06:51
In this tutorial we'll see how we can round off numbers conveniently in SQL using the ROUND() Function/
Views: 35381 The Bad Tutorials
SQL: Rank & Dense_rank functions
 
06:47
In this tutorial, you'll learn the difference between rank() and dense_rank() functions..
Views: 26977 radhikaravikumar
Encrypt and decrypt password in mysql database
 
03:49
According to MySQL AES functions (AES_ENCRYPT() and AES_DECRYPT()) were added in MySQL 4.0.2 and are currently the most cryptographically secure encryption functions in MySQL.
Views: 55104 Rahul Bhadana
GROUP BY, ROLLUP and CUBE in Oracle
 
04:09
Here's a quick run through of GROUP BY, ROLLUP and CUBE, along with an example of using the GROUPING function. For more information see: https://oracle-base.com/articles/misc/rollup-cube-grouping-functions-and-grouping-sets Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Kerry Osborne Blog: http://kerryosborne.oracle-guy.com/ Twitter: https://twitter.com/KerryOracleGuy Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 16750 ORACLE-BASE.com
Oracle SQL TUTORIAL – IF condition using CASE and DECODE  - An Example
 
09:31
In this video, we shall see how case and decode is used in real time scenario. SQL used in the video is given below. SELECT * FROM emp_test ORDER BY gender; count_of_employees Count_of_Male_Employees Count OF Female Employees -- 15 5 8 select count(*) " Total Employees" from emp_test; select gender,count(*) " Total Employees" from emp_test group by gender; select sum(decode(gender,'M',1,0)) Count_OF_Male_Employees from emp_test; select sum(case gender when 'F' then 1 else 0 end) as Count_OF_FeMale_Employees from emp_test; SELECT count(*) " Total Employees" , sum(decode(gender,'M',1,0)) Count_OF_Male_Employees, sum(case gender when 'F' then 1 else 0 end) Count_OF_Female_Employees from emp_test;
Views: 53 Ganesh Anbarasu
How to pivot a table in MySQL
 
13:27
What is pivoting and how to pivot a table in MySQL. #### Watch the video in fullscreen at 720p for better quality ### Check this article by stratos for more explanation on pivoting a table http://stratosprovatopoulos.com/web-development/mysql/pivot-a-table-in-mysql/
Views: 15820 Mahtab alam
How to use LTRIM,RTRIM & TRIM functions
 
06:40
How to use LTRIM, RTRIM & TRIM functions step by step.
Views: 5904 OCP Technology
SQL tutorials 20: On Delete Cascade Foreign Key By Manish Sharma (RebellionRider)
 
05:55
Oracle Database 11g Tutorial 20: On delete cascade This tutorial will show you how to define foreign key with on delete cascade clause. Links Blog: http://www.rebellionrider.com/on-delete-cascade.htm SQL Tutorial 19 On delete set Null: http://www.rebellionrider.com/on-delete-cascade.htm SQL Tutorial 19 Foreign Key: http://youtu.be/0nbkBI5r3Gw Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Tool used in this tutorial is SQL Developer. 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. 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 liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Views: 45020 Manish Sharma
Using Select (6) and Decode,NVL,ROUND,TRUNC,MONTHS_Between,SubStr,Instr
 
11:30
Beginner lessen for Oracle statement with Single row function
Views: 1562 Harith Jawad
002 Virtual Columns
 
05:27
Views: 421 Kartik Mundhra
HackTheBox - Lazy
 
26:45
00:39 - Basic Web Page Discovery 03:30 - Examining Cookies - Pt1 (Burp Sequencer) 05:05 - Fuzzing Usernames (2nd Order SQL Injection) 07:15 - Examining Cookies - Pt2 07:40 - Cookie Bitflip 12:45 - Oracle Padding Attack - Pt1 15:30 - Rooting the Box 22:50 - Oracle Padding Attack - Pt2
Views: 20106 IppSec
NULL Value in Oracle Database | Oracle Tutorials for Beginners
 
03:18
NULL Value in Oracle Database | Oracle Tutorials for Beginners NULL Value in Oracle Database NULL Value in Oracle SQL NULL Value in SQL NULL Value in Oracle Database Oracle Tutorials for Beginners Oracle Tutorials for Beginners Oracle PL/SQL Tutorials for Beginners Oracle PL/SQL Tutorials for Beginners Oracle PL/SQL Tutorials for Beginners how to select null values in oracle oracle compare null values in where clause null=null in oracle how to handle null in case statement in oracle how to check null value in oracle stored procedure oracle nvl null value in oracle query how to check empty column value in oracle how to select null values in oracle oracle is null vs = null oracle nvl oracle is not null oracle decode oracle isnull oracle case when null select null from table in oracle oracle compare null values in where clause oracle select null how to check empty column value in oracle oracle sql not null or empty oracle is not null how to handle null in case statement in oracle oracle isnull oracle nvl
Views: 533 Oracle PL/SQL World
How to transpose column to row in sql
 
12:43
Hi friends today we will learn how to transpose column data into row of table. #transposecolumntorow Oracle database Unbeatable,Unbreakable Platform..
Views: 15824 Oracle World
How to Parse XML in Oracle
 
13:54
This Video Shows 1. How to Read and parse XML in Oracle using EXTRACTVALUE and XMLTABLE. 2. When to use extractvalue and XMLTable. 3. Brief Introduction to XMLPATH
Views: 11235 yrrhelp
Função Oracle DECODE
 
10:20
Acesse o desafio: http://novidades.aprendaplsql.com/15-dias-de-funcoes-oracle Códigos da função Oracle DECODE SELECT * FROM hr.employees; SELECT first_name, salary, DECODE (job_id,'IT_PROG', salary * 1.2, salary * 1.1) as aumento_salarial FROM hr.employees; SELECT first_name, salary, DECODE (job_id,'IT_PROG', salary * 1.2, salary * 1.1) as aumento_salarial FROM hr.employees WHERE employee_id = 100 OR job_id = 'IT_PROG'; SELECT first_name, salary, DECODE (job_id,'IT_PROG', salary * 1.2, 'AD_PRES', salary * 1.3) as aumento_salarial FROM hr.employees WHERE employee_id = 100 OR job_id IN ('IT_PROG', 'AD_VP'); SELECT first_name, salary, DECODE (job_id,'IT_PROG', salary * 1.2, 'AD_PRES', salary * 1.3, salary) as aumento_salarial FROM hr.employees WHERE employee_id = 100 OR job_id IN ('IT_PROG', 'AD_VP'); https://www.youtube.com/playlist?list=PLMaqczuL07LkjrX6Rvx6TdNM-1nbUKG8p
Views: 1863 Aprenda PL/SQL
SQL Tutorial in Oracle - 5 Column Alias with Order By
 
11:09
SQL aliases are used to give a database table, or a column in a table, a temporary name. 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: 13093 Telusko
Oracle SYNONYMS - beginner
 
09:21
Oracle SYNONYMS - beginner
Views: 7816 Chris Ostrowski
SQL - Row level transformations - CASE clause, nvl, nvl2, decode
 
19:11
Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/itversity https://github.com/dgadiraju https://www.youtube.com/itversityin https://twitter.com/itversity
Views: 429 itversity
Oracle regular expression part 1 regexp like
 
12:26
Oracle SQL PLSQL and Unix Shell Scripting
Views: 9157 Sridhar Raghavan
MySql 10 | COALESCE Function in MySql
 
03:15
MySQL COALESCE() Function COALESCE Function in MySql
Views: 83 Adam Tech
Lesson 10 - Query Aliases and ORDER BY (Oracle SQL Certification)
 
19:59
In this lesson you'll learn about Ordering, Concatenating and Aliasing Query Results
Views: 3217 Imtiaz Ahmad
SQL TUTORIAL | SINGLE ROW FUNCTIONS | PART-1
 
15:28
In this video i'm going to demonstrate you how to use single row functions in oracle sql step by step.
Views: 2114 OCP Technology
38. Date Functions - Add_Months, Last_Day, Months_Between, Next_Day, To_Date, New_Time in Oracle
 
07:53
In this video you will learn about Date Functions { Add_Months(), Last_Day(), Months_Between(), Next_Day(), To_Date(), New_Time() } in Oracle. Unlike other programming language Oracle also uses functions to perform common operations. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 19214 ITORIAN
PIVOT Tutorial - generating dynamic column with PIVOT Interview Question SQL
 
14:14
In this lecture you will learn about PIVOT operator and using it to generate dynamic columns.PIVOT is very use full operator to convert values into columns. PIVOT: •Convert your output from (values)vertical order to horizontal(making columns) one Topic to cover: •PIVOT example •PIVOT syntax •Interview Question •PIVOT on northwind •Dynamic PIVOT query http://www.techsapphire.in/index/pivot_sql_lesson_with_generating_dynamic_columns_with_pivot/0-158
Views: 28796 techsapphire
Using SOUNDEX Function
 
03:13
Using SOUNDEX Function
Views: 1081 Abe Samir's Academy
SQL Tutorial - 41: SUBSTR(), RIGHT() & LEFT() Functions
 
04:34
In this tutorial we'll see how we can chop off strings and use only parts of them using the SUBSTR(), RIGHT() and LEFT() Functions.
Views: 30300 The Bad Tutorials
replace & substring | sql functions | oracle database 11g version 2 |
 
05:30
executed in oracle database 11g version 2
Views: 114 Education 4u
How to use Pivot and Unpivot? (how to change rows to column and column to rows)
 
10:47
This is a video tutorial on using pivot and unpivot operators to change rows to column and columns to rows when needed, the video also demonstrates a way to change from rows to column without using the pivot operator which can be helpful if you are using and older version of oracle or some other database without the feature of pivot and unpivot. Both the operators are explained with an example for better understanding
Views: 7126 Kishan Mashru
oracle: урок 2 группировки, подзапросы, JOIN
 
13:19
Рассмотрены группровки GROUP BY, конструкции case, decode, подзапросы, join в ORACLE SQL Сайт автора: http://snakeproject.ru/
Views: 7436 Mihail Kozlov
ORACLE SQL INTERVIEW QUESTION : HOW TO SELECT ODD OR EVEN ROWS FROM A TABLE IN ORACLE
 
03:52
This video tutorial answers the frequently asked interview question, how to select only odd or even records in oracle sql, after watching this video you will understand more on the topic and will be able to answer this interview question with a lot of confidence.
Views: 4041 Kishan Mashru
Intermediate To Advanced SQL Queries #2: Pivoting Tables
 
19:54
In this tutorial, we will cover a special case of pivoting tables in SQL using MySQL as a DBMS. Think of pivoting tables as selecting unique values and assigning them to their own columns. The solution code can be found on my website here: http://programmingforfinance.com/2017/10/pivoting-tables-with-mysql/
Views: 2579 codebliss
DUAL Table In Oracle | Oracle Tutorials for Beginners
 
02:51
DUAL Table In Oracle Oracle Tutorials for Beginners Purpose of Dual Table In Oracle Oracle Tutorials for Beginners Oracle pl/sql Tutorials for Beginners Oracle plsql Tutorials for Beginners Dual Table Dual Table in Oracle What is Dual Table In Oracle What is the Purpose of Dual table in oracle? What is meat by Dual table in Oracle Oracle Tutorials for Beginners Oracle pl/sql Tutorials for Beginners Oracle Tutorials for Beginners Oracle pl/sql Tutorials for Beginners Oracle Tutorials for Beginners Oracle pl/sql Tutorials for Beginners Oracle Tutorials for Beginners Oracle pl/sql Tutorials for Beginners
Views: 720 Oracle PL/SQL World
The SQL EXISTS clause
 
08:52
How to use the EXISTS clause in SQL. For beginners.
Views: 22666 Database by Doug
HOW TO RETURN MULTIPLE VALUES FROM A PROCEDURE IN ORACLE PL/SQL? (USING OUT PARAMETERS)
 
04:46
This video tutorial explains how an oracle procedure can return multiple values with a proper example. The video tutorial shows how this problem can be tacked using simple and easy to understand out parameters!!!
Views: 12636 Kishan Mashru
Learn Oracle | How to use the Merge Statement in SQL
 
04:13
Pebbles present, Learn Oracle 10g with Step By Step Video Tutorials. Learn Oracle 10g Tutorial series contains the following videos : Learn Oracle - History of Oracle Learn Oracle - What is Oracle - Why do we need Oracle Learn Oracle - What is a Database Learn Oracle - What is Grid Computing Learn Oracle - What is Normalization Learn Oracle - What is ORDBMS Learn Oracle - What is RDBMS Learn Oracle - Alias Names, Concatenation, Distinct Keyword Learn Oracle - Controlling and Managing User Access (Data Control Language) Learn Oracle - Introduction to SQL Learn Oracle - Oracle 10g New Data Types Learn Oracle - How to Alter a Table using SQL Learn Oracle - How to Create a Package in PL SQL Learn Oracle - How to Create a Report in SQL Plus Learn Oracle - How to Create a Table using SQL - Not Null, Unique Key, Primary Key Learn Oracle - How to Create a Table using SQL Learn Oracle - How to Create a Trigger in PL SQL Learn Oracle - How to Delete Data from a Table using SQL Learn Oracle - How to Drop and Truncate a Table using SQL Learn Oracle - How to Insert Data in a Table using SQL Learn Oracle - How to open ISQL Plus for the first time Learn Oracle - How to Open SQL Plus for the First Time Learn Oracle - How to Update a Table using SQL Learn Oracle - How to use Aggregate Functions in SQL Learn Oracle - How to use Functions in PL SQL Learn Oracle - How to use Group By, Having Clause in SQL Learn Oracle - How to Use Joins, Cross Join, Cartesian Product in SQL Learn Oracle - How to use Outer Joins (Left, Right, Full) in SQL Learn Oracle - How to use the Character Functions, Date Functions in SQL Learn Oracle - How to use the Merge Statement in SQL Learn Oracle - How to use the ORDER BY Clause with the Select Statement Learn Oracle - How to use the SELECT Statement Learn Oracle - How to use the Transactional Control Statements in SQL Learn Oracle - How to use PL SQL Learn Oracle - Data Types in PL SQL Learn Oracle - Exception Handling in PL SQL Learn Oracle - PL SQL Conditional Logics Learn Oracle - PL SQL Cursor Types - Explicit Cursor, Implicit Cursor Learn Oracle - PL SQL Loops Learn Oracle - Procedure Creation in PL SQL Learn Oracle - Select Statement with WHERE Cause Learn Oracle - SQL Operators and their Precedence Learn Oracle - Using Case Function, Decode Function in SQL Learn Oracle - Using Logical Operators in the WHERE Clause of the Select Statement Learn Oracle - Using Rollup Function, Cube Function Learn Oracle - Using Set Operators in SQL Learn Oracle - What are the Different SQL Data Types Learn Oracle - What are the different types of Databases Visit Pebbles Official Website - http://www.pebbles.in Subscribe to our Channel – https://www.youtube.com/channel/UCNNjWVsQqaMYccY044vtHJw?sub_confirmation=1 Engage with us on Facebook at https://www.facebook.com/PebblesChennai Please Like, Share, Comment & Subscribe
Views: 1731 Pebbles Tutorials
Oracle regular expression part 3 replace a substring regexp replace
 
06:00
Oracle SQL PLSQL and Unix Shell Scripting
Views: 2630 Sridhar Raghavan
Barcode Reader With PHP & MySQL
 
10:14
Barcode Reader With PHP & MySQL
Views: 63018 Mohammed M
How to View Data With the SELECT Statement (Introduction to Oracle SQL)
 
05:39
Getting started with the SELECT statement to view data in a table.
Views: 247 Database Star
Oracle Database | Bangla tutorials 26 ::  Database Object | Create index
 
03:46
www.facebook.com/oracle.shohag Email : [email protected] Website : www.oraclebangla.com Topics :Database Object Create index
Views: 1031 Oracle Bangla
How To Transform MySQL Rows Into Column And Become A Pivot Table Like OLAP Dimension
 
09:23
In this video you will learn on How To Transform MySQL Rows Into Column And Become A Pivot Table Like an OLAP Dimension. It can reduce so much time especially if you have a huge data. Di dalam video ini saya akan menjelaskan tentang bagaimana cara merubah record MySQL menjadi kolom seperti pivot table melalui query tanpa menggunakan OLAP atau analysis service. Convert MySQL Rows, Convert MySQL Rows Into Column, Transform MySQL Rows, Merubah record menjadi kolom, Merubah baris menjadi kolom
Views: 6563 Yadishare Tutorial
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.
Views: 5913 OCP Technology
Learn Oracle | How to Create a Report in SQL Plus
 
07:13
Pebbles present, Learn Oracle 10g with Step By Step Video Tutorials. Learn Oracle 10g Tutorial series contains the following videos : Learn Oracle - History of Oracle Learn Oracle - What is Oracle - Why do we need Oracle Learn Oracle - What is a Database Learn Oracle - What is Grid Computing Learn Oracle - What is Normalization Learn Oracle - What is ORDBMS Learn Oracle - What is RDBMS Learn Oracle - Alias Names, Concatenation, Distinct Keyword Learn Oracle - Controlling and Managing User Access (Data Control Language) Learn Oracle - Introduction to SQL Learn Oracle - Oracle 10g New Data Types Learn Oracle - How to Alter a Table using SQL Learn Oracle - How to Create a Package in PL SQL Learn Oracle - How to Create a Report in SQL Plus Learn Oracle - How to Create a Table using SQL - Not Null, Unique Key, Primary Key Learn Oracle - How to Create a Table using SQL Learn Oracle - How to Create a Trigger in PL SQL Learn Oracle - How to Delete Data from a Table using SQL Learn Oracle - How to Drop and Truncate a Table using SQL Learn Oracle - How to Insert Data in a Table using SQL Learn Oracle - How to open ISQL Plus for the first time Learn Oracle - How to Open SQL Plus for the First Time Learn Oracle - How to Update a Table using SQL Learn Oracle - How to use Aggregate Functions in SQL Learn Oracle - How to use Functions in PL SQL Learn Oracle - How to use Group By, Having Clause in SQL Learn Oracle - How to Use Joins, Cross Join, Cartesian Product in SQL Learn Oracle - How to use Outer Joins (Left, Right, Full) in SQL Learn Oracle - How to use the Character Functions, Date Functions in SQL Learn Oracle - How to use the Merge Statement in SQL Learn Oracle - How to use the ORDER BY Clause with the Select Statement Learn Oracle - How to use the SELECT Statement Learn Oracle - How to use the Transactional Control Statements in SQL Learn Oracle - How to use PL SQL Learn Oracle - Data Types in PL SQL Learn Oracle - Exception Handling in PL SQL Learn Oracle - PL SQL Conditional Logics Learn Oracle - PL SQL Cursor Types - Explicit Cursor, Implicit Cursor Learn Oracle - PL SQL Loops Learn Oracle - Procedure Creation in PL SQL Learn Oracle - Select Statement with WHERE Cause Learn Oracle - SQL Operators and their Precedence Learn Oracle - Using Case Function, Decode Function in SQL Learn Oracle - Using Logical Operators in the WHERE Clause of the Select Statement Learn Oracle - Using Rollup Function, Cube Function Learn Oracle - Using Set Operators in SQL Learn Oracle - What are the Different SQL Data Types Learn Oracle - What are the different types of Databases Visit Pebbles Official Website - http://www.pebbles.in Subscribe to our Channel – https://www.youtube.com/channel/UCNNjWVsQqaMYccY044vtHJw?sub_confirmation=1 Engage with us on Facebook at https://www.facebook.com/PebblesChennai Please Like, Share, Comment & Subscribe
Views: 3645 Pebbles Tutorials
Criando um Datasource MySQL no GlassFish
 
07:05
Neste vídeo você aprenderá como criar um Datasource MySQL no GlassFish.
Views: 742 DECODE
Oracle Database11g tutorials 11: SQL case manipulation function in Oracle Database
 
04:38
Part 2 SQL functions- character function -case manipulation functions Previous Video Link :: http://youtu.be/5rx8Q4x4-qI 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 ------------------------------------------------------------------------------------- As discuss in last video we have 3 case manipulation functions. In case you miss the SQL functions intro video you can find the link in the description below. First let's see what these functions are. Upper (): This function takes a parameter converts it into uppercase and returns the new string. Initcap (): this function also takes parameter and converts the initial letter of or parameter into uppercase and returns the new string. Lower (): This function takes a parameter converts it into lowercase and returns the new string. Ok let's do some practical For this practical we will be using 2 tables First is dual table Which is a dummy table provided by oracle? And I have created another table again by the name of example. This will be our second table. Let's start with SQL function upper ( ); SELECT upper('hello world') FROM dual; As you can see I have used "hello world" completely in lowercase as parameter to SQL upper function. Execute it. Here, our result has given us a completely new hello world string which is in uppercase. Similarly you can also use SQL upper function to perform other DML Let's try This time we will work on our second table EXAMPLE; insert into example values (upper('manish')); first parentheses for values and second for SQL function upper. Let's check the result. As you can see here inserted value is in upper case. Lets compare it with simple insert query Insert into example values ('manish'); Execute it, i think now it's clear that when we perform simple insert DML the inserted value will be the same you provide. Similarly let's try SQL function initcap(); SELECT initcap('hello world') FROM dual; As you see here in result the initial letters of string hello world are in uppercase. Let's do the insert query insert into example values (initcap('hello world')); initial letters of string also are in uppercase. Let's try SQL function lower(); This time we have to write our hello world in all caps. SELECT lower('HELLO WORLD') FROM dual; Execute String totally in lower case. Similarly you can user SQL function lower in other DML like insert and all.
Views: 85720 Manish Sharma

Cand frate langa generic cymbalta
Zantac 150 mg tablet medicijnen voor
Karpfenfilet im baclofen 10mg
Erythromycin 500 mg treatment
Injectabil ampicillin 500mg