Home
Search results “Oracle sql empty”
NULL Value in Oracle Database | Oracle Tutorials for Beginners
 
03:18
NULL Value in Oracle Database | Oracle Tutorials for Beginners NULL Value in Oracle Database NULL Value in Oracle SQL NULL Value in SQL NULL Value in Oracle Database Oracle Tutorials for Beginners Oracle Tutorials for Beginners Oracle PL/SQL Tutorials for Beginners Oracle PL/SQL Tutorials for Beginners Oracle PL/SQL Tutorials for Beginners how to select null values in oracle oracle compare null values in where clause null=null in oracle how to handle null in case statement in oracle how to check null value in oracle stored procedure oracle nvl null value in oracle query how to check empty column value in oracle how to select null values in oracle oracle is null vs = null oracle nvl oracle is not null oracle decode oracle isnull oracle case when null select null from table in oracle oracle compare null values in where clause oracle select null how to check empty column value in oracle oracle sql not null or empty oracle is not null how to handle null in case statement in oracle oracle isnull oracle nvl
Views: 914 Oracle PL/SQL World
SQL Null or Empty   How to Check for Null or Empty Column in SQL Server   SQL Training Online
 
03:41
http://www.sqltrainingonline.com SQL Null or Empty - How to Check for Null or Empty Column in SQL Server - SQL Training Online You can download the sample table script at http://www.sqltrainingonline.com/how-to-filter-for-sql-null-or-empty-string/. In this video, I show you how to filter for a SQL null or empty string. It can be difficult to filter a null because you can't simply compare with an equal sign. You have to use a special IS NULL clause to make the filter work. I also show you how to combine both the SQL Null and Empty String together in a special trick with the isnull SQL Server function. I use SQL Server 2012 to demonstrate the technique. Let me know what you think by commenting or sharing on twitter, facebook, google+, etc. If you enjoy the video, please give it a like, comment, or subscribe to my channel. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 20339 Joey Blue
Oracle EMPTY_BLOB Function
 
01:58
https://www.databasestar.com/oracle-lob-functions/ The Oracle EMPTY_BLOB function is used to initialise a LOB column to an empty value. You can use it in an INSERT statement, an UPDATE statement, or with a variable in PL/SQL. The syntax of the EMPTY_BLOB function is: EMPTY_BLOB That’s it - no parameters. Why would you set a BLOB value to empty? It means you have initialised it but not given it a value. It’s good to know this function exists if you ever need to use it. For more information about the Oracle EMPTY_BLOB function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-lob-functions/
Views: 249 Database Star
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: 383109 Chitu Okoli
Oracle Sql Step by Step Approach (087 no empty data allowed not null)
 
03:36
Oracle Sql Step by Step Approach (087 no empty data allowed not null) Discover essential SQL skills necessary to transform you into SQL developer which can earn you $70k+ in the IT Industry Learn to become a fee-earning SQL developer in just seven weeks. This fast, easy and effective course will take you from zero sql writing skills to being able to make money as a SQL developer. This one-stop-shot-style SQL course will teach you everything you need to know about SQL, from learning various database concepts to writing SQL to interact with the database. Throughout this SQL course I will be using the below methodology to make you think and help in forming the SQL statement. Like,Comment,Share
Oracle SQL Tutorial 19 - ON DELETE (SET NULL and CASCADE)
 
05:59
Welcome everyone! Something you need to consider when you are creating foreign keys is what happens if you delete the parent? As a reminder, the parent is the row that has the value you are referencing in the row that has a foreign key. Why is this something important to consider? It's important because foreign keys need to protect us from two primary things, unacceptable INSERT statements, and unacceptable DELETE statements. Let's see what happens when we try to insert incorrect data into the table with the foreign key: INSERT INTO projects VALUES (1, 'Update website homepage', 'CalebCurry') The response tells us plainly that there is no such user in the users table. So this works correctly. Deleting data on the other hand works a bit differently because the database does not know what you want to do with the child row when you delete the parent from the parent table. By default, we will get an error message that prevents the parent from being deleted, but there are some other options. How do we configure this? This is where the ON DELETE statement comes in. We add the keywords ON DELETE right after the foreign key and then we can give it the option of CASCADE or SET NULL. CASCADE means that if we delete the parent, we are also going to delete the child. In our situation what that means is that if somebody creates a project in our project table and then that persons account gets deleted, all of the projects he owns will also be deleted. CASCADE: CREATE TABLE projects( project_id NUMBER, Project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) NOT NULL, CONSTRAINT projects_pk PRIMARY KEY (project_id), CONSTRAINT projects_users_fk FOREIGN KEY (creator) REFERENCES users (username) ON DELETE CASCADE ) SET NULL will take the value in the child table and get rid of it. What you are left with is NULL. This means that we have an orphaned child. The first thought you might have is that it is a bad thing to have an orphaned child, but in databases that is not always so. In our application if we had it set to SET NULL, when a user account gets deleted the projects would remain in existence they would just lack a creator. This might be a good thing if you are concerned about the long term survival of a project, this might be the route you want to go. It ultimately depends on the application purpose. If you don't like CASCADE or SET NULL, you can leave the entire ON DELETE statement and just have Oracle throw an error when a parent is deleted. As for us, we are going to use ON DELETE CASCADE. We need to use this with extreme caution. If you are not careful, someday you will run a delete a row and that will cascade through you database deleting a bunch of stuff you didn't want to delete. Stuff happens, so make sure you back up your database every once in eternity. Now, in the last video we started with a database design that had three tables. We've only created two in this video. In the next video we are going to create the next one, which is a little special. Then we'll finish things up by adding some indexes. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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: 19883 Caleb Curry
part14 sql model empty string
 
