Home
Search results “Get oracle sql”
Oracle SQL Tutorial 9 - Intro to Queries
 
04:55
This video is for beginners who have never worked with SQL Developer, and we are going to teach how to begin writing queries. So the queries we are going to start with are queries when we give the database an expression and it will return back some kind of value. The most common keyword you are going to need to know for Oracle is SELECT. SELECT is the command we use to get data from the database. Even though we have not really put any data in our database, we can still use the SELECT statement to get data. That's because the database is capable of doing more than just creating tables and retrieving data from tables. So our first goal is to essentially write a Hello World, which just displays the text hello world to us. A good place to start is with: SELECT 'Hello World' This would actually work for many database management systems, but when you run it you will get an error. This actually doesn't work with Oracle, it will tell us we always need the FROM keyword. To get around this, there is a magical table called DUAL. We can put anything we want to SELECT and then say FROM DUAL and it will work. SELECT 'Hello World' FROM DUAL We can also do math: SELECT 1+1 FROM DUAL And we can run even run functions: SELECT SYSTIMESTAMP FROM DUAL To put all of this together, you can grab all of this data at the same time using commas to separate different columns from our generated table: SELECT 'Hello World', 1+1, SYSTIMESTAMP FROM DUAL Support me on Patreon: 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: 30020 Caleb Curry
Oracle Database11g tutorials 5:  how to retrieve Data Using SQL SELECT statement || SQL tutorials
 
05:13
This SQL tutorial and Oracle database 11g tutorial for beginners will show how to retrieve data using SQL SELECT statement. 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. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 You can download the Script which is used in this SQL tutorial from this link https://copy.com/yDQ46Tb64efm Contacts Email [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/RebellionRider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from The Code makers
Views: 198882 Manish Sharma
SQL tutorial 61: SEQUENCE in Oracle Database By Manish Sharma RebellionRider
 
08:05
This tutorial is all about Sequence In Oracle Database. In this SQL Tutorial you will learn How to create a sequence How to populate a Primary key column (auto increment in Oracle) using Sequence How to drop a sequence ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/sql-sequence-in-oracle-database-rebellionrider-manish-sharma Previous Tutorial ► How To Insert Data into Table using SQL Developer http://youtu.be/YYQCSV6MzTk ► INSERT INTO Command http://youtu.be/uQXgqFtxI_k ► How to copy /Insert data into a table from another table http://youtu.be/m3Ep8tAMqok ------------------------------------------------------------------------- ►►►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 for E-mail address please check 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: 44422 Manish Sharma
Get started with Oracle Database 11g XE and SQL Developer
 
09:57
Learn how to install and use Oracle Database 11g Express Edition (XE) and use SQL Developer
Views: 7691 srikanth pragada
SQL tutorial 38: How to create user using SQL Developer in Oracle database
 
06:52
How to create new user accounts using SQL Developer in oracle database. In This tutorial you will learn how to create a new user account. How to setup a database connection with SyS user. How to grant privileges to the user ----_Links_--- Blog :http://bit.ly/create_user_account Video Tut 4: http://youtu.be/wSqoXRlXDUU How to create database: http://youtu.be/enFFezPYhCg Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 Amazon Wishlist: http://bit.ly/wishlist-amazon 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: 66710 Manish Sharma
Slow SQL Query? Get the Plan in Oracle SQL Developer!
 
15:38
See how to get execution and explain plans, format and views those plans, use AutoTrace, and Real Time SQL Monitoring for your SQL queries in Oracle SQL Developer.
Views: 3046 Jeff Smith
Oracle Database tutorials 4:  database connectivity using SQL developer and command prompt
 
09:19
Blog Link: http://bit.ly/how-to-create-new-connection-in-sql-developer Wishlist: http://bit.ly/wishlist-amazon This SQL tutorial and Oracle database 11g tutorial for beginners will show how to connect to database either on a local machine or on a machine in your LAN using ip address. Tool used in this tutorial is SQL developer & 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 Email [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/RebellionRider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos The Code makers
Views: 282732 Manish Sharma
Create new connection with new user in Oracle SQL Developer
 
10:28
This video shows you how to create a new connection using a new user account (other than the system user account) in Oracle SQL Developer, so that you have a clean workspace without all the clutter of system tables. It is NOT a general introduction to using Oracle SQL Developer.
Views: 361288 Chitu Okoli
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
Oracle SQL Tutorial 1 - Intro to Oracle Database
 
10:18
As illustrated in the video, Oracle Database is a program designed to hold lots of information, or data. There are all kinds of different databases and they all have their uses. Some of the most common ones are MySQL, SQL Server, Sybase, and MongoDB. All of these have different uses. The differences will be easier to understand after you learn more about each kind of database. We did not discuss it much in the video, but if you are wondering what “SQL” means in the title, it stands for structured query language. Structured query language is a human readable computer language that is used to tell databases to do things. We will discuss SQL and Oracle SQL Developer more in future videos. Databases are better than spreadsheets because they allow multiple users at one time, different levels of access given to users, recovery options and transactions, and it is more protected from hacking and malicious destruction. Programming languages often have very useful functions or methods that can be used to communicate to a database and therefore they are a naturally good option for the back end of programs. This course will go over all of the major parts of database programming using Oracle SQL. We will be using Oracle 11g, but these videos should still work with other versions, including the most recent 12c. Q and A ~~~~~~ How much does Oracle cost? The full enterprise edition costs thousands. They have other versions for less and they even have a FREE VERSION! This is known as the XE version (eXpress Edition). That is the one we will be using. How long does it take to learn SQL? You can learn all of the basics and be an efficient beginner database developer in only about a month of practice. To become an intermediate it can take anywhere from an additional 3 - 6 months with a only a few hours of studying and practicing each day. How can I learn SQL faster? Take notes and actually mess around with making your own database. Watch these videos until you understand the concepts within them, read articles and books that teach in more depth. Enjoy this content? You might enjoy my programming videos. Pick one and have some fun! 🙂 Learn Javascript - http://bit.ly/JavaScriptPlaylist Learn Java - http://bit.ly/JavaPlaylist Learn C# - http://bit.ly/CSharpTutorialsPlaylist Learn C++ - http://bit.ly/CPlusPlusPlaylist Learn C - http://bit.ly/CTutorialsPlaylist Donate!: http://bit.ly/DonateCTVM2. HELP ME! http://www.patreon.com/calebcurry. Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter ~~~~~~~~~~~~~~~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: 357331 Caleb Curry
Learn Oracle SQL Developer in 10 minutes - Data Dictionary - DDL - Part 1/2
 
13:29
Refer Complete Tutorial : http://haneefputtur.com/create-manage-oracle-database-using-oracle-sql-developer-gui.html Create Oracle Database Tables Using GUI SQL developer Tools Tasks: • Create Orale tables using Oracle SQL Developer Creating Oracle Tables . 1. Oracle database required: DNS Name : xxxxxxxxx User Name: haneef Password : xxxxxxxxxxxxxxx Service Name : Haneef 2. Software Required : Oracle SQL Developer ( this requires JDK ) Link to Download : http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html Create two tables. 1. Employee 2. Department Employee Table : • Employee ID ( Primary key) • Employee Name • Employee Department • Employee Salary Department Table: • Department ID (Primary key) • Department Name • Department Head Create Foreign Key For Employee Department to get ID from Department Table. Create DDL and Execute them.
Views: 27838 Mahammad Haneef
Should you become an SQL Developer in 2018?
 
08:12
Every web developer should learn SQL. But should you become a full-time SQL developer in 2018? Learn web development fast: https://shop.killervideostore.com/ Learn Python 3 fast: http://www.killervideostore.com/python/ Learn business: https://goo.gl/QF5v4o Join a community of nerds: https://www.killersites.com/community/ My Instagram: https://www.instagram.com/stefanmischook/?hl=en Thanks! Stef
Views: 38390 Stefan Mischook
PL/SQL tutorial 3: SELECT INTO statement in PL/SQL by Manish Sharma RebellionRider
 
05:22
How to initialize the variable by fetching values from the table of the database or by using SELECT INTO statement in PL/SQL by Manish Sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/select-into-statement-pl-sql Previous Tutorial ► Variables: https://youtu.be/2MNmodawvnE ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. -------------------------------------------------------------------------- ►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 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 for E-mail address please check 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: 127512 Manish Sharma
Oracle - PL/SQL - Getting Started
 
10:05
Oracle - PL/SQL - Getting Started https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
How to use SQL Developer with Oracle 12c
 
05:29
In this video i'm going to show you how to use sql developer tool with oracle 12c step by step #sqldeveloper #oracle12c #shripal #oracletutorial
Views: 12658 OCP Technology
Oracle SQL - A Complete Introduction
 
03:42:44
Social Network for Developers ☞ https://morioh.com Aiodex’s Referral Program  will give you 20% -80% commission from their transaction fee for 7 years. The value will be calculated starting from the date the member you invite sign up ☞ https://aiodex.com/p/referral-program Next Generation Shorten Platform: Optimal choice to make a profit and analyze traffic sources on the network. Shorten URLs and Earn Big Money ☞ https://viralroll.com Get Free 15 Geek ☞ https://geekcash.org Developers Chat Channel ☞ https://discord.gg/KAe3AnN Playlists Video Tutorial ☞ http://dev.edupioneer.net/f086e182ab The Complete Oracle SQL Certification Course ☞ https://learnstartup.net/p/SJVtrUlbl Oracle SQL : Become a Certified SQL Developer From Scratch! ☞ https://learnstartup.net/p/rkbnlLjsb Advanced SQL : SQL Expert Certification Preparation Course ☞ https://learnstartup.net/p/H1KU0_zFW Learn the basics of Oracle SQL with these easy-to-follow Oracle SQL lessons and examples. Learn how to use Oracle SQL from scratch, to improve your developer skills or to access an Oracle SQL database at work. This course will teach you the basics of the SQL language on an Oracle database. It uses video lectures to teach you Oracle SQL, covering database topics such as: Setting up your Oracle environment Basic terminology Reading data using a SELECT statement What can be done using a SELECT statement Functions Data types Joins, set operators, subqueries Inserting, updating and deleting data Creating tables The course materials run for approximately 4 hours and are split into multiple sessions. It's structured into various sessions and lectures, grouped by functional areas to make it easier to learn. Why should you take this course? There are many benefits of taking my Oracle SQL course: You can go from absolute beginner to capable of writing Oracle SQL statements in a matter of hours Avoid paying thousands of dollars for training. You can also study in your own time! Learn from someone who actually has Oracle SQL experience (and runs a website teaching others how to use and optimise their Oracle SQL)! If you want to learn Oracle SQL from someone who has experience, then take this course. Who is the target audience? Those who have some knowledge about IT but minimal SQL knowledge University or college students Those who need to use a database at work, but don't know how Video source via: Udemy & DataBaseStar ---------------------------------------------------- Website: http://bit.ly/2pN2aXx Playlist: http://bit.ly/2Eyn3dI Website: http://bit.ly/2Hay229 Fanpage: http://bit.ly/2qi5j1A Twitter: http://bit.ly/2GOyTlA Pinterest: http://bit.ly/2qihWtz Tumblr: http://bit.ly/2qjBcGo
Views: 13395 Big Data Training
How To Run .sql Program File In Oracle Command Line | SQL Tutorial | PL/SQL | Oracle SQL 10g
 
03:48
Please avoid or flag spams/hateful comments. And do not spam. Enjoy :) I am using the Oracle Sql server 10g express edition which is free to use. Download it from oracle website. Subscribe my Channel:- http://www.youtube.com/user/SanketRooney?sub_confirmation=1 Facebook Page:- https://www.facebook.com/UnpossibleNS Twitter Account:- https://twitter.com/UnpossiblePOG How To Run .sql File In Oracle Command Line | SQL Tutorial | PL/SQL Programming How To Run .sql File In Oracle Command Line | SQL Tutorial | PL/SQL Programming How To Run .sql File In Oracle Command Line | SQL Tutorial | PL/SQL Programming How To Run .sql File In Oracle Command Line | SQL Tutorial | PL/SQL Programming
Views: 13601 Unpossible POG
Oracle - SQL - Getting Started
 
02:06
Oracle - SQL - Getting Started Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
How to Connect MS SQL Server Database with Oracle SQL Developer
 
05:38
how to connect sql server with sql developer how to connect sql server with sql develope How to Connect MS SQL Server Database with Oracle SQL Developer jtds - sql server and sybase jdbc driver cannot connect to microsoft sql server on localhost sql developer jtds-1.2.5.jar oracle sql developer oracle sql server download native sspi library not loaded sql developer jtds 3rd party jdbc driver oracle sql developer connect to microsoft sql server jtds-1.2.5.jar oracle sql developer jtds - sql server and sybase jdbc driver sql developer connect to sql server named instance jtds 3rd party jdbc driver sql developer cannot connect to microsoft sql server how to connect sql server with sql developer
Views: 12937 Oracle PL/SQL World
Oracle SQL: Exploring Date Functions
 
07:29
http://www.informit.com/store/oracle-sql-livelessons-video-training-downloadable-9780134275741?WT.mc_id=Social_YT Oracle SQL: Exploring Date Functions is an excerpt from Oracle SQL LiveLessons Video Training -- 6+ Hours of Video -- Oracle SQL LiveLessons Video Training covers the basics of the Oracle SQL programming language. This course covers both Oracle standard SQL and the ANSI approved SQL that Oracle supports. The focus of the course is to give students working knowledge of the Oracle SQL language and at the conclusion of this course, students should be able to query the Oracle database. Description In this LiveLessons video course, Oracle ACE Director Dan Hotka will teach you how to use the SQL query language, interpret business questions into SQL code, and how to use Where clauses sub-queries, complex table join conditions, and how to create table objects and populate tables with data. Students will also learn how to access Oracle from Microsoft products such as Excel. In addition, they will learn how analytical SQL can be used for business analysis. This course will use both Toad and SQL Developer for SQL examples. About the Instructor Dan Hotka is a training specialist and an Oracle ACE director who has more than 37 years in the computer industry and more than 31 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well published with 12 Oracle books and well over 200 published articles. He is also the video author for Oracle SQL Performance Tuning for Developers LiveLessons and Oracle PL/SQL Programming Fundamentals. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world. Visit his website at www.DanHotka.com. Skill Level Beginner Learn How To Use the SQL query language Interpret business questions into SQL code Understand Oracle standard SQL and ANSI SQL Work with Where clauses, sub-queries, and complex table join conditions Create table objects and populate these tables with data Access Oracle from Microsoft products such as Excel Use analytical SQL, useful for business analysts Who Should Take This Course Students who are new to SQL and want to learn Oracle SQL Course Requirements Basic knowledge of what is a database, especially RDBMS and what is a computer programming language http://www.informit.com/store/oracle-sql-livelessons-video-training-downloadable-9780134275741?WT.mc_id=Social_YT
Views: 5170 LiveLessons
PL/SQL tutorial 40 : Introduction to PL/SQL Stored Procedure in Oracle Database By Manish Sharma
 
04:59
Learn what are "stored procedures" in Oracle Database By Manish Sharma from RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/stored-procedure Previous Tutorial ► How To Create PL/SQL function: https://youtu.be/93uqcFVtfWA ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►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 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/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check 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: 56217 Manish Sharma
PL/SQL tutorial 73: Bulk Collect with SELECT-INTO statement in Oracle Database
 
07:26
RebellionRider.com presents a PL/SQL tutorial on how to use the BULK COLLECT clause with SELECT INTO statement in Oracle Database by Manish Sharma. In this tutorial, you will also learn how to overcome the overhead caused by context switch and improve the query performance. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/bulk-collect-2 Previous Tutorial ►Introduction to Bulk Collect: https://youtu.be/CrJSlf_m3yA ►PL/SQL Tutorial 51-Nested Table: https://youtu.be/EUYyiFCzU0I ►Collection Method Count:https://youtu.be/NNq80CcC5K8 ------------------------------------------------------------------------- ►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: 11988 Manish Sharma
PL/SQL tutorial 11: PL/SQL Simple Loop in Oracle Database by Manish Sharma RebellionRider.com
 
04:21
First tutorial in Iterative statement series explaining concepts of Simple Loop in PL/SQL With a quick brief intro of Loops in Oracle PL/SQL ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/simple-loop Previous Tutorial ► IF-THEN : https://youtu.be/IWvuFD6eD30 ► Simple CASE Statement https://youtu.be/DMlDwOmqAzo ► Searched CASE Statement https://youtu.be/jk7k4TDs3F0 ► DECODE Statement https://youtu.be/lKXqXINCNLo ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►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 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 for E-mail address please check 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: 69237 Manish Sharma
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
Oracle DBA Justin - PL/SQL # 1: How to display output in a PL/SQL program
 
07:04
How to display output in a PL/SQL program
Views: 5577 jbleistein11
Oracle Database tutorials 3:How to enable Line numbers in SQl Developer.
 
02:05
Wishlist: http://bit.ly/wishlist-amazon In this tutorial for database 11g You will see how to enable Line numbers in SQL Developer. This SQL tutorial and Oracle database 11g tutorial for beginners will show how to enable Line numbers in SQL Developer. 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. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts Email [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/RebellionRider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos
Views: 254572 Manish Sharma
Generating Code Quickly with Oracle SQL Developer
 
16:28
See how in 15 minutes you can generate SQL statements, anonymous PL/SQL blocks to run your programs, get help completing database object names, and re-using frequently used snippets of code or queries in Oracle SQL Developer.
How to Export DDL Scripts in SQL Developer | Oracle SQL Developer Tips and Tricks
 
03:58
How to Export DDL Scripts Using Oracle SQL Developer | Oracle SQL Developer Tips and Tricks How to Export DDL Scripts in SQL Developer Oracle SQL Tutorial for Beginners Oracle Database Tutorial for Beginners Oracle SQL Developer Tips and Tricks Oracle Tutorial for Beginners Oracle Tutorial How to Export DDL Scripts Using Oracle SQL Developer How to Export DDL Scripts Using SQL Developer How to Export DDL Scripts from SQL Developer How to Export DDL Scripts in SQL Developer How to Export DDL Scripts in Oracle SQL Developer generate ddl from oracle sql developer how to generate ddl script in oracle sql developer export schema how to get ddl of a table in oracle how to get create table script in oracle how to export table data from oracle sql developer to excel How do I export DDL from SQL Developer How do I create a DDL script in SQL Developer How do you get DDL of a table in Oracle
Views: 1057 Oracle PL/SQL World
SQL tutorial 68: Union and Union All SQL Set Operator In Oracle Database By RebellionRider
 
05:23
Union and Union all Set operator in SQL/Oracle Database with example also the difference between union and union all. NExt tutorial will cover Intersect and minus set operator. Manish Sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog :http://bit.ly/union-union-all-set-operator-oracle ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►►►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 for E-mail address please check 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: 26090 Manish Sharma
Finding Database Columns By Name in Oracle SQL Developer
 
05:11
How to find all columns in your Oracle Database by searching on the name.
Views: 6825 Jeff Smith
Oracle username and password and Account unlocking
 
08:37
all education purpose videos
Views: 282951 Chandra Shekhar Reddy
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: 183396 Manish Sharma
SQL Developer: How To Become A Successful SQL Developer?
 
06:48
What Programming Language Should Programmers Learn In 2019? 💻 👉🏻https://www.youtube.com/watch?v=CwaSHqAWPUU What Programming Language Should Programmers Learn In 2019? 💻 👉🏻https://www.youtube.com/watch?v=CwaSHqAWPUU ► SQL Developer: How To Become A Successful SQL Developer? ◄ " Oracle SQL Developer is the Oracle Database IDE. A free graphical user interface, Oracle SQL Developer allows database users and administrators to do their database tasks in fewer clicks and keystrokes. A productivity tool, SQL Developer's main objective is to help the end user save time and maximize the return on investment in the Oracle Database technology stack." (Source: http://www.oracle.com/technetwork/developer-tools/sql-developer/what-is-sqldev-093866.html) Becoming a SQL developer is not something we see very often. There is not so much talk about SQL developers on the internet, so, people who want to become one might get lost. How do you become a SQL Developer? Watch this video and find out! Learn Cobol Programming? (2018 & Beyond): https://www.youtube.com/watch?v=f3WVa2zyyGE Should You Focus On Getting Certifications?: https://www.youtube.com/watch?v=-LAzOBhIfPE 🐕 ARE YOU A BULLDOG? 🐕 Take the quiz and find out http://bulldogmindset.com/quiz-yt 📕 STOP BEING LAZY 📕 Get my short book on: How to Overcome Laziness http://bulldogmindset.com/stopbeinglazybook-yt 📷 FOLLOW BULLDOG MINDSET ON INSTAGRAM 📷 http://bulldogmindset.com/insta-yt 🎥 MOTIVATION PLAYLIST 🎥 http://bulldogmindset.com/motivation-pl-yt 💪 FITNESS AND DIET 💪 http://bulldogmindset.com/fitness-pl-yt 💪 HOW TO LOSE FAT 101 - FREE COURSE 💪 http://bulldogmindset.com/losefat-pl-yt 💲 STARTING AN ONLINE BUSINESS - FREE COURSE 💲 http://bulldogmindset.com/startingbusiness-pl-yt 💘 ATTRACT WOMEN AND BECOME A BETTER MAN 💘 http://bulldogmindset.com/attractwomen-pl-yt 🏠 REAL ESTATE INVESTING 🏠 http://bulldogmindset.com/realestate-pl-yt 🏹 STOIC PHILOSOPHY - BECOME MENTALLY TOUGH 🏹 http://bulldogmindset.com/stoic-pl-yt 📚 BOOK REVIEWS 📚 http://bulldogmindset.com/bookreviews-pl-yt ► LINKS YOU MIGHT LIKE Bulldog Mindset Website: http://bulldogmindset.com Personal Coaching Services: https://simpleprogrammer.com/coaching-services/ If you have a question, email me at [email protected] If you have a question, email me at [email protected]
Views: 27857 Bulldog Mindset
PL/SQL tutorial 39: How To Create PL/SQL Functions in Oracle Database By Manish Sharma
 
06:15
PL/SQL Tutorial for beginners on RebellionRider.com How To Create PL/SQL Functions in Oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/how-to-create-pl-sql-function Previous Tutorial ► Introduction To PL/SQL Function: https://youtu.be/6OJIrPx61mU ► PL/SQL Variables: https://youtu.be/2MNmodawvnE ► PL/SQL Constants: https://youtu.be/r1ypg7WH4GY ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►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 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/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check 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: 42046 Manish Sharma
BLK2: Get Data Faster with BULK COLLECT (PL/SQL Channel)
 
24:36
This lesson explores the BULK COLLECT feature, which allows you to retrieve multiple rows of data from the SQL layer with a single fetch. This video was taken from PLSQLChannel.com, originally recorded before Steven Feuerstein re-joined Oracle in March 2014. ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 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.
How to Generate Oracle ER Diagrams Using PL/SQL Developer & Oracle SQL Developer?
 
05:35
This Video Will Teach you.. How to Generate Oracle ER Diagrams Using PL/SQL Developer & Oracle SQL Developer? Document Attached @ https://github.com/arulxaviers/Generate_ER_Diagram_SQL_Developer how to generate erd from sql developer how to generate er diagram using pl/sql developer how to generate er diagram using sql developer data modeler sql developer data modeler download how to generate er diagram using pl/sql developer how to generate er diagram using toad how to generate er diagram using sql server management studio oracle sql developer data modeler reporting repository required. generate er diagram from sql server how to generate er diagram using oracle sql developer
Views: 7641 Oracle PL/SQL World
Oracle SQL Tutorial : How to return multiple values from the Function in Oracle PL/SQL
 
08:49
Oracle SQL Tutorial Oracle tutorial : How to return multiple values from the Function in Oracle PLSQL pl sql function This video tutorial tell you How to return multiple rows from the Function in Oracle PLSQL Using the TYPE object you can able return multiple rows from the function.Here object concept of oracle is used. Subscribe on youtube: https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA For more tutorial please visit #techquerypond https://techquerypond.wordpress.com https://twitter.com/techquerypond
Views: 7061 Tech Query Pond
Oracle Database 12c Tutorial 3:Connect HR/SYS user with SQL Developer in Oracle12c Using TNS Service
 
05:24
Learn how to connect HR and Sys User of Oracle database 12c With SQL Developer using TNS service. Connect HR user which is in pluggable database to SQL Developer ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : Previous Tutorial ► Tut 61: How To Unlock HR schema in Oracle Database 12c http://youtu.be/F81gfUnznZY ------------------------------------------------------------------------- ►►►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: 55555 Manish Sharma
Oracle Database 11g XE (Express Edition) Install guide and connect with SQL Developer
 
18:16
Welcome to MyOnlineEdu.com's video tutorial. In this video you will learn how to install Oracle Database 11g XE (Express Edition) and then connect the database using Oracle SQL Developer IDE tool. You can avail an instructor based live class from MyOnlineEdu.com. To enroll click the lick: https://www.myonlineedu.com/course/view/6/oracle-sql-and-plsql-11g-fundamentals
Views: 366799 MyOnlineEdu.com
pl sql developer - connect to oracle 12c database using pl sql developer with tnsnames.ora
 
06:22
pl sql developer - connect to oracle 12c database using pl sql developer with tnsnames.ora Connect to oracle database - how to connect to oracle database using sqlplus in windows: https://youtu.be/8GK4RQuCx_8 In this tutorial "pl sql developer - connect to oracle database using pl sql developer with tnsnames.ora" will show you how to configure tnsname.ora in pl sql developer for oracle database connection, create table in pl sql developer, insert data in pl sql developer, and select result in pl sql developer. You can find me: Facebook: https://www.facebook.com/HingTipi Instagram: https://www.instagram.com/pi_sapphire/?hl=en Linkedin: https://www.linkedin.com/in/tipi-hing-93080261/ Google plus: https://plus.google.com/u/0/115396916707479934437 Twitter: https://twitter.com/TiPiHing photo credit: CREDIT PHOTO https://www.flickr.com/photos/[email protected]/10614978976/in/photolist-hb1xqU-4A4jrh-fPduyd-rcmbAc-fPcRfU-r8Jbhv-5gAYFx-bqrToM-dRFrZg-fNVyov-62Yv2h-nQug-9h8PzA-5aZeqx-9h5FM4-7H6iUU-9h8PrQ-9h5FAc-b78rj-9h5Fv8-fJt9Ex-kqoVuF-jcK5w5-hEoyms-9h5FJ8-Ro3Xc9-9h5FGK-8b8puq-9h5FBR-dfUthv-agLG6c-9h5Fz8-pSbCPg-5A8zDb-jC4vYX-RT31DE-9h8Pqm-4VMqsw-SCqtuw-4VMpCo-bofeWo-fPrqnP-aznTRJ-8vh3ny-7heoWE-jC5rn8-bTzxkx-gYu6fR-9GywxF-fNUJjF Subscribe. Like. Share. Comment. Thanks, pl sql developer connect to oracle 12c database using pl sql developer
Views: 23755 Junior Geek
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: 4529 Kishan Mashru
Connect to Oracle database with SQL Developer for MAC OSX.
 
14:52
This video contains a total demonstration of how to connect to oracle 12c release 1 on Oracle linux server 6.4 64 bit from MAC OSX Mountain Lion 7.0 using SQL Developer 4.0.3.16.84. Tutorial contains 2 way of connecting 1. Connecting using oracle service name. 2. Connecting using saved xml configuration file. SQL Developer for MAC OSx link : http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
Views: 61528 Subhroneel Ganguly
Oracle Database11g tutorials 13 || SQL substr function / SQL substring function
 
06:34
link of SQL substr blog : http://www.rebellionrider.com/SQL-substr-function.htm SQL substr function SQL Substr function will return a sub string of a specified length from the source string beginning at a given position. 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 the name suggests SQL Substr function will return substring from a given source string. Let's see the Syntax Substr (source_string, start_pos, Substr_length) As we can see SQL substr function takes 3 parameters. First one is Source string from which you want to extract the segment. Second parameter is Starting position for sub string from the Source string. And the third parameter is Substr_length which is the length for the substring. First two parameters are mandatory to specify while third one is optional. So we can say. SQL Substr function will return a sub string of a specified length from the source string beginning at a given position. First parameter source string can be of any data type CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB whereas both start_pos, Substr_length parameters must be number data type. The returning result of SQL Substr function is of same data type of source string. Let's see an example of SQL Substr function. SELECT substr('www.RebellionRider.com',5,14) FROM dual; Here in this query url of my website www.RebellionRider.com is our source string with the total length of 22 characters, Now, I want to extract the name of my website that is, RebellionRider. So if you count the total length of the name of the website, it is 14. That's why I have specified 14 as my third parameter of SQL Substr function which is substr_length. Also the name of the website RebellionRider is starting from 5th position therefore I have specified 5 at second parameter of SQL substr function which is strt_pos or starting position. Execute it. Here is our result RebellionRider When starting position is larger than the length of source string. In this case SQL Substr function will return NULL as a result. Let's do an example. SELECT substr('www.RebellionRider.com',23,14) FROM dual; As you can see here I have specified 23 at starting position and the total length of our source string is 22 characters Let's execute And the result is Null. Second scenario When the Substr_length is greater than source string In this case the segment return is the substring from starting position to the end of the string. For example SELECT substr('www.RebellionRider.com',5,23) FROM dual; Our starting position is at 5 means at the first R of RebellionRider and length of substring is set to 23 which is greater than the length of source string that is 22. Execute. As you can see we get a substring from first R of RebellionRider till the end of the source String. Third scenario When you supply numeric or arithmetic expression or a DATE instead of character as Source string to SQL Substr function In this scenario If you have supplied a numeric string instead of character as source string, the oracle engine casts them as a character when they occur as parameter to SQL Substr function. And if you have supplied Arithmetic expression or a DATE then The Oracle engine first solves or evaluates the Arithmetic expression or the DATE Then casts them as a character. Means if you have arithmetic expression in your source string then oracle will first solve it and then change or say cast the value of its result into character. Let's see some example. SELECT substr(50000-7,2,4) FROM dual; Oracle first evaluates the arithmetic expression that is 50000-7 equals to 49993. And then oracle engine casts this result 49993 into a character string. Means 49993 will be a 5 characters string. Starting position of substring is 2, that means from the first 9 of 49993 We specified the length of substring is 4 so we must get 9993 as our result. Let's check execute
Views: 81849 Manish Sharma
Oracle 12c Release 2 - How to get SQL Plus command history
 
01:36
blog: https://connor-mcdonald.com Want to go retrieve and edit previous commands in SQL Plus without using things like rlwrap ? easy in 12.2 ========================================­­­­============== Copyright © 2017 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.
Views: 1304 Connor McDonald
How to debug Oracle Procedure | Package using Oracle SQL Developer
 
07:41
This video will teach you the simple way to debug your Oracle Procedure | Package with Oracle SQL Developer..
Views: 12809 Oracle PL/SQL World
SQL: Explain Plan for knowing the Query performance
 
05:17
In this tutorial, you'll learn how to compare queries to know the better performance query..
Views: 99454 radhikaravikumar
Copying data from Oracle to Microsoft SQL Server (Part 1)
 
12:10
This video tutorial is designed to show you how to copy data from an Oracle database to Microsoft SQL Server 2008r2 using Microsoft SQL Server Business Intelligence studio
Views: 16723 De Jeneral
Oracle SQL Tutorial : How to connect oracle database using sqlplus command line
 
02:20
Oracle tutorial: How to connect oracle database using sqlplus command line sqlplus tools to connect to oracle database In this tutorial you can see using SQLPLUS commands how we can connect the oracle database . After connecting the oracle database you can able execute the sql query. oracleconnection oracle sqlplus connect to database Oracle SQL Tutorial
Views: 20101 Tech Query Pond
PL/SQL tutorial 26: Introduction to PL/SQL Cursor in Oracle Database By Manish Sharma
 
05:10
Learn What are cursors, what are types(Explicit and implicit), and steps of cursor's creation in oracle database by Manish Sharma From RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/introduction-to-database-cursors Previous Tutorial ► Pl/SQL Variables: https://youtu.be/2MNmodawvnE ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►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 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/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check 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: 101608 Manish Sharma
SQL Developer: EXPORT tables, schemes or whole database via Oracle SQL Developer.
 
02:27
Just 2 mins to do export database (EXPDP) by using SQL Developer. Import: https://youtu.be/eM6M8lxOJEA
Views: 8722 1Click2beDBA