Home
Search results “Alter table oracle modify null”
SQL with Oracle 10g XE - Using ALTER TABLE to Modify Table Columns
 
05:23
In this video I use the ALTER TABLE command to modify an existing field column. The command will allow you to change the data types, whether the field can be null, or even the primary key. When using the ALTER TABLE command you would use the keyword MODIFY to make changes to an existing column. Be careful when changing a data type of the null field as existing data may cause an error if not in compliance with the new change. The code I used to alter the Books table is : ALTER TABLE BOOKS MODIFY ISBN_10 VARCHAR(13); This video is part of a series of videos with the purpose of learning the SQL language. For more information visit Lecture Snippets at http://lecturesnippets.com.
Views: 15850 Lecture Snippets
Oracle SQL Tutorial 13 - How to Add Column Constraints (Attributes)
 
05:55
So far, we have this table declaration: CREATE TABLE users( user_id NUMBER, username VARCHAR(50 CHAR) first_name VARCHAR2(50 CHAR), last_name VARCHAR2(50 CHAR) ) We can run this command see that it works. As we are learning though, we are going to want to be able to recreate our table with different settings and such, but if you try to run this command, it will complain that the table already exists. So we first need to delete this table before we start editing settings. When we get more experienced, we will learn about ways to edit the structure of a table that already exists. To fix this, we can get rid of the table using the DROP TABLE command: DROP TABLE users You can run this every time if you need to practice by adding a semicolon after it. This is how you can tell Oracle that you are putting in another command after it. This is known as a delimiter. When you run the script, it is going to run both commands. Now we can go through and reconsider our table structure. This is fine for starting out because we don't have any important data in our database, but once your database is in production you are not going to want to just drop tables. In the last video we discussed different constraints that you can apply to columns in a database table, but how do you actually apply these when you are creating a table? The first way you define constraints is to put them right after the column in your CREATE TABLE statement. CREATE TABLE users( username VARCHAR2(50 CHAR) NOT NULL ) When we define constraints this way, we usually say we are adding column attributes. If you have two constraints you want to add, you just put one after the other with spaces in between. There is no particular order that is required. CREATE TABLE users( username VARCHAR2(50 CHAR) NOT NULL UNIQUE ) In this situation we have already given the column the NOT NULL and UNIQUE attributes, so we should consider making this a primary key: CREATE TABLE users( username VARCHAR2(50 CHAR) PRIMARY KEY ) As you can see, adding column attributes is super easy. We can add a default like this: CREATE TABLE users( username VARCHAR2(50 CHAR) PRIMARY KEY, account_balance NUMBER DEFAULT 0 ) Note that now we need the comma after the first row. There are a few constraints we did not talk go through an example, specifically foreign keys and check constraints. We will be adding these constraints to our database in future videos. In the mean time, I have a thought for you… Many people prefer to name their column constraints. That way, we can refer to certain constraints by name. For example, we might have a primary key constraint that could be named users_pk. The way we are creating these constraints does not allow for this feature, so in the next video we are going to be discussing different ways to create constraints. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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: 20983 Caleb Curry
61. ALTER TABLE for Adding Constraint in Column SQL (Hindi)
 
03:40
Please Subscribe Channel Like, Share and Comment Visit : www.geekyshows.com
Views: 9156 Geeky Shows
Create, Alter, Drop Not Null constraint in SQL Server - Part 10
 
09:34
Subscribe to IT PORT : https://www.youtube.com/c/itport28 SQL Server Tutorial in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64enJDwWVvN3KduuZRlUrb3 SQL Server Concepts in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ67kdNIByJKAGBIBhor_h4Hs SQL Server Analytic Functions in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ65XIU5azEUgLVrBKEl-jWMV SQL Server Tutorial : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66AYrzPtxt2SeeR4UABcBcO SQL Server Concepts : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66zRe8-nDDy-YHY2o0rmbn4 SQL Server Analytic Functions : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64hTsEdhLsVBquE1vERWngX 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. NULL value is different than a zero value or a field that contains spaces By default, a column can hold NULL values. The NOT NULL constraint enforces a column to NOT accept NULL values. This enforces a field to always contain a value, which means that you cannot insert a new record, or update a record without adding a value to this field
Views: 459 IT Port
Oracle Tutorial - Add and Drop a Column using Alter Table Statement
 
04:21
Oracle Tutorials for beginners: Add and Drop a Column using Alter Statement
Views: 45 Tech Acad
Oracle Tutorial - is NULL and is NOT NULL
 
06:16
Oracle Tutorials - is NULL and is NOT NULL
Views: 89 Tech Acad
drop primary key,not null,unique,default and check constraints from columns in a table
 
12:48
This video explains how to drop primary key,not null,unique,default and check constraints with or without constraint name in a table link to HOW to add constraint while creating table: https:// https://www.youtube.com/watch?v=dh_UKs-LnK8 link to how to add new columns with constraints : https://www.youtube.com/watch?v=UNAatxnnwB8 link to how to add constraints to existing column https://www.youtube.com/watch?v=02_fXRQpwSc how to drop all constraints on the table: https://www.youtube.com/watch?v=CM7FPqIr6gc subscribe - https://www.youtube.com/channel/UCNl7...
Views: 2063 kwl zerotwonine
43. Not Null Constraint in PL/SQL Oracle
 
03:45
In this video you will learn about Not Null Constraint in PL/SQL Oracle. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 4182 ITORIAN
MySQL - How to Change Null Values to 0 in SQL
 
00:51
Get Source Code/Read : http://intactabode.com/ For Developing support email your Details at : [email protected] Install Free Trail GST Ready Accounting Package Send your Contact information Name, Email, Contact Number to email : [email protected] watch demo in English : https://www.youtube.com/watch?v=a4sFNtZuYzs&ab_channel=IntactAbode watch demo in Hindi : https://www.youtube.com/watch?v=I3eCieDpG3o&ab_channel=IntactAbode Website : http://relybill.com/ Watch More Frequently Used Sql Queries in all Databases Complete Playlist: https://www.youtube.com/playlist?list=PLErD1cRL87W992bgZ_TX7gxl5UKuP9yF9 In this videos i show how to update your null values to zero or o in sql, if you wanted change all the null values in your sql to numerical zero 0, this syntax will sure help you to solve the problem. in some cases i you wanted to display your null values to 0 in sql, mysql, oracle or any other jdbc database this querry will sure help you solve the problem in sql syntax. For Source Code Visit : http://corneey.com/wJ6X2K Subscribe to YouTube channel http://corneey.com/wJ6VoC Like us on Facebook http://corneey.com/wJ6C2l Follow us on Twitter http://corneey.com/wJ6C7x Follow me on Google+ http://corneey.com/wJ6Vhc linkedin http://corneey.com/wJ6V5g
Views: 2842 Intact Abode
Adding Not Null to an Existing Column
 
03:12
In this episode, I'm going to add a not null constraint to an existing Postgres column. To learn more and for full transcript visit us at https://www.pgcasts.com This episode is sponsored by Hashrocket, a consultancy specializing in PostgreSQL. Visit us at https://hashrocket.com
Views: 1899 PG Casts
Oracle - SQL - Not Null Constraint
 
05:14
Oracle - SQL - Not Null Constraint Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
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: 590 Oracle PL/SQL World
Oracle SQL PLSQL 12C Tutorial 15 - ALTER Statement
 
08:54
This Video Tutorial Will Describe how to change the structure of an existing table. This command will also work on other versions of database like Oracle 11g Database, Oracle 10g Database, Oracle 9i Database, Oracle 8i Database, Oracle 8 Database and so on. This command is used to add, modify or delete the columns from the table. You can add, modify or delete a single column or multiple columns at a time. Full Syntax will be given in this video tutorial about how to use the ALTER table command. Along with the live example to add, modify or delete the columns from the table. All the keywords, format, mandatory clauses etc are described in this video.
SQL Tutorial - 21: The UPDATE Query
 
06:12
In this tutorial we'll check out the UPDATE Query which is used to update/change records in a table.
Views: 88670 The Bad Tutorials
auto increment in sql oracle - ( Auto increment field )
 
03:07
auto increment in sql oracle ----------------------------------------------- CREATE table customers ( customer_id int not null, customer_name varchar(50), primary key (customer_id) ); create sequence customer_id minvalue 1 start with 1 cache 10; insert into customers values(customer_id.nextval,'maxwel'); -- to drop sequence drop sequence customer_id
Views: 6257 Data Disc
Change "Not Null" to "Null" Across the Database
 
06:42
Nathan Gambill (Microsoft Manager) goes over an SQL Procedure to change "Not Null" to "Null" across a designated database. This helps prevent NULL inserts into NOT NULL column errors.
Views: 455 Agossi SQL
SQL tutorial 21: How To Rename Table in SQL using ALTER TABLE statement By Manish Sharma
 
04:19
Oracle Database 11g Tutorial 21 : How to rename table using SQL Alter Table Links Website Article of in-depth Knowledge http://www.rebellionrider.com/alter-table/rename-table-using-alter-table.htm Create table using comand prompt and SQL Developer Tutorial 14 http://youtu.be/UU0EEfpa-2c Create table using EM tutorial 15 http://youtu.be/I-LUXP9GmPU Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Tool used in this tutorial is SQL Developer. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free 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: 39449 Manish Sharma
56. ALTER TABLE for adding one column without constraints in SQL (Hindi)
 
06:48
Please Subscribe Channel Like, Share and Comment Visit : www.geekyshows.com
Views: 17321 Geeky Shows
Null: Databases for Developers #10
 
07:42
The null value represents missing or unknown information. But using it brings complications to your SQL. In this video Chris discusses how to work with null to ensure you get the correct results. Further reading: Oracle Database SQL Reference on Nulls: http://docs.oracle.com/database/122/SQLRF/Nulls.htm#SQLRF30037 Null related functions: http://docs.oracle.com/database/122/SQLRF/Single-Row-Functions.htm#SQLRF51187 Is null condition: http://docs.oracle.com/database/122/SQLRF/Null-Conditions.htm#SQLRF52152 Need help with SQL? Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ ============================ The Magic of SQL with Chris Saxon 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.
Views: 3057 The Magic of SQL
Not Null Constraint in MySQL
 
05:23
The NOT NULL constraint enforces a column to NOT accept NULL values. You can also add or drop not null constraint in MySQL using Alter table: https://www.youtube.com/watch?v=WzJCEJDeje8
Views: 87 Success Sole
Oracle SQL Tutorial 18 - How to Create Foreign Keys
 
07:09
In this video we are going to be creating foreign keys. I highly recommend watching the previous video before you watch this one. Essentially, we are creating a very simple database for a system where we can create projects and add people to those projects. We started with the users table: --Delete the table if needed: --DROP TABLE users; CREATE TABLE users( user_id NUMBER, username VARCHAR2(50 CHAR) UNIQUE, CONSTRAINT users_pk PRIMARY KEY (user_id) ); Now we are going to create a table for projects with a column that is a foreign key to the username. We're going to want to make this match data types: CREATE TABLE projects( project_id NUMBER, project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) ) Next, we need to add the column attributes we decided on last video: CREATE TABLE projects( project_id NUMBER, project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) NOT NULL ) NOT NULL because we want every project to have a creator, but we are not labeling UNIQUE because that means we could only have a specific username once in the table. We want to allow a user to create multiple projects. We also need to add a primary key: CREATE TABLE projects( project_id NUMBER, project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) NOT NULL, CONSTRAINT projects_pk PRIMARY KEY (username) ) Now, the question that remains is, how can I tell Oracle that I want the username to reference the username column of the other table? We have to make a foreign key constraint. As you've learned from the previous videos, there are about three ways to create constraints. You can do it inline at the column level, unnamed. You can do it at the column level, named, and you can do it at the Table level, named. Usually the table-level is preferred, but I will quickly remind you how to do all three again. CREATE TABLE projects( project_id NUMBER, project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) NOT NULL REFERENCES users (username), CONSTRAINT projects_pk PRIMARY KEY (project_id) ) This works, but if we want to name it, we should do this: CREATE TABLE projects( project_id NUMBER, project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) NOT NULL CONSTRAINT projects_users_fk REFERENCES users (username), CONSTRAINT projects_pk PRIMARY KEY (project_id) ) This works, but the preferred method is to do it at the table level: 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) ) Great! So you've learned how to create a foreign key, now we can see it inside of Oracle SQL Developer. One important thing when it comes to foreign keys is what happens when have data in your database and you try to delete the parent row that a row in the child table references? In the next video we are going to configure that using ON DELETE. See you all then and if you enjoy this series, please do me a huge favor by liking the video and subscribing to my YouTube channel. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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: 22429 Caleb Curry
Alter Table Statements
 
37:10
How to alter table, Add new column in a table, Drop any column, Add Constraints, Drop Constraint, Read only table, read and write table..
Views: 129 Data Science Center
Create, Alter, Drop Not Null constraint in SQL Server - Part 10 Tamil
 
11:04
Subscribe to IT PORT : https://www.youtube.com/c/itport28 SQL Server Tutorial in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64enJDwWVvN3KduuZRlUrb3 SQL Server Concepts in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ67kdNIByJKAGBIBhor_h4Hs SQL Server Analytic Functions in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ65XIU5azEUgLVrBKEl-jWMV SQL Server Tutorial : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66AYrzPtxt2SeeR4UABcBcO SQL Server Concepts : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66zRe8-nDDy-YHY2o0rmbn4 SQL Server Analytic Functions : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64hTsEdhLsVBquE1vERWngX 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. NULL value is different than a zero value or a field that contains spaces By default, a column can hold NULL values. The NOT NULL constraint enforces a column to NOT accept NULL values. This enforces a field to always contain a value, which means that you cannot insert a new record, or update a record without adding a value to this field By default, a column can hold NULL values. The NOT NULL constraint enforces a column to NOT accept NULL values. This enforces a field to always contain a value, which means that you cannot insert a new record, or update a record without adding a value to this field Explained in Tamil
Views: 296 IT Port
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: 16256 Caleb Curry
Oracle SQL Tutorial 15 - How to Add Primary Key Constraints
 
02:54
The goal of this video is to take the CREATE TABLE statement we have and walk through the different ways to create primary keys. This and foreign keys are the most common constraints, so we need to make sure that you have this one down. Once we have a more complex database design with multiple tables, we will learn the proper way to create foreign keys. For now, I am going to keep all of our constraints at the column level, unnamed. The only exception is the primary key, because that is what we are focusing on in this video. The first way to create the primary key is at the column level, unnamed. The primary key is very important because it what we use to distinguish rows from one another. Every table you create is going to need a primary key, and I suggest putting a lot of effort into making sure your keys are set up correctly and organized. --Delete the table if needed: DROP TABLE users; CREATE TABLE users( user_id NUMBER PRIMARY KEY, username VARCHAR2(50 CHAR) NOT NULL UNIQUE ) The next way is at the column level, but named: --Delete the table: DROP TABLE users; CREATE TABLE users( user_id NUMBER CONSTRAINT users_pk PRIMARY KEY, username VARCHAR2(50 CHAR)NOT NULL UNIQUE ) The general naming convention here is the table name followed by an underscore, followed by pk for primary key. Finally, the third way, which is at the table level, is the way we are going to create our primary key: --Delete the table: DROP TABLE users; CREATE TABLE users( user_id NUMBER, username VARCHAR2(50 CHAR) NOT NULL UNIQUE, CONSTRAINT users_pk PRIMARY KEY (user_id) ) Now, once you've created these constraints, you can use Oracle SQL Developer to find these constraints. Open your databases in the connections tab and find the table in the Tables folder. Double click your table and travel to the Constraints tab. You can tell here that the UNIQUE constraint still exists in this table, but it has a pretty disgusting name. It kind of wants to make me puke. Referencing that constraint in the future with that wacky name would be a burden. Engrave these three options in your head so that you can use any of them whenever you need and can read other peoples' code. Thank you for sticking with the series thus far. In the next video, we will be…doing something. See you then! :) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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: 15082 Caleb Curry
TUTORIAL MEMBUAT PHYSICAL DATABASE DARI ORACLE SQL DEVELOPER
 
38:24
Tutorial kasar : -sqlplus oa/oa -connect as sysdba; -create user paijo identified by paijo; -grant all privilege to paijo; -connect paijo/paijo -show user //lalu buat file di oracle home dengan nama paijo.sql dengan isi: ========================================= DROP TABLE "DOKTERS"; DROP TABLE "PASIENS"; DROP TABLE "DIAGNOSAS"; CREATE TABLE DOKTERS ("ID_DTR" VARCHAR (7), "NAMA" VARCHAR (25) NOT NULL, "ALAMAT" VARCHAR (30) NOT NULL, CONSTRAINT "ID_DTR_PK" PRIMARY KEY ("ID_DTR") USING INDEX ENABLE); CREATE TABLE PASIENS ("ID_PSN" VARCHAR (9), "NAMA" VARCHAR (25) NOT NULL, "ALAMAT" VARCHAR (30), CONSTRAINT "ID_PSN_PK" PRIMARY KEY ("ID_PSN") USING INDEX ENABLE); CREATE TABLE DIAGNOSAS ("TANGGAL" DATE, "HASIL" VARCHAR (30) NOT NULL, "ID_DTR" VARCHAR (7), "ID_PSN" VARCHAR (9), CONSTRAINT "TGL_PK" PRIMARY KEY ("TANGGAL", "ID_DTR", "ID_PSN") USING INDEX ENABLE); ====================================== [email protected] -desc dokters; -desc pasiens; -desc diagnosas; //lalu buat file di oracle home dengan nama alter_paijo.sql dengan isi: ===================================== ALTER TABLE DIAGNOSAS ADD CONSTRAINT "DIA_ID_DTR" FOREIGN KEY ("ID_DTR") REFERENCES DOKTERS ("ID_DTR"); ALTER TABLE DIAGNOSAS ADD CONSTRAINT "DIA_ID_PSN" FOREIGN KEY ("ID_PSN") REFERENCES PASIENS ("ID_PSN"); =================================== [email protected]_paijo.sql //lalu buat file di oracle home dengan nama isi_paijo.sql dengan isi: =================================== INSERT INTO DOKTERS VALUES('D100799','PAIJO','JALAN IN AJA'); INSERT INTO DOKTERS VALUES('D120498','PAINO','JALAN JALAN'); INSERT INTO DOKTERS VALUES('D071297','PAIWO','JALAN YANG BENAR'); INSERT INTO PASIENS VALUES('PSN130193','JARWO','JALAN LURUS'); INSERT INTO PASIENS VALUES('PSN040494','JARVIS','JALAN GRAK'); INSERT INTO PASIENS VALUES('PSN121212','JARAN','JALAN BERBELOK'); INSERT INTO DIAGNOSAS VALUES(TO_DATE('18-12-18','DD-MM-YY'),'PARU KERING','D100799','PSN130193'); INSERT INTO DIAGNOSAS VALUES(TO_DATE('19-12-18','DD-MM -YY'),'KAGETAN','D120498','PSN040494'); INSERT INTO DIAGNOSAS VALUES(TO_DATE('20-12-18','DD-MM-YY'),'GATEL','D071297','PSN121212'); ================================ [email protected]isi_paijo.sql -select * from dokters; -select * from pasiens; -select * from diagnosas; //lalu buat file di oracle home dengan nama select_paijo.sql dengan isi: ============================== SELECT DOKTERS.ID_DTR, DOKTERS.NAMA, PASIENS.ID_PSN, PASIENS.NAMA, DIAGNOSAS.TANGGAL, DIAGNOSAS.HASIL FROM DOKTERS, PASIENS, DIAGNOSAS WHERE DOKTERS.ID_DTR = DIAGNOSAS.ID_DTR AND PASIENS.ID_PSN= DIAGNOSAS.ID_PSN =========================== [email protected]_paijo.sql
Oracle Drop, Disable and Enable Constraints تعليم اوراكل
 
09:35
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج How to Drop , Disable and Enable Constraints. كيف حذف و تعطيل و إعادة تشغيل القيود Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W oracle create table statement oracle drop table statement oracle constraints database constraints primary key constraint foreign key constraint check constraint null not null constraint unique constraint
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: 17504 Joey Blue
SQL TUTORIAL-4 (Create table, Alter table, ADD and DROP column, MODIFY Column Data type)
 
08:31
SQL queries for 1. Create table 2. Add new Column 3. Drop a column 4.change column data type
Views: 18020 simran kaur
SQL tutorials 17: SQL Primary Key constraint,  Drop primary Key
 
09:22
Blog link: http://www.rebellionrider.com/sql-primary-key.htm SQL tutorial on Primary key / SQL Primary key, In this tutorial you will learn about simple primary key, composute primary key, how to drop primary key. defining primary key using create table and alter table along with many other things. 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 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 So Primary Key There are two types of Primary keys First is Simple primary Key: Primary key which Involves only one column and Second is Composite Primary Key: Primary Key which involves more than one column. We will start with Simple primary key. You can create Primary key either with Create Table statement of by using Alter table Statement. Let's define simple primary key using create table statements. With create table statement we can either define primary key at column level or at table level. We will start with defining Primary key at column level using create table statement. You just have to put keyword Primary key after data type and size of column while defining a column of a table. Here oracle server will create a primary key on product id with default constraint name which will be slightly difficult to understand. You can give your own name to your constraint which is also a good practice.
Views: 100687 Manish Sharma
NOT NULL Constraint in Oracle Database
 
03:48
NOT NULL Constraint in Oracle Database
Oracle SQL Tutorial 21 - How to Create / Drop Indexes
 
03:58
In the last video, we wrote up the SQL to create three tables: CREATE TABLE users( user_id NUMBER, username VARCHAR2(50 CHAR) UNIQUE, CONSTRAINT users_pk PRIMARY KEY (user_id) ); 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 ); CREATE TABLE project_users( project_id NUMBER NOT NULL REFERENCES projects (project_id) ON DELETE CASCADE, user_id NUMBER NOT NULL REFERENCES users (user_id) ON DELETE CASCADE, CONSTRAINT project_users_pk PRIMARY KEY (project_id, user_id) ); I'm going to increase the size of the users table a bit by adding a first and last name column. CREATE TABLE users( user_id NUMBER, username VARCHAR2(50 CHAR) UNIQUE, first_name VARCHAR2(50 CHAR), last_name VARCHAR2 (50 CHAR), CONSTRAINT users_pk PRIMARY KEY (user_id) ); But before we finish this design, we should consider indexing certain columns. What columns should we index? Well, as a reminder, the columns that are indexed by default are columns with the UNIQUE constraint, and those that are labeled as primary keys. Columns that are not indexed but often should be are those labeled as a foreign key. The column that jumps out the most to me is the creator column of the project table. It's the only foreign key that is not part of some index. Let's fix this by creating our first index. The way we do that is with the CREATE INDEX command. CREATE INDEX projects_creator_ix ON projects (creator) What naming convention are we following for the index? We are naming it by the table name, followed by an underscore, followed by the column, followed by an underscore, followed by an ix (for index). In this situation it does not apply, but if our foreign key column is labeled as UNIQUE, we can add the UNIQUE keyword like this: CREATE UNIQUE INDEX projects_creator_ix ON projects (creator) Now if you want to get rid of an INDEX, you can use this command: DROP INDEX projects_creator_ix Now, if we want to select data from the user table and the project table we can do that much faster. That's because the foreign key and column it references are both indexed and those are the columns we would do the join on. We will discuss how to do joins in a future video. So what are some potential problems with this database design? Overall, it is pretty good. With this design though we need to make sure there is no way for someone to update a user's username. In the next video we are going to discuss why. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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: 8769 Caleb Curry
SQL Server 26 - PRIMARY KEY, NOT NULL, UNIQUE
 
03:36
In the last video we created our first table, but I want to give SQL Server some extra information so the database knows more about each of the columns. The first thing is to establish the primary key. To do this all we do is add PRIMARY KEY after the column we want to be the primary key. Simple enough. When we add a constraint right after the column like this, it is often called a column attribute. CREATE TABLE Animals( ID INT PRIMARY KEY, Name VARCHAR(50), Species VARCHAR(50) ); Additionally, if you are using an ID column, it is best to have it labeled as the IDENTITY column. That way, SQL Server will automatically increment the number. CREATE TABLE Animals( ID INT PRIMARY KEY IDENTITY, Name VARCHAR(50), Species VARCHAR(50) ); The other attributes we've discussed in this series are NOT NULL and UNIQUE. We can make the name NOT NULL and the species NOT NULL. We don't have a good column for UNIQUE, so let's add one: CREATE TABLE Animals( ID INT PRIMARY KEY IDENTITY, Name VARCHAR(50) NOT NULL, Species VARCHAR(50) NOT NULL, ContactEmail VARCHAR(50) NOT NULL UNIUQE ); You can see that it is very easy to add multiple column attributes to a column. Just separate them by spaces. The order does not matter. Also, when you say primary key the column is automatically NOT NULL and UNIQUE. There are other attributes you can use including DEFAULT, FOREIGN KEY, and SPARSE. DEFAULT will give a value for a column if you do not put anything in yourself. Foreign keys are used to reference other columns. SPARSE is an attribute we haven't discussed. You can use SPARSE if most of the rows are going to have a NULL for a column and it saves storage space, but we will worry about that in another video. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support 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: 4722 Caleb Curry
NOT NULL AND CHECK CONSTRAINT IN ORACLE SQL WITH EXAMPLE
 
11:08
This video tutorial contains information about constraints in an RDBMS system, along with the inline and out of line constraint declaration type available in Oracle SQL. The video also demonstrates examples with check and not null constraint in Oracle SQL.
Views: 868 Kishan Mashru
SQL: Foreign Key Creation
 
05:55
In this tutorial, you'll learn how to create a foreign key column ....
Views: 43440 radhikaravikumar
Chapter 10 NOT NULL constraint in MySQL Hindi
 
20:07
Like, Comments, Share and SUBSCRIBE Visit www.mysirg.com for all FREE videos
Learn How to Update Data Rows using Update Statement in SQL
 
07:11
Learn about using UPDATE statement in SQL. As the name suggests UPDATE statement is used to update the data rows in a table. The UPDATE statement can update one or multiple column values in single SQL statement. WHERE clause is used to specify the data row to be updated. UPDATE statement without WHERE clause will update all the data rows in the table. Any existing data rows or records in target table remain unaffected. Here are the examples UPDATE statements, UPDATE tablename SET column1 = newvalue; UPDATE tablename SET column1 = newvalue1, column2 = newvalue2 WHERE columnid = 3; Select the "school" database, "USE school;" Run a simple SQL statement to display all the data rows in students table using SQL statement, "SELECT * FROM students;" Here in this result set, take a look at studentid 1. Suppose we have accidentally added this student record under class first instead of second. And now we are going to update this row to change the class value from 'First' to 'Second'. We will use the SQL statement, "UPDATE students SET class = 'Second' WHERE studentid = 1;" Press enter to execute the statement and display all the data rows in 'students' table, "SELECT * FROM students;" And sure enough the class value for studentid 1 is changed from 'First' to 'Second'. Check out the whole playlist of SQL Tutorials or Individual video from the following links, SQL Tutorial for Beginners. Introduction to SQL Basics https://www.youtube.com/playlist?list=PLhwzZMYRiUErXXX0Ryud2R7RjesCEdTqi 1.Learn What is SQL? Introduction to SQL https://www.youtube.com/watch?v=ox6zUOKascs 2.Learn How to Install MySQL Database Server on Windows Operating System https://www.youtube.com/watch?v=vtnoWaydkEU 3.Learn What is Database? How to Create and Show Databases using SQL https://www.youtube.com/watch?v=-yJgWq6K_U8 4.Learn How to Select and Use Existing Database using SQL https://www.youtube.com/watch?v=QMViQ38SPxc 5.Learn How to Delete or Remove Database using SQL https://www.youtube.com/watch?v=wjEOZKvfH4c 6.Learn What is Database Table? How to Create a Database Table using SQL? https://www.youtube.com/watch?v=8SvtNIfzC4o 7.Learn How to Modify or Update Database Table using SQL https://www.youtube.com/watch?v=1he5oZzG33o 8.Learn How to Delete or Remove Database Table using SQL https://www.youtube.com/watch?v=JD87WvBist0 9.Learn How to Add Data Rows in a Table using SQL https://www.youtube.com/watch?v=UB-bQxAQbWg 10.Learn How to Use INSERT INTO SELECT Statement in SQL https://www.youtube.com/watch?v=U4ApxHF4R1g 11.Learn How to Update Data Rows using Update Statement in SQL https://www.youtube.com/watch?v=lE1BmNbFJdo 12.Learn How to Delete Data Rows using Delete Statement in SQL https://www.youtube.com/watch?v=1ViqX1tFgYM Subscribe to my channel: https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw
Oracle Table Creation Inserting Records Null Values 1
 
13:31
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS , ADF, INFORMATICA, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
SQL tutorials 18: SQL Foreign Key Constraint By Manish Sharma
 
10:23
SQL Tutorial 18: SQL foreign key constraint. Topic covered in this tutorial 1. Defining SQL foreign key using create table at column level 2. Defining SQL foreign key using create table at table level 1. Defining SQL foreign key using Alter Table statement Links Website article: http://www.rebellionrider.com/sql-foreign-key.htm Primary key tutorial: http://www.rebellionrider.com/sql-foreign-key.htm Create Table Tutorial: http://www.rebellionrider.com/sql-create-table.html 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 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 Foreign key is an Input/output data constraint which is also known as referential integrity constraint. Foreign key represent a link or say a relationship between columns of tables. Similar to primary key constraint Foreign Key constraint is also of two types. Simple Foreign key constraint and Composite Foreign key constraint. Constraint which involves only one column in foreign key in child table and one column in reference key in parent table is called Simple Foreign Key. While the constraint which involves more than one column in foreign key in child table and more than one column in reference key in the parent table is called Composite Foreign Key.
Views: 102414 Manish Sharma
MySql basic querries - show, create, select, insert, delete, update, alter, drop, truncate
 
11:43
1) show databases 2) create database thewayur 3) use thewayur 4) show tables 5) create table nishu( id int(3) auto_increment primary key, name varchar(20) not null, age int(3)) 6) select *from nishu 7) insert into nishu (name,age) values('varun',21) 8) Update nishu set name ="sanjay" where id =2 9) delete from nishu where name ="varun" 10) alter table nishu add password varchar(16) not null 11) alter table nishu drop password 12) truncate table nishu 13) drop table nishu 14) drop database thewayur
Views: 22273 NishuFun
ORACLE SQL 38: Add, Rename, Modify column
 
06:31
http://studyandshare.wordpress.com/ http://www.facebook.com/groups/studyandsharevn/
Views: 735 studyandsharevn
Create Table with constraint Not Null  in Oracle "انشاء جدول بقيد"
 
16:42
Create table with a not null constraint and show how violation occurs. insure data integrity in the database Show how to get random sample data from http://www.generatedata.com/
Views: 204 Reda El Said
Learn Oracle | How to Create a Table using SQL | Not Null, Unique Key, Primary Key
 
14:50
Pebbles present, Learn Oracle 10g with Step By Step Video Tutorials. Learn Oracle 10g Tutorial series contains the following videos : Learn Oracle - History of Oracle Learn Oracle - What is Oracle - Why do we need Oracle Learn Oracle - What is a Database Learn Oracle - What is Grid Computing Learn Oracle - What is Normalization Learn Oracle - What is ORDBMS Learn Oracle - What is RDBMS Learn Oracle - Alias Names, Concatenation, Distinct Keyword Learn Oracle - Controlling and Managing User Access (Data Control Language) Learn Oracle - Introduction to SQL Learn Oracle - Oracle 10g New Data Types Learn Oracle - How to Alter a Table using SQL Learn Oracle - How to Create a Package in PL SQL Learn Oracle - How to Create a Report in SQL Plus Learn Oracle - How to Create a Table using SQL - Not Null, Unique Key, Primary Key Learn Oracle - How to Create a Table using SQL Learn Oracle - How to Create a Trigger in PL SQL Learn Oracle - How to Delete Data from a Table using SQL Learn Oracle - How to Drop and Truncate a Table using SQL Learn Oracle - How to Insert Data in a Table using SQL Learn Oracle - How to open ISQL Plus for the first time Learn Oracle - How to Open SQL Plus for the First Time Learn Oracle - How to Update a Table using SQL Learn Oracle - How to use Aggregate Functions in SQL Learn Oracle - How to use Functions in PL SQL Learn Oracle - How to use Group By, Having Clause in SQL Learn Oracle - How to Use Joins, Cross Join, Cartesian Product in SQL Learn Oracle - How to use Outer Joins (Left, Right, Full) in SQL Learn Oracle - How to use the Character Functions, Date Functions in SQL Learn Oracle - How to use the Merge Statement in SQL Learn Oracle - How to use the ORDER BY Clause with the Select Statement Learn Oracle - How to use the SELECT Statement Learn Oracle - How to use the Transactional Control Statements in SQL Learn Oracle - How to use PL SQL Learn Oracle - Data Types in PL SQL Learn Oracle - Exception Handling in PL SQL Learn Oracle - PL SQL Conditional Logics Learn Oracle - PL SQL Cursor Types - Explicit Cursor, Implicit Cursor Learn Oracle - PL SQL Loops Learn Oracle - Procedure Creation in PL SQL Learn Oracle - Select Statement with WHERE Cause Learn Oracle - SQL Operators and their Precedence Learn Oracle - Using Case Function, Decode Function in SQL Learn Oracle - Using Logical Operators in the WHERE Clause of the Select Statement Learn Oracle - Using Rollup Function, Cube Function Learn Oracle - Using Set Operators in SQL Learn Oracle - What are the Different SQL Data Types Learn Oracle - What are the different types of Databases Visit Pebbles Official Website - http://www.pebbles.in Subscribe to our Channel – https://www.youtube.com/channel/UCNNjWVsQqaMYccY044vtHJw?sub_confirmation=1 Engage with us on Facebook at https://www.facebook.com/PebblesChennai Please Like, Share, Comment & Subscribe
Views: 187 Pebbles Tutorials
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: 97 EqualConnect Coach
NULL values in DBMS...how to insert null value in table in sql
 
02:07
how to insert null value in table in sql -~-~~-~~~-~~-~- Please watch: "हँसी नहीं रोक पाओगे 100% Guarantee | Indian Funny Videos | Whatsapp Funny Videos😀😀" https://www.youtube.com/watch?v=kbwh5NwXQYo -~-~~-~~~-~~-~- #sqltutorial#oracletutorial#databasetutorial
Views: 1590 Viral Fun Tube
SelectTec | Aula Nº 12 |Create Table Primary key - Oracle SQL Developer
 
07:16
primary key syntax: create table nome_tabela (coluna1 tipo not null, coluna2 tipo, constraint nome_pk primary key (coluna1) );
Views: 3491 SelectTec
Oracle Unique Constraint تعليم اوراكل
 
08:22
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج How To Add Unique Constraint to Table. Unique كيف تستخدم قيد الــ Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W oracle create table statement oracle drop table statement oracle constraints database constraints primary key constraint foreign key constraint check constraint null not null constraint unique constraint
ON DELETE CLAUSE OF FOREIGN KEY CONSTRAINT IN ORACLE SQL WITH EXAMPLE (CASCADE/SET NULL/NO ACTION)
 
15:31
This is a free video tutorial explaining about the nonmandatory on delete clause in the foreign key constraint in Oracle SQL database, the video explains about how the on delete set null and on delete cascade works, how it can be implemented with easy to understand examples. We have also shown practical demonstration on creating the foreign key constraint, and then deleting the data from the parent table and observing the changes that take place in the child table.
Views: 1408 Kishan Mashru