01:01
empty string, model clause, dimension by, measures, data warehousing, oracle 10g
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: 19897 Caleb Curry
How to display NULL Value Different ways in SQL Developer | Oracle SQL Developer Tips and Tricks
 
02:21
How to display NULL Value Different ways in Oracle SQL Developer | Oracle SQL Developer Tips and Tricks How to display NULL Different ways in Oracle SQL Developer How to display NULL Different ways in Oracle SQL Developer | Oracle SQL Developer Tips and Tricks Oracle SQL Tutorial for Beginners Oracle Database Tutorial for Beginners Oracle SQL Developer Tips and Tricks Oracle Tutorial for Beginners Oracle Tutorial How to display NULL Values Different ways in Oracle SQL Developer How to display NULL Values Different ways in SQL Developer Oracle / SQL Developer displaying (null) in column SQL Developer display null Different Value Oracle SQL Developer display null Different Value How to display null different ways in sql developer
Views: 221 Oracle PL/SQL World
Tutorial#27 How  NULL value treated in Oracle SQL Database|IS NULL Operator
 
04:27
Online SQL tutorial , explaining about the different ways to treats NULL values in Oracle SQL server or How we can replace null values with some other values using IS NULL Operator or Different ways to replace NULL in SQL server IS NULL and IS NOT NULL in SQL or IS NULL Operator in SQL Query with Example orHow to Check for Null or Empty Column in SQL or Problems with Null Value in SQL or is NOT NULL, IS NULL, NVL FUNCTION in Oracle SQL or How can I find unknown values? orHow to convert null to 0 in SQL server orNull value in Oracle or replacing NULL in SQL In this series we cover the following topics: SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator. follow me on: Facebook Page: https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks Contacts Email: [email protected] Instagram: https://www.instagram.com/lrnwthr/ Twitter: https://twitter.com/LrnWthR
Views: 178 EqualConnect Coach
select empty row in sql server
 
08:36
How to select empty row in SQL Server
Views: 470 Sourn Sarim
COALESCE Function in SQL ORACLE Query With Example
 
03:53
ORACLE/PLSQL: COALESCE FUNCTION The Oracle/PLSQL COALESCE function returns the first non-null expression in the list. If all expressions evaluate to null, then the COALESCE function will return null. The syntax for the Oracle/PLSQL COALESCE function is: coalesce( expr1, expr2, ... expr_n ) PARAMETERS: expr1 to expr_n are the expressions to test for non-null values. EXAMPLE: The COALESCE function can be used in Oracle/PLSQL. You could use the coalesce function in a SQL statement as follows: SELECT COALESCE( address1, address2, address3 ) result FROM suppliers; The above COALESCE function is equivalent to the following IF-THEN-ELSE statement: IF address1 is not null THEN result := address1; ELSIF address2 is not null THEN result := address2; ELSIF address3 is not null THEN result := address3; ELSE result := null; END IF; The COALESCE function will compare each value, one by one. Lets apply the same to emp table. We have some NULL values in comm and mgr columns. but not in any other columns. So lets take a example for this 2 columns. COALESCE(comm,mgr,sal) Here if comm is null, function returns mgr value. If mgr is null it returns sal value! Query used in video: SELECT ename,comm,mgr,sal,COALESCE(comm,mgr,sal) result FROM emp;
Views: 6527 WingsOfTechnology
SQL IS NULL and IS NOT NULL operator | Oracle SQL fundamentals
 
03:45
Enroll into full course with free cloud access for 30 days: https://dbagenesis.com/p/oracle-sql-fundamentals/
Views: 25 DBA Genesis
Part 4   Delete duplicate rows in sql
 
03:26
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-4-delete-duplicate-rows-in-sql.html In this video, we will discuss deleting all duplicate rows except one from a sql server table. SQL Script to create Employees table Create table Employees ( ID int, FirstName nvarchar(50), LastName nvarchar(50), Gender nvarchar(50), Salary int ) GO Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (2, 'Mary', 'Lambeth', 'Female', 30000) Insert into Employees values (2, 'Mary', 'Lambeth', 'Female', 30000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) The delete query should delete all duplicate rows except one. Here is the SQL query that does the job. PARTITION BY divides the query result set into partitions. WITH EmployeesCTE AS ( SELECT *, ROW_NUMBER()OVER(PARTITION BY ID ORDER BY ID) AS RowNumber FROM Employees ) DELETE FROM EmployeesCTE WHERE RowNumber ] 1
Views: 372647 kudvenkat
DBMS - Test for Empty Relations in SQL
 
11:01
DBMS - Test for Empty Relations in SQL Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Arnab Chakraborty, Tutorials Point India Private Limited
Common Oracle SQL Tuning Errors - Lesson 5: NULLS Tuning Issues
 
02:25
Lesson 5: Learn about NULLs and a problem or two it can cause. All lessons are free at https://www.skillbuilders.com/free-oracle-database-tutorials/common-oracle-sql-tuning-errors/ Learn about our classes (online an on-premise). SQL Tuning for Beginners: https://www.skillbuilders.com/course/oracle-sql-tuning-core-skills-for-beginners/ SQL Tuning for Developers and DBAs: https://www.skillbuilders.com/course/oracle-12c-sql-tuning-for-developers-and-dbas/
Views: 141 SkillBuilders
How to Delete Table in sql using oracle 10g or sql
 
02:05
This video gives information about How to Delete Table in sql using oracleXE 10g
Views: 3464 AvilTwo Beginer
IS NOT NULL, IS NULL, NVL FUNCTION in oracle sql
 
03:04
Oracle sql tutorial, How to select, retrieve rows with null values, not null values and NVL function in oracle SQL
PL/SQL tutorial 61: Collection Method FIRST & LAST in Oracle Database
 
06:21
------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/col-method-3 Previous Tutorial ► Intro of Collection Method: https://youtu.be/8V40IaOkGcU ► Collection Method COUNT: https://youtu.be/NNq80CcC5K8 ► Collection Method EXIST: https://youtu.be/ksfwNxZl4gI ------------------------------------------------------------------------- ►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: 7280 Manish Sharma
SQL Into - How to Copy Table Data with Select Into Statement - SQL Training Online
 
05:08
http://www.sqltrainingonline.com SQL Into - How to Copy Table Data with Select Into Statement - SQL Training Online In this video, I show you how to copy data using the SQL INTO statement. Including a trick to copy only a table schema in SQL Server. How do you copy a whole table in SQL Server? You often see the SQL INTO statement when you are using INSERT, but there is a special INTO statement in SQL Server that is used with the SELECT statement that allows you to make a copy of a table for development, testing, or whatever purpose you can think of. So, to start, let's take a look at the SQL Training Online Simple DB employee table. You can see that we have 14 records Now, all we have to do to make a copy of the table is to simply add the SQL INTO clause: SELECT * INTO EMPLOYEE_TEST FROM EMPLOYEE If we run that, you see that we made a copy of the table with all of the data. Now, I want to go ahead and empty the employee_test table and show you how to use the INSERT INTO. If you already have a copy of the table, (I will show you a shortcut in a minute on how to create a copy without data.) then you can use the following insert into statement: INSERT INTO EMPLOYEE_TEST SELECT * FROM EMPLOYEE After running that statement, you see that I have inserted data from the Employee table into the employee_test table. This is sometimes referred to as INSERT INTO SELECT. But, there is one trick that I have used throughout the years that is pretty cool. Sometimes, you want the table schema, but you don't want the data. Now, I know that you can use Management Studio to script out the table for you, but there is an easier way that is more flexible as far as I am concerned. That is to use the SELECT INTO FROM, but put the following in the WHERE clause: SELECT * INTO EMPLOYEE_TEST FROM EMPLOYEE WHERE 1=2 The 1=2 makes is so not data will come over, but you get the new table with the right column types. Is that pretty cool? I have found many uses for this over the years. Let me know what you think bellow. Let me know what you think by commenting or sharing on twitter, facebook, google+, etc. If you enjoy the video, please give it a like, comment, or subscribe to my channel. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 25760 Joey Blue
Tutorial#41 NVL2 function in oracle SQL database by rakesh malviya
 
07:37
Explaining NVL2 SQL null function / Oracle NVL2 Function / NVL2 Function in SQL Query / what NVL2 Function in Oracle SQL, its perfect video for fresher/beginner/starter it has an assignment, practical and theory part of NVL2 Function, its best video of NVL2 function Assignment link: https://drive.google.com/open?id=13qNfykwag9tSuV0IVX2ycP2R-MGoNEXS you may get the answer to the following question in this series difference between nvl and nvl2 nvl in SQL coalesce function in Oracle oracle nvl nvl in where clause how to handle null values in where clause in Oracle oracle nvl nvl in where clause In this series we cover the following topics: SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator. Link for assignment: UPPERfunction in SQL https://drive.google.com/open?id=1ibjDTDX-CiPUShpf8j9kLkLjkYRdN9_e follow me on: Facebook Page: https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks Contacts Email: [email protected] Instagram: https://www.instagram.com/equalconnect/ Twitter: https://twitter.com/LrnWthR #NVL2FunctionInSQL #OracleSQLTraining #SQLTutorial
Views: 116 EqualConnect Coach
Oracle SQL Developer Tutorial For Beginners  79   Mandatory and Optional Clauses - SELECT
 
00:40
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 780 Sam Dhanasekaran
SQL Tutorial - 13: Inserting Data Into a Table From Another Table
 
07:00
In this tutorial we'll learn to use the INSERT Query to copy data from one table into another.
Views: 274720 The Bad Tutorials
Oracle Database11g tutorials 12 || SQL Concat Function - SQL character manipulation function
 
04:47
Link for SQL concat function: http://www.rebellionrider.com/SQL-concat-function.htm SQL Concat function/SQL concat() function First function of SQL character manipulation function. Two have in depth knowledge of SQL concatenation operator Please watch my video on SQL concatenation Operator http://youtu.be/PYMeFe72Bas 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 Link for SQL function introduction Video 10 http://youtu.be/5rx8Q4x4-qI Link SQL concat Article http://www.rebellionrider.com/SQL-concat-function.htm Contacts E-Mail [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 RebellionRider.com -------------------------------------------------------------------------------------------- SQL Concat () function is a Character manipulation function which is a category of SQL character function. We have already discussed the intro of SQL character function in Video 10. You can find link of this video in description below. Ok let's go ahead. SQL Concat () function concatenates two separate character string into one character string. Let's see the syntax Concat (string_1 , String_2) Note here that SQL Concat function takes only two arguments at a time. This SQL Concat function will return string_1 concatenated with string_2. This also means that it will return a single string which is a combined string of parameter String_1 and String_2. Both the parameters of SQL Concat function String_1 and string_2 can be of any data-type. You can even specify the columns of the table here. SQL Concat function is equivalent to the concatenation operator (||). SQL concatenation operator is represented by double solid vertical bars or we can say double pipe signs. Question: How to concatenate more than two strings as SQL Concat that can have only 2 parameters and what is the difference between SQL Concat Function and SQL concatenation operator? The one answer for the second Question What is the Difference between SQL Concat Function and SQL concatenation operator? Is While SQL Concat function takes only two parameters, The Concat operator can be repeated as often as is necessary. Meaning, by the help of SQL Concat operator you can combine as many strings as you want. And Concatenation operator is also not supported by several databases such as SQL server so this might cause problem. To answer the first question How to concatenate more than two strings as SQL Concat that can have only 2 parameters? We will have to jump over SQL developer. Let's see some examples. Say we want to retrieve the full name of an employee from Employees table. Let's try it using SQL Concat function. SELECT Concat (first_name, last_name) AS "Full Name" FROM employees; Here in this query we use two column names - first_name and last_name as arguments of our Concat function Execute. As you can see here, we get full name of our employee but there is no space in between first name and last name. We will see how to format this string using SQL Concat function in a few seconds But before that, let's see how to do the same task using SQL concatenation operator. SELECT first_name ||last_name AS "Full name" FROM employees; As you can see this query also produces the same result. Now we will see how to format full name of employees First we will do this using SQL concatenation Operator. SELECT first_name||' '||last_name AS "Full name" FROM employees; Now you can see we get space between first name and last name of the employee. Again, let's do it using SQL Concat function. Here we will see the nested function concept where we will be using nested Concat function to achieve this formatted string. SELECT Concat (Concat (first_name, ' '), last_name) FROM employees; Inner Concat function has two parameters. These are our first column name first_name and an empty string which will be a space between first name and second name. This Concat will now return a string which is the first name with space. This returning string will be the first input of our Outer Concat and column last_name will be the second input. All together this will give us the desired output. As you can see this method is complex than the first one where we use SQL concatenation operator.
Views: 81881 Manish Sharma
Oracle execute immediate dynamic sql  passing null value to bind argument Part 9
 
04:26
Oracle SQL PLSQL and Unix Shell Scripting
Views: 344 Sridhar Raghavan
SQL Partition By Explained
 
06:42
Using Oracle's SQL, I'll explain how to use Partition By. This will be similar in other SQL engines that have the Partition By keyword.
Views: 36516 Pretty Printed
Bursting a BI Publisher Report in Oracle Fusion HCM Cloud
 
03:48
In this video you learn how to burst a BI Publisher. The example in this video is from HCM but applies to all applications that use OTBi and OTBI Enterprise including Oracle Financials Cloud, Oracle Project Portfolio Management Cloud, and Oracle Procurement Cloud. Please note that all of the techniques and concepts in this tutorial also apply to OTBI Enterprise although the available subject areas will be different.
Views: 11130 Oracle EPM Tutorials
Creating a CDB database on Oracle 12CR2 (Create an empty Container database)
 
09:18
Create Database --------------------------- • Memory: • Select "Use Automatic Shared Memory Management" • SG size: 1653 • PGA size: 552
Views: 89 SHANOJ KUMAR V
Oracle SQL Lecture 28: IS NULL and IS NOT NULL
 
03:19
Oracle SQL: IS NULL and IS NOT NULL https://www.youtube.com/channel/UCnBpiBIOtRgMsk4G7Ri1jbQ
Views: 758 Oracle SQL
How to find your sql server name (instance) for Management Studio
 
03:40
This tutorial shows you how to find your server name or instance for connecting to SQL Management Studio (SSMS). Step by step tutorial on how to check if SQL is installed on your machine using the services to check that Microsoft SQL Server has been started. Next how to find your instance name using SQL Server Configuration Manager using SQL 2012 or 2014 folder. I show you how to connect to the instance name in the Connect to Server SQL Sever 2014 box. The Server Name is made up of the following: ServerName/Instance Name 1: To find the Server name type the following into command prompt: SQLCMD -L 2: To find the instance name go to Microsoft configuration manager there you will see your version of sql server in my case sql server express as such I know my instance name is sql server express 3. Put the server name and instance name together as per the video SOPHIA-HP/SQLEXPRESS To request a video: http://itsophy.com/request-video/ More SQL Server videos: http://www.youtube.com/playlist?list=PLrTXCzXE7TKKhIhGtl65lYMAHP6xN5Wa4 My Blog: http://itsophy.com/
Views: 127446 ITSophy
How to Empty/Delete or Drop MySQL Database All Tables
 
01:19
This video shows how to easily delete/drop MySQL database tables using phpMyAdmin (withour any cording).
Views: 2477 VIMALARANJAN
PL/SQL Tutorial | COALESCE Function in Oracle Database
 
05:31
Learn fetching all non-null expression using oracle Coalesce function with example. If all expressions evaluate to null, then the COALESCE function will return null. Coalesce function in Oracle, What is coalesce function, When to use coalesce function, How to use coalesce function in oracle, How to fetch non-null values in oracle using coalesce, Linkedin: https://www.linkedin.com/in/aditya-kumar-roy-b3673368/ Facebook: https://www.facebook.com/SpecializeAutomation/
Online SQL Training -Basic SELECT Statements Oracle SQL-001
 
58:51
This Video explains basic Oracle SQL Statements.Please sign-up to receive alerts on new video's and e-books at http://eepurl.com/bEuruH
Views: 75 Sujith Nair
Install oracle 11g database / weblogic / forms and reports without errors
 
32:52
In this tutorial I'll install: - Oracle database 11g r2. - Oracle weblogic server 10.3.6 - Oracle forms and reports 11.1.2.2 And how to avoid common errors like: - INS-13001environment does not meet minimum requirements. - WFMLRSVCApp.ear file missing during Installation - couldn't find jvm.cfg. - Unable to find java virtual machine. - ora-28000 – the account is locked. - unlock user hr. - SQL developer JDK path - Java_home variable - Environment variables path - Oracle 11g installation stuck at step 14 - Oracle forms and reports step creating domain failed. - Oracle forms and reports step 15 stuck. - Oracle forms and reports setup hang. - Oracle forms and internet explorer – crash - Oracle forms internet explorer blank page. - Oracle forms web browser blank. - Oracle 11g installation problems. - Weblogic for windows 64 – Generic. - oracle database 11g missing file. - em.ear file not found. Fusion middleware Sqldeveloper port Tnsping - Oracle forms checking operating system certification. - Tnsnames.ora - My pc become slow after install oracle ......................................­.................... لو عندك اى سؤال خش على الجروب : https://www.facebook.com/groups/oracle.askgad ......................................­.................... لمتابعة كل ماهو جديد من خلال صفحتنا https://www.facebook.com/askgad
Views: 28594 Ask Gad
Oracle SQL Developer Installation
 
02:43
To install Oracle SQL Developer, download the file, there is no in-place upgrade available, you must unzip the file into an empty folder. Select the "Use folder names" checkbox when unzipping the file. JDK Support Oracle SQL Developer 3.1 EA1 is shipped with JDK1.6.0_11. However, you can connect to and use any JDK 1.6.0_11 or above. To use an existing JDK, download the zip files listed below "with JDK already installed." To install and run: - Download the file above - Extract sqldeveloper.zip into any folder, using folder names - Within that folder, open the sqldeveloper folder - Double-click sqldeveloper.exe
Views: 16455 Just Channel
Oracle APEX- PL SQL Advance Report Design with HTML/CSS
 
13:40
#oracleapex #orclapex #oracleapexbd Creating a report with PL/SQL Dynamic Content APEX offers many item types and templates to use when designing an application. Sometimes this isn't enough, for example, when you have an existing web application built with mod PL/SQL that you want to reuse. It's possible by using built-in packages like HTP or HTF, or by using some native APEX code to create these types of pages directly in PL/SQL. How to do it... In this example, we are going to build a report without using any items, but only PL/SQL code. On an empty page, create a new region: Choose a PL/SQL Dynamic Content region type. Name it Employees.
Views: 3378 Oracle Apex
How to Import Data Pump (Impdp) Using Oracle SQL Developer | Oracle SQL Developer Tips and Tricks
 
05:56
How to Import Data Pump (Impdp) Using Oracle SQL Developer | Oracle SQL Developer Tips and Tricks Oracle SQL Tutorial for Beginners Oracle Database Tutorial for Beginners Oracle SQL Developer Tips and Tricks Oracle Tutorial for Beginners Oracle Tutorial How to Import Data Pump (Impdp) Using Oracle SQL Developer How to Import Data Pump Using Oracle SQL Developer How to Import Data Pump Using SQL Developer how to import .dmp file using sql developer sql developer data pump how to create dump file in oracle sql developer how to import dmp file in oracle 11g using sql developer sql developer 4 data pump expdp and Impdp how to export data from oracle sql developer to excel how to import data in sql developer sql developer can't use data pump as sys import .dmp file in oracle how to import dmp file in oracle 12c using sql developer how to create dump file in oracle sql developer how to import dmp file in oracle 11g using command prompt how to import .sql file in oracle sql developer sql developer data pump how to import dmp file in oracle 11g using sql developer 4 How do I import into SQL Developer How do I import a DMP file into SQL Developer How do I export a schema from SQL Developer
Views: 2501 Oracle PL/SQL World
What are  Statements in SQL Telugu - Types of SQL Statements-vlr training
 
06:11
For all sql videos in Telugu :http://www.vlrtraining.in/sql-training-videos-telugu/ What are Statements in SQL Telugu Types of SQL Statements A statement is any text that the database engine recognizes as a valid command. As of SQL-92: An SQL-statement is a string of characters that conform to the format and syntax rules specified in this international standard. A query is a statement that returns a recordset (possibly empty). In Telugu: In English: download SQL study material Website: http://www.vlrtrain.in/2016/09/download-sql-files.html Learn SQL SQL tutorial for beginners SQL commands oracle sql tutorial SQL tutorial advanced MySQL tutorial SQL tutorial video SQL Tutorial, Tutorials SQL
Views: 8046 VLR Training
P#5 difference between primary and unique key constraints in oracle SQL - interview question
 
02:20
Tutorial on what is the difference between Primary key and Unique key this frequently asked question will help you in Oracle SQL database interview question This will clear few concepts of Constraint and over here the difference between Primary and unique key in oracle explained with the example or where to use Primary Key and where to use Unique Key in Oracle sql This will cover the Following question: 1) Primary key V/s unique key 2) primary and unique 3) primary and unique key in sql 4) difference between primary and unique key with example 5) difference between the primary and unique key in oracle 6) constraints in oracle 7) constraints in oracle with example 8) how to check constraints on a table in oracle ( will cover latter) 9) constraints in SQL how to find constraints on a table in desc table name drop constraint sql server alter table tablename drop constraint constraintName; follow me on: Facebook Page: https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks Contacts Email: [email protected] Instagram: https://www.instagram.com/equalconnect/ Twitter: https://twitter.com/LrnWthR #equalConnectCoach #rakeshmalviya #Oracleconstraints
Views: 53 EqualConnect Coach
MySQL vs PostgreSQL - Why you shouldn't use MySQL
 
08:56
A comparison of the error reporting between MySQL, and PostgreSQL. Original video: http://vimeo.com/43536445
Views: 218501 Philip Thrasher
Dynamic SQL in Stored Procedure
 
09:32
In this video we will discuss, using dynamic sql in a stored procedure and it's implications from sql injection perspective. We will discuss performance implications of using dynamic sql in a stored procedure in a later video. Text version of the video http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-in-stored-procedure.html Slides http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-in-stored-procedure_11.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All SQL Server Tutorial Videos https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists Consider the following stored procedure "spSearchEmployees". We implemented this procedure in Part 139 of SQL Server tutorial. This stored procedure does not have any dynamic sql in it. It is all static sql and is immune to sql injection. Create Procedure spSearchEmployees @FirstName nvarchar(100) = NULL, @LastName nvarchar(100) = NULL, @Gender nvarchar(50) = NULL, @Salary int = NULL As Begin Select * from Employees where (FirstName = @FirstName OR @FirstName IS NULL) AND (LastName = @LastName OR @LastName IS NULL) AND (Gender = @Gender OR @Gender IS NULL) AND (Salary = @Salary OR @Salary IS NULL) End Go Whether you are creating your dynamic sql queries in a client application like ASP.NET web application or in a stored procedure, you should never ever concatenate user input values. Instead you should be using parameters. Notice in the following example, we are creating dynamic sql queries by concatenating parameter values, instead of using parameterized queries. This stored procedure is prone to SQL injection. Let's prove this by creating a "Search Page" that calls this procedure. Create Procedure spSearchEmployeesBadDynamicSQL @FirstName nvarchar(100) = NULL, @LastName nvarchar(100) = NULL, @Gender nvarchar(50) = NULL, @Salary int = NULL As Begin Declare @sql nvarchar(max) Set @sql = 'Select * from Employees where 1 = 1' if(@FirstName is not null) Set @sql = @sql + ' and FirstName=''' + @FirstName + '''' if(@LastName is not null) Set @sql = @sql + ' and LastName=''' + @LastName + '''' if(@Gender is not null) Set @sql = @sql + ' and Gender=''' + @Gender + '''' if(@Salary is not null) Set @sql = @sql + ' and Salary=''' + @Salary + '''' Execute sp_executesql @sql End Go Add a Web Page to the project that we have been working with in our previous video. Name it "DynamicSQLInStoredProcedure.aspx". Copy and paste the HTML and code available on my blog at the following link http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-in-stored-procedure.html At this point, run the application and type the following text in the "Firsname" text and click "Search" button. Notice "SalesDB" database is dropped. Our application is prone to SQL injection as we have implemented dynamic sql in our stored procedure by concatenating strings instead of using parameters. ' Drop database SalesDB -- In the following stored procedure we have implemented dynamic sql by using parameters, so this is not prone to sql injecttion. This is an example for good dynamic sql implementation. Create Procedure spSearchEmployeesGoodDynamicSQL @FirstName nvarchar(100) = NULL, @LastName nvarchar(100) = NULL, @Gender nvarchar(50) = NULL, @Salary int = NULL As Begin Declare @sql nvarchar(max) Declare @sqlParams nvarchar(max) Set @sql = 'Select * from Employees where 1 = 1' if(@FirstName is not null) Set @sql = @sql + ' and [email protected]' if(@LastName is not null) Set @sql = @sql + ' and [email protected]' if(@Gender is not null) Set @sql = @sql + ' and [email protected]' if(@Salary is not null) Set @sql = @sql + ' and [email protected]' Execute sp_executesql @sql, N'@FN nvarchar(50), @LN nvarchar(50), @Gen nvarchar(50), @sal int', @[email protected], @[email protected], @[email protected], @[email protected] End Go On the code-behind page, use stored procedure spSearchEmployeesGoodDynamicSQL instead of spSearchEmployeesBadDynamicSQL. We do not have to change any other code. At this point run the application one more time and type the following text in the "Firstname" textbox and click the "Search" button. ' Drop database SalesDB -- Notice "SalesDB" database is not dropped, So in this case our application is not succeptible to SQL injection attack. Summary : Whether you are creating dynamic sql in a client application (like a web application) or in a stored procedure always use parameters instead of concatnating strings. Using parameters to create dynamic sql statements prevents sql injection.
Views: 39534 kudvenkat
How to empty Table  or Completely Delete a Table in database
 
01:27
How to delete a table in oracle database in urdu.
Views: 3309 modern IT Channel
Importing Data from Excel into Oracle Database using SQL Developer 4.1
 
02:23
One of SQL Developer’s most popular features has undergone a significant upgrade. Users can quickly define and recall delimited or Excel files to be imported to a new or existing Oracle table. Data preview and validation is provided for each column, as well as ‘best guess’ data type and date format mask mapping. This process can now be automated via the SQL Developer command line interface (SDCLI) ‘Import’ command. NOTE: This is a video only. There is no audio. 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.
SQL NULL Values Telugu | SQL queries-vlr training
 
02:48
For All sql videos in telugu http://www.vlrtraining.in/sql-training-videos-telugu/ In Telugu: SQL NULL Values SQL queries The SQL NULL is the term used to represent a missing value. A NULL value in a table is a value in a field that appears to be blank. A field with a NULL value is a field with no value. It is very important to understand that a NULL value is different than a zero value or a field that contains spaces. What is the meaning of null in SQL? What is the value of NULL in SQL Server? What do you mean by NULL values in DBMS? What is a null in mysql? What is a null value in a database? MySQL Database Complete Tutorial in Telugu for Beginners In English: download sql study material Website: http://www.vlrtrain.in/2016/09/download-sql-files.html Learn SQL sql tutorial for beginners sql commands oracle sql tutorial sql tutorial advanced mysql tutorial sql tutorial video SQL Tutorial, Tutorials SQL
Views: 946 VLR Training
SDU Tools   19   Empty Schema in a SQL Server Database
 
02:16
SDU Tools are a free set of T-SQL tools (Registration is required) to help developers and database administrators (DBAs) working with SQL Server. This video shows how to use a procedures from the tools to remove all objects (tables, constraints, views, functions, etc.) from a specified schema. You'll find more info about SDU Tools and download details at http://www.sqldownunder.com/Resources/SDUTools
Views: 76 SQL Down Under
02-Oracle SQL-Common SQLplus Commands
 
17:03
TrainerBD.com Offers the most affordable (BDT. 15,000/-) Oracle Training in Mirpur, Dhaka, Bangladesh. Learn Oracle, Be an Oracle Developer and/or Database Administrator. Click http://www.trainerbd.com/training/product/oracle-training-in-bangladesh/ to learn Oracle. Oracle Tutorial Group (Facebook):- https://www.facebook.com/groups/Oracletutorialvideos https://www.facebook.com/groups/oracletutorialtechtunes Search Terms:- oracle video tutorial free download oracle applications tutorial oracle 11g tutorial free download oracle sql tutorial oracle 10g tutorial oracle form builder tutorial oracle forms 10g tutorial oracle 10g tutorial for beginners oracle database 10g tutorial sql oracle oracle for beginners oracle 10g tutorial oracle tutorials for beginners oracle dba tutorial for beginners pdf oracle forms developer tutorial toad for oracle tutorial oracle fusion middleware tutorial oracle forms 6i tutorial oracle sql tutorial oracle 11g tutorial oracle tutorial pdf free download oracle dba tutorial for beginners oracle application express tutorial oracle tutorial for beginners oracle database tutorial oracle apex tutorial oracle sql tutorial sql tutorial oracle 11g tutorial oracle 10g tutorial oracle dba tutorial oracle tutorial for beginners Tags: oracle video tutorial free download,oracle applications tutorial,Oracle 11g tutorial free download,oracle sql tutorial,oracle 10g tutorial,oracle form builder tutorial,oracle forms 10g tutorial,oracle 10g tutorial for beginners,oracle database 10g tutorial,sql oracle,oracle for beginners,oracle tutorials for beginners,oracle forms developer tutorial,toad for oracle tutorial,oracle fusion middleware tutorial,
Views: 1098 Oracle Tutorialbd
SQL in Oracle 11g Tutorial #3: Simple Table Creation
 
04:14
SQL in Oracle 11g Tutorial #3: Simple Table Creation. How to create table in SQL. Thanks for Watching my Channel “Learn TechToTech”. Please subscribe my channel for getting first updates after uploading video.Social Media pages of Channel are: 1. My Website : www.learnfromrakesh.com 2. My Twitter: https://twitter.com/LearnTechtotech 3. Facebook Page: https://www.facebook.com/LearnTechToTech 4. Blogger : https://learntechtotech.blogspot.in/ 5. Google+ : https://learntechtotech.blogspot.in/ 6. Pinterest : https://in.pinterest.com/LearnTechToTech/ 7. LinkedIn: https://www.linkedin.com/in/Learntechtotech/ Playlist of Different Technology: 1. Operating System : https://goo.gl/q6SfrW 2. Python Programming Language : https://goo.gl/L8b5dc 3. C Language : https://goo.gl/SwvDu9 4. C language for Placement: https://goo.gl/AaQBa4 5. Java: https://goo.gl/M8F2uy 6. MySql : https://goo.gl/vdJbHQ 7. Android Mobile Application Development: https://goo.gl/M6woaT 8. Kotlin Programming Language : https://goo.gl/GXE5cd 9. Go Programming: https://goo.gl/Ua3xYW 10. Internet of Things(IoT): https://goo.gl/f2afkY 11. Oracle 11g : https://goo.gl/zds8r2 12. C++ : https://goo.gl/C1psMT
Views: 74 Learn TechToTech
SQL for Beginners (Part 10) : The DELETE and TRUNCATE TABLE Statements
 
03:18
The tenth part of a mini-series of videos showing the basics of SQL. In this episode we take a look at the DELETE and TRUNCATE TABLE statements. For more information see: https://oracle-base.com/articles/misc/sql-for-beginners-the-delete-and-truncate-table-statements Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Michelle Malcher : Blog: http://michelledbaunleashed.blogspot.co.uk/ Twitter: https://twitter.com/malcherm Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 1765 ORACLE-BASE.com