Home
Search results “Oracle use case”
SQL tutorial 49: CASE - Simple Case Expression in Oracle Database (1/2)
 
06:34
Case expression let you perform IF-THEN-ELSE in oracle database. There are two type of case in oracle simple case expression and searched case expression. This SQL Tutorial 49 is about Simple Case Expression. ● What Is Case Expression ● Syntax of Simple Case Expression ● Query 1. Column name of a table as Search expression in CASE ● Query 2. String as Search expression in CASE Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/simple-case-expression ------------------------------------------------------------------------- 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 first 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: 37148 Manish Sharma
CASE STATEMENT(IF THEN ELSE) IN ORACLE SQL WITH EXAMPLE
 
06:28
The case statement gives the if-then-else kind of conditional ability to the otherwise static sql select statement, This video demonstrates how to write an case statement in oracle sql, and explains different aspects of the case statement. The video explains the execution flow of the case statement and advises on the best way to write one.
Views: 1947 Kishan Mashru
SQL CASE
 
05:44
Jamie King of Neumont University demonstrating CASE.
Views: 29826 Jamie King
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: 11862 Kishan Mashru
67 - Oracle PL/SQL Case Statement تعليم أوراكل
 
23:40
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج Database 2 - PL/SQL Case Statement in Arabic Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W
Oracle Multitenant: Use Cases
 
04:02
Introduction to some typical use cases for the Multitenant architecture of Oracle Database 12c.
SQL tutorial 51: DECODE function in Oracle Database By Manish Sharma (RebellionRider)
 
05:04
SQL Tutorial 51 Decode function in Oracle Database. ● What Is DECODE() ● DECODE ( ) vs CASE ● Syntax of DECODE() ● Query 1. String Matching using DECODE() ● Query 2. DECODE() comparing values form the COLUMN of the table Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: ------------------------------------------------------------------------- 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 first 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: 33780 Manish Sharma
Oracle SQL Tutorial 10 - Whitespace, Case Sensitivity, and Comments
 
07:48
SELECT "Hello World" FROM DUAL The first thing you should know about writing queries is that this SQL is not whitespace sensitive. That means we can space this out however we wish. The only requirement is that you do not separate keywords out with spaces. They must be as one entity. Another gotcha is that when you are inside of quotes, whitespace becomes very important. That means if inside of a string you put a character and then 10 spaces, every single one of those spaces is going to part of that string: SELECT "Hello World" FROM DUAL The next thing you should notice is the capitalization. When we type SQL, by convention we capitalize all keywords. I personally really like this because you can easily see the difference between keywords and words that we created or use. But obviously we could capitalize the letters in the quotes. Keep in mind that this is a convention, meaning you do not have to follow this. Oracle is also case insensitive in that SELECT and select both do the same thing. Strings, once again, care about casing. Take this, for example: SELECT 'true' FROM DUALWHERE 'Hello' = 'Hello' And compare the results to this: SELECT 'true' FROM DUALWHERE 'Hello' = 'hello' Only the first one outputs the value true. Once we get into creating database objects such as tables with columns, those are not case sensitive either. That means instead of selecting from DUAL, you can select from DuAl Finally, I shall introduce you to comments. Comments allow you to tell the database engine that you want it to ignore a certain part of your code and not execute it. This is helpful if you want to document your code. It is also useful if you want to have multiple SQL statements open in one tab, but don't want to hover over the one you want to execute. You can comment out the ones you are not using and uncomment them when you are done. Using – will comment out the rest of the line, Using /* */ will comment everything between. This can even be used over multiple lines. But now, let's move onto the important stuff… CREATING TABLES!!!!! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 16068 Caleb Curry
MicroProfile Metrics: Practical Use Cases
 
45:18
Jose Amadeo Martin Diaz Diaz, PERU JUG Leader, Peru JUG Víctor Orozco, CTO, Nabenik Jorge Cajas, CTO, inin.global One of the early innovations in the Java EE space was the possibility of measuring performance by using JMX and vendor-dependent APIs. Despite this, there are contexts where a monitoring tool such as VisualVM could not be used like secured app servers, special PaaS, and microservices with JVMs in elastic configurations. This session discusses the pros and cons of using MicroProfile Metrics in traditional (monolithic) and distributed (microservice) applications, describing when and how the various metrics (counted, gauge, metered, metric, timed) could give you an advantage. It presents an example of using it over Payara and some considerations of integrating these metrics with specialized tools such as Prometheus and Bash scripts.
Views: 268 Oracle Developers
TSQL: How To Use CASE WHEN Statements
 
14:15
How to use CASE WHEN statements in SQL Server.
Views: 28212 SQLInSix Minutes
16/125 Oracle PLSQL: Case Statement VS Case Expression
 
13:06
Learn Oracle PLSQL EXAM 1Z0-144
Views: 1321 khaled alkhudari
Oracle  || Case statement in PL/SQL by Siva
 
07:22
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS , ADF, INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo............
Oracle Cloud Infrastructure Overview and Enterprise Application Case Studies
 
35:35
In this session, Leo Leung, Sr. Director of Products & Strategy at Oracle Cloud Infrastructure, provides a brief overview of their features, benefits, and key differentiators. Leo will also demonstrate how customers use Oracle Cloud to run enterprise workloads with the predictability, high performance, governance, availability, and operational control that they have been accustomed to from their own data centers. Recorded at Tech Field Day 17 in Redwood City, California on October 18, 2018. For more information, visit https://techfieldday.com/appearance/oracle-presents-at-tech-field-day-17/
Views: 291 Tech Field Day
The CASE Statement (Introduction to Oracle SQL)
 
07:15
Learn what the CASE statement is and how to use it. The full Introduction to Oracle SQL course is available here: https://www.databasestar.com/introduction-to-oracle-sql-course/
Views: 194 Database Star
In-Database Data Mining Using Oracle Advanced Analytics for Classificaton using Insurance Use Case
 
11:52
In-Database Data Mining Using Oracle Advanced Analytics Option for Classificaton using Insurance Use Case
Views: 4960 Charles Berger
Oracle Social SRM Use Cases
 
01:19
http://www.oracle.com/social Use cases for Oracle's Social Relationship Management platform. Your social marketing can be extended to social business as it serves to improve the customer experience and the relationship your brand has with customers.
Views: 3621 Oracle Social
SQL tutorial 50: CASE - Searched Case Expression In Oracle (2/2)
 
05:52
Case expression let you perform IF-THEN-ELSE in oracle database. There are two type of case in oracle simple case expression and searched case expression. This SQL Tutorial 49 is about Simple Case Expression. ●Intro Of searched Case expression ● Syntax of SearchedCase Expression ● Query 1. Searched Case expression With logical operator using 2 columns ● Query 2. Searched Case Expression with Comparison operators and BETWEEN and IN operators. Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: ------------------------------------------------------------------------- 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 first 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: 26627 Manish Sharma
What is the difference between decode and case
 
11:00
What is the difference between case and decode List of all the SQL and PLSQL interview questions @ https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 343 Siva Academy
Example of Using a Case Statement in Oracle Database
 
00:38
Example of Using a Case Statement in Oracle Database
Views: 474 Theodore Timpone
Oracle Big Data Discovery:  Medicare Fraud Detection Use Cases Part I - Loading & Transforming Data
 
09:52
Oracle Big Data Discovery: Medicare Fraud Detection Use Cases Part I - Loading and Transforming Data
Views: 613 Alithya US
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: 85677 Manish Sharma
Difference Between Case and Decode
 
06:03
What is the difference between case and decode ? Important links for Oracle Developers For for SQL - PL/SQL Interview Questions Answers Facebook group https://www.facebook.com/groups/146487615764170/ Download Free PLSQL Interview Books , Documents Videos from here https://www.facebook.com/groups/146487615764170/files/ Free SQL / PLSQL Video on YouTube Channel SUBSCRIBE https://www.youtube.com/c/ramguptaoracle?sub_confirmation=1 Visit oracle forms / report / SQL PLSQL blog http://oracletemple.blogspot.in/ Oracle Community Google+ https://plus.google.com/u/0/collection/4mW-jB Join our facebook group https://www.facebook.com/groups/146487615764170/ Follow us on Twitter https://twitter.com/Rameshwar275 Simply Like and Share :) Oracle SQL PLSQL FaceBook group https://www.facebook.com/groups/146487615764170/ ORACLE SQL PLSQL VIDEO LINKS What is Parameterized Cursor in Oracle https://www.youtube.com/watch?v=JMKwHlVi6-A What is autonomous transaction in Oracle. https://www.youtube.com/watch?v=gyvFajpfoWE What are Constraints available in Oracle. https://www.youtube.com/watch?v=WivhdLXQklQ What is Mutation Error and How to avoid mutation. https://www.youtube.com/watch?v=CbWNCyW18Bs 5 Effective way to delete Duplicate rows https://www.youtube.com/watch?v=1wtTtnc87Oc What is Difference between Delete and Truncate https://www.youtube.com/watch?v=7b6wQ3Qumgg What are types of View available in Oracle https://www.youtube.com/edit?o=U&video_id=PN-NsSA2R-E
Views: 3842 Ram Gupta
Oracle Decode and case statement inside insert and insert all statement
 
09:20
Oracle SQL PLSQL and Unix Shell Scripting
Views: 652 Sridhar Raghavan
Learn Oracle | Using Case Function, Decode Function in SQL
 
03:31
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: 382 Pebbles Tutorials
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
Oracle Database Appliance: Use Cases and Success Stories
 
31:49
The adoption of Oracle's Engineered Systems is widespread across many industries. Hear about the latest real-world Database Appliance architecture use cases and success stories from Cintra, Oracle Database Appliance Specialized Partner.
Using CASE Expression in Oracle Database
 
09:11
CASE Expression in Oracle Database
Views: 17 Adam Tech
How to use the Oracle SQL Searched CASE Expression
 
01:13
Learn Oracle SQL searched CASE comparisons. Note that DECODE only supports equality comparisons, but searched CASE supports IN, BETWEEN, LIKE and scalar functions!
Views: 273 SkillBuilders
Oracle SQL Video Tutorial 26 - CASE Statements
 
05:59
Oracle SQL Video Tutorials 26 - CASE Statements explained.In This Oracle SQL Tutorial for Beginners, I have explained basics of SQL.These examples work on Oracle 10g and Oracle 11g database. These helps youto understand Oracle Joins and helps beginners. Iam going to add more tutorials on Oracle DBA, Oracle RAC and Oracle PL/SQL.All Oracle sql tutorial with examples are executed on Oracle 11g using Oracle SQL Developer.
Views: 5231 Just Channel
Partner Webcast – Practical use cases of Oracle API Platform Cloud Service
 
54:21
Why do Application Programming Interfaces (API) and API Management matter? What would happen if we woke up tomorrow and APIs didn’t exist? We know they are a part of modern technological development and disruption, but do we really understand the importance of APIs? Without APIs, we’re left with ‘application islands’ – a world of isolated data and applications that can’t communicate with each other. APIs and connectivity are an integral to the way technologies, society and culture has evolved – which is why businesses can’t afford to ignore this ‘digital glue’. [Read More @ https://blogs.oracle.com/imc/partner-webcast-practical-use-cases-of-oracle-api-platform-cloud-service]
Views: 283 Oracle IMC
CASE Function( IF..THEN..ELSE) in SQL ORACLE Query With Example
 
04:03
ORACLE/PLSQL: CASE STATEMENT The Oracle/PLSQL CASE statement has the functionality of an IF-THEN-ELSE statement. Starting in Oracle 9i, you can use the CASE statement within a SQL statement. The syntax for the Oracle/PLSQL CASE statement is: CASE [ expression ] WHEN condition_1 THEN result_1 WHEN condition_2 THEN result_2 ... WHEN condition_n THEN result_n ELSE result END --------- ARGUMENTS: expression is optional. It is the value that you are comparing to the list of conditions. (ie: condition_1, condition_2, ... condition_n) condition_1 to condition_n must all be the same datatype. Conditions are evaluated in the order listed. Once a condition is found to be true, the CASE statement will return the result and not evaluate the conditions any further. result_1 to result_n must all be the same datatype. This is the value returned once a condition is found to be true. NOTE: If no condition is found to be true, then the CASE statement will return the value in the ELSE clause. If the ELSE clause is omitted and no condition is found to be true, then the CASE statement will return NULL. You can have up to 255 comparisons in a CASE statement. Each WHEN ... THEN clause is considered 2 comparisons. Lets apply this function on emp table. Emp table has 3 dept numbers like 10,20 and 30. So if I want to display the different dept names based on ID, I have to use IF THEN ELSE condition. IF deptno=10 THEN "DEPT1" ELSE deptno=20 THEN "DEPT2" ELSE deptno=30 THEN "DEPT3" This entire IF block can be achived using CASE. CASE deptno WHEN 10 THEN 'DEPT1' WHEN 20 THEN 'DEPT2' WHEN 30 THEN 'DEPT3' ELSE 'NO DEPT' END; Query used in Video: select empno,ename,deptno,CASE deptno WHEN 10 THEN 'DEPT1' WHEN 20 THEN 'DEPT2' WHEN 30 THEN 'DEPT3' ELSE 'No Dept' END from emp;
Views: 16273 WingsOfTechnology
Oracle BDD:  Medicare Fraud Detection Use Cases Part III (Unnecessary Treatments & Kickbacks)
 
06:46
Oracle Big Data Discovery: Medicare Fraud Detection Use Cases Part III (Unnecessary Treatments and Kickbacks)
Views: 249 Alithya US
Enterprise Service Bus Concept and Use Case | Webinar | APPSeCONNECT iPaaS
 
53:15
Enterprise Service Bus- Concept and Use Case webinar by InSync Tech-Fin. Learn the following: 1. Problems with Point-Point connectivity 2. What is Enterprise Service Bus and why it is important? 3. Types of ESB 4. How APPSeCONNECT uses ESB for integration 5. A use case for our SAP Business One ERP – Magento eCommerce integration using ESB and other concepts related to ESB (Enterprise Service Bus) To watch other webinars please click here: https://www.appseconnect.com/webinars/ Integrate Ecommerce Store, ERP, CRM, Marketplace, Shipping and POS Systems under one single platform easily: https://www.appseconnect.com/integrations/ #EnterpriseServiceBus
Views: 7375 InSync Solutions Ltd
Robotic Process Automation | Use Cases | UiPath | Automation Anywhere | Open Source
 
04:12
Use cases of RPA in Banking, Insurance, Oil&Gas, Logistics, Retail, Manufacturing, Airlines Involved applications: Oracle, Microsoft Navision, Core Banking System, Terminal, External web-portals, Google Mail, OCR, DMS (elDoc), Shared Drive, MS Word, MS Excel, other in-house applications RPA Platforms: UiPath, Automation Anywhere, Open Source RPA method: User Interface and background programming About DMS Solutions: «DMS Solutions» is a Technology company delivering Intelligent Automation Solutions. «DMS Solutions» is your professional service partner in the field of Advanced Robotic Process Automation. We leverage Machine Learning and Artificial Intelligence to build a powerful digital workforce for your business to win on the market. We focus on exploring new ways to apply disruptive technologies and recent inventions to bring innovative automation solutions in. We break boundaries and help clients to achieve their strategic goals through delivering next-gen solutions. Our strong team of highly skilled and experienced engineers are committed to bring values by delivering measurable results in: 1) End-to-End Robotic Process Automation 2) Cognitive Automation 3) Advanced Robotics leveraging Machine Learning, Computer Vision and AI Our Clients are high-performing enterprises coming from different industries: banking & financial services, insurance, logistics, healthcare, manufacturing & retail, real estate, transportation, oil & gas, energy, etc. We operate globally and we have offices in Hong Kong and Ukraine. Willing to know more about RPA? Please contact our offices in Hong Kong or Ukraine: email: [email protected] website: https://dms-solutions.co
Views: 1290 DMSSolutions
Oracle ARCS Transaction Matching Demo and Key Use Cases - HyperCube Strategies
 
01:26
THIS IS A PREVIEW! FULL DEMO COMING TO YOUTUBE SOON! You can request a full copy of the demo NOW by emailing us at: [email protected] Full Demo will be published after our presentation at the UKOUG Hyperion and EPM in London on June 14th: http://www.ukoug.org/2017-events/ukoug-epm-and-hyperion-2017/ We will also be presenting in Glasgow on June 21st! http://www.ukoug.org/2017-events/oug-scotland-2017/ Hope to see you at one of those events! Please contact us at [email protected] for more information of to get an additional preview of our demo on Transaction Matching. ____________________________________ The Transaction Matching module of Oracle’s Account Reconciliation Cloud Service (ARCS) facilitates comparing transactions between two data sources to automate and speed up the reconciliation process. Transaction Matching has been built to support a lot of use cases like Intercompany reconciliations, Bank reconciliations, Legacy/non-ERP system reconciliation with GL and a host of other industry specific applications. This session will take you through some of these use cases, including: – Intercompany Reconciliation (we will specifically relate this to what we have seen at the Global Distribution firm, Cummins, Inc.) – Credit Card Activity and Bank Clearing Account (as in Retail, comparing detailed accounts in the banking transactions to the related GL accounts, i.e. Cash) – Inventory (as seen when reconciling shipments to receipts in Manufacturing and Distribution) We will demonstrate live in the application how Oracle's ARCS Transaction Matching can automate and streamline transaction matching and free up resources in your finance organization for more analysis and action plans.
Oracle Management Cloud for Oracle Database demo series - part 3
 
03:59
Oracle Management Cloud can be used to monitor any heterogeneous IT environment, whether on-premises or in any cloud. This particular demo series will show you 3 uses cases for using Oracle Management Cloud to manage the Oracle database. The third and last use case in this demo series will show how Oracle Management Cloud could be used for Database analytics. Part 1: https://youtu.be/qEHKyibyZUY Part 2: https://youtu.be/5wIMSW-KwUo
NTT Docomo use case for Oracle NoSQL Database
 
04:05
NTT Docomo use case for Oracle NoSQL Database
Views: 216 David Segleau
Composite Partitioning in Oracle
 
12:14
This video is the 6th Video in the series partitioning in oracle. It explains the different composite partitioning approaches and in what scenario they should be used with real project use case explanations.
Views: 2397 Tech Coach
#10. Oracle PL/SQL for Beginners - Searched CASE Statement (Hindi)
 
05:48
JavaScript Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY2tLfvp7bCL3c-psMH9Czs6 SQL Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY2q8cobbotVbn36XOskQR2F HTML5 Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY2_-PqGSrVTgBpVshxpqQlw Mobile Responsive Form using HTML5 & CSS: https://youtu.be/SECTfL3R0B0 MS SQL Server Installation: https://youtu.be/rZRA692RmuU Clock Animation in PowerPoint: https://youtu.be/LM5iwzNqQQo Envelope Animation in PowerPoint: https://youtu.be/HWlqGGleQqs FACEBOOK PAGE https://www.facebook.com/ishwaracademy/
Views: 46 Ishwar Academy
Oracle Integration Cloud Service (ICS) On-Premises Integration using Connectivity Agent
 
14:27
This video demonstrate ICS connectivity agent capability to Integrate ICS with On-premises application.
Views: 5883 FusionProfessionals
Oracle Autonomous Datawarehouse Cloud - Machine Learning with Oracle - Forecasting example
 
32:29
Part 1 00:00 Welcome 00:26 Agenda 01:31 Example use case and problem statement 03:48 Data sources we will use 04:43 Machine learning theory - The "Naive" Model 05:28 Machine learning theory - Supervised Learning 08:00 Introduction to Autonomous Datawarehouse Cloud 09:24 Data collection - introduction 10:23 Data collection - DataSync demo Part 2 11:33 Create prediction model with ADWC - Introduction 12:28 Create prediction model with ADWC - Combine the sources 15:08 Create prediction model with ADWC - Feature engineering 16:46 Create prediction model with ADWC - Validation theory 18:48 Create prediction model with ADWC - Syntax to create the model 21:35 Create prediction model with ADWC - Actual validation, visual approach 24:02 Create prediction model with ADWC - Actual validation, numerical approach Part 3 26:08 Running the prediction model - A notebook to predict tomorrow's sales 27:07 Running the prediction model with ADWC - Automatically run it every day 27:22 Running the prediction model with ADWC - Embedding in an (APEX) application 29:05 Conclusions 31:23 How to get started 31:53 Questions and contact When it comes to forecasting accuracy, machine Learning often outperforms the traditional models such as ARIMA. In this video we show you step-by-step how to use the power of machine learning for forecasting sales/demand. This video is also a good way to learn how to work with machine learning in Autonomous Datawarehouse Cloud in general. The principles you learn here can be applied to many more machine learning use cases. We'll also cover any required ML theory, so you don't require any previous knowledge on this. After watching this video you will have the basic ingredients to apply ML to your own business cases with Autonomous Datawarehouse Cloud.
Views: 1178 Jeroen
Bots: 21. Introduction to QnA in Oracle Intelligent Bots
 
06:39
FAQ, or QnA, is a common use case: the ability for your bot to answer common business questions. This video gives and introduction to the QnA feature in Oracle Intelligent Bots
Oracle SQL Tutorial - If condition using Decode and Case Statements
 
08:56
In this tutorial, we will see how to use CASE and DECODE to construct an IF ELSE conditions in SQL. SQL used in this video are given below. Also, note as mentioned in video, the values we substitute for different data should be of same data type. select * from emp_test; Male Female better than just F IF gender = 'M' then print 'MALE', gender = 'F' then print 'Female', ELSE, print 'Unknown' select first_name,gender from emp_test; select first_name,DECODE(GENDER,'M','Male','F','Female','Unknown') Gender from emp_test; SELECT first_name,DECODE(GENDER,'M','Male','F','Female') Gender FROM emp_test; SELECT first_name, CASE GENDER WHEN 'M' THEN 'MALE' WHEN 'F' THEN 'FEMALE' END AS GENDER FROM EMP_TEST; SELECT first_name, CASE GENDER WHEN 'M' THEN 'MALE' WHEN 'F' THEN 'FEMALE' ELSE 'UNKNOWN' END AS GENDER FROM EMP_TEST; SB - Savings Bank CA - CURRENT ACCOUNT FD - Fixed Deposit LA - Loan ACCOUNT
Views: 17 Ganesh Anbarasu
Oracle Forms Chatbot  for HR time entry! Yes you saw it here first!
 
04:53
In this video you will see how we use Oracle ChatBot technology to do time entry on an Oracle Forms system. This is based on REST service created from AuraPlayer! With this unique solution. Any business process running in your Forms system today can be run as a Chatbot in days! Contact us to show you how at [email protected]
Views: 862 Auraplayer Admin
Oracle RightNow to Oracle E-Business Suite Integration
 
05:15
This video demonstrates how you can realize a critical integration use case - Field Service Integration, with just a few clicks, using Oracle Integration Cloud Service. ================================= For more information, see http://www.oracle.com/goto/oll Copyright © 2016 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
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: 494 Database Star

Zantac 75 mg directions to
Acticin Topical 30gm Tube (Generic) 5 $150
Life extension 7 keto dhea metabolite 25 mg benadryl
Taking 25 mg zoloft during pregnancy
Serevent generico