Home
Search results “Oracle alter modify nullable”
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: 16082 Lecture Snippets
55. ALTER TABLE to Modify existing column in PL/SQL Oracle
 
08:00
In this video you will learn about ALTER TABLE to Modify existing column 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: 4350 ITORIAN
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: 17332 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: 5318 Caleb Curry
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: 22445 Caleb Curry
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: 520 IT Port
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: 1965 PG Casts
How to filter Rows with Null Values in Select Statement - SQL Server / TSQL Tutorial Part 110
 
09:08
SQL Server / T-SQL Tutorial Scenario: How to filter Rows with Null Values in Select Statement in SQL Server Let's say that you are working as SQL Server developer. You need to write two queries 1) Return all the records from dbo.Customer table where Address column has Null values 2) Return only the records from dbo.Customer table where Address column has the values other than Null. Link to scripts used in SQL Server / TSQL Tutorial Video http://www.techbrothersit.com/2016/06/how-to-filter-rows-with-null-values-in.html Check out our website for Different SQL Server, MSBI tutorials and interview questions such as SQL Server Reporting Services(SSRS) Tutorial SQL Server Integration Services(SSIS) Tutorial SQL Server DBA Tutorial SQL Server / TSQL Tutorial ( Beginner to Advance) http://www.techbrothersit.com/
Views: 4061 TechBrothersIT
NULL values in DBMS...how to insert null value in table in sql
 
02:07
how to insert null value in table in sql #sqltutorial#oracletutorial#databasetutorial
Views: 1776 Viral Fun Tube
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.
NULL-Related Functions in Oracle
 
02:52
An overview of some of the functions Oracle provides to handle NULL values in SQL and PL/SQL. For more information see: https://oracle-base.com/articles/misc/null-related-functions Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Bjoern Rost Blog: http://portrix-systems.de/blog/brost/ Twitter: https://twitter.com/brost Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 2740 ORACLE-BASE.com
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: 3023 Intact Abode
Oracle 12C Tutorial 20 - Constraints (Primary, Foreign, Unique, Null etc.)
 
19:41
This Video Tutorial Will Describe about various constraints we can use with tables. Some of the constraints can used as table level or column level so also known as table level constraints and column level constraints. These 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. In this video i explain Not Null Constraint, Unique key Constraint, Primary Key Constraint, Foreign Key - Reference key Constraint, Check constraint and user_constraints table. Full Syntax will be given in this video tutorial about how to use these constraints. Along with live example to execute Not Null Constraint, Unique key Constraint, Primary Key Constraint, Foreign Key - Reference key Constraint, Check constraint and user_constraints table . All the keywords, format, mandatory clauses etc are described in this video.
ORACLE SQL 38: Add, Rename, Modify column
 
06:31
http://studyandshare.wordpress.com/ http://www.facebook.com/groups/studyandsharevn/
Views: 737 studyandsharevn
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: 92048 The Bad Tutorials
Oracle Database 12c: Improved Defaults
 
05:59
Tom Kyte and Chuck Murray describe several improvements to default behavior in Oracle Database 12c: defaults based on sequences, default on NULL, Identity type columns, and metadata-only defaults. For more information: "CREATE TABLE" statement in Oracle® Database SQL Language Reference http://www.oracle.com/pls/topic/lookup?ctx=db121&id=SQLRF01402 "ALTER TABLE" statement in Oracle® Database SQL Language Reference http://www.oracle.com/pls/topic/lookup?ctx=db121&id=SQLRF01001 "Identity Columns" in Oracle® Database Migration Guide http://www.oracle.com/pls/topic/lookup?ctx=db121&id=DRDAA109
Views: 2203 OracleDBVision
56. ALTER TABLE to ADD and DROP integrity constraints in PL/SQL Oracle
 
10:39
In this video you will learn about ALTER TABLE to ADD and DROP integrity constraints 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: 3820 ITORIAN
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: 334 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: 67 Tech Acad
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
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
APEX27 of 30: Organize IG report: change column order, group & count rows. Issue with  NULL & COUNT.
 
09:53
APEX 18.1 video 27 of 30: Do some housekeeping: Assign new pages to page groups. See some more features in the interactive grid and interactive report pages for organizing and summarizing data. Reorder columns. Use the “control break” and “count” features. See an issue using COUNT when a field might have null values (no data).
Views: 310 Jennifer Kreie
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: 469 Agossi SQL
ORACLE SQL AND PL/SQL INTERVIEW QUESTION : HOW TO CHANGE DATATYPE IN ORACLE SQL?
 
13:16
This video contains a demonstration on how to change the datatype of a column containing data, the video shows two approaches through which any user can easily change the datatype of a column in a table, the video also helps in solving the Oracle ORA-01440 error.
Views: 1093 Kishan Mashru
SQL TUTORIAL-4 (Create table, Alter table, ADD and DROP column, MODIFY Column Data type)
 
08:41
SQL queries for 1. Create table 2. Add new Column 3. Drop a column 4.change column data type
Views: 18585 simran kaur
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: 18464 Joey Blue
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: 3276 The Magic of SQL
SQL tutorial 19: ON DELETE SET NULL clause of Foreign Key By Manish Sharma (RebellionRider)
 
07:44
SQL Tutorial 19 : ON DELETE SET NULL foreign key Clause. Links used in the tutorial On delete set null website article [ download SQL script from same link] : http://www.rebellionrider.com/on-delete-set-null.htm Foreign Key Tutorial Video : http://youtu.be/0nbkBI5r3Gw Foreign Key Tutorial Blog : http://www.rebellionrider.com/sql-foreign-key.htm This video is the part of foreign key video In this sql tutorial you will learn the referential clause ON DELETE SET NULL of foreign key. On Delete Set null clause guarantee the relation integrity in foreign key/ 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 liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Views: 49197 Manish Sharma
Oracle Tutorials | Unique, Not Null & Check  Constraints in Oracle Part- 1 | by Mr.Sudhakar L
 
14:24
Oracle Tutorials | Unique, Not Null & Check Constraints in Oracle | by Mr.Sudhakar L #Oracle #Constraints #Tutorials ** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 ► Visit Our Website for Classroom Training: https://nareshit.in ► For Online Training: https://nareshit.com/ -------------------------- ► About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ► Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Follow us on Linkedin: https://in.linkedin.com/company/naresh-i-technologies ► Follow us on Instagram: https://www.instagram.com/nareshitech/
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: 102083 Manish Sharma
Oracle username and password and Account unlocking
 
08:37
all education purpose videos
Views: 282707 Chandra Shekhar Reddy
54. ALTER TABLE ADD new column and DROP existing column in PL/SQL Oracle
 
05:31
In this video you will learn about ALTER TABLE ADD new column and DROP existing column 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: 4679 ITORIAN
how to use and change the port of glassfish server
 
03:59
this video shows how to use glassfish server and change the port of glassfish server
Views: 29351 Java Oracle
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: 195 Pebbles Tutorials
Null value in oracle
 
09:08
this video describes null concept in oracle. join the group and share your knowledge and ask your doubts. https://www.facebook.com/groups/940425699338535/
NOT NULL Constraint in Oracle Database
 
03:48
NOT NULL Constraint in Oracle Database
Oracle SQL Video Tutorial 3 : NULL
 
07:32
Oracle SQL Video Tutorials 3 : Null Values
Views: 1754 Just Channel
SQL tutorial 74: SQL COALESCE Function In oracle Database Manish Sharma
 
04:44
Third tutorial in SQL Null Series. Coalesce Null function with example in oracle Database. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/sql-coalesce Previous Tutorial ► NVL https://youtu.be/aRoTR5Jn6K0 ► NVL2 https://youtu.be/SCwc0HcS1-U ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 27613 Manish Sharma
MSSQL - How to, Step by Step Change Data Capture (CDC) Tutorial
 
10:46
Download example from my Google Drive - https://goo.gl/3HYQcH REFERENCES http://technet.microsoft.com/en-us/library/cc645937.aspx http://technet.microsoft.com/en-us/library/dd266396(v=sql.100).aspx Change data capture cannot function properly when the Database Engine service or the SQL Server Agent service is running under the NETWORK SERVICE account. This can result in error 22832. 0) CDC Can not be enabled when Transactional Replication is on, must turn off, enable CDC then reapply Transactional Replication 1) Source is the SQL Server Transaction Log 2) Log file serves as the Input to the Capture Process 3) Commands a. EXEC sp_changedbowner 'dbo' or 'sa' b. EXEC sys.sp_cdc_enable_db / EXEC sys.sp_cdc_disable_db c. EXEC sys.sp_cdc_enable_table / d. EXEC sys.sp_cdc_help_change_data_capture -- view the cdc tables e. SELECT name, is_cdc_enabled FROM sys.databases 4) To SELECT a table you must use the cdc schema such as cdc.SCHEMANAME_TABLENAME_CT iand its suffixed with CT 5) Columns a. _$start_lsn -- commit log sequence number (LSN) within the same Transaction b. _$end_lsn - c. _$seqval -- order changes within a transaction d. _$operation -- 1=delete, 2=insert,3=updatebefore,4=updateafter e. _$update_mask -- for insert,delete all bits are set, for update bits set correspond to columns changed 6) Note CDC creates SQL Agent Jobs to move log entries to the CDC tables, there is a latency 7) There is a moving window of data kept, I believe the default is 3 days. 8) At most 2 capture instances per table USE AdventureWorks2008R2 GO EXEC sp_changedbowner 'sa' EXEC sys.sp_cdc_help_change_data_capture EXEC sys.sp_cdc_enable_db EXEC sys.sp_cdc_disable_db SELECT * FROM cdc.change_tables SELECT * FROM cdc.Address_CT SELECT * FROM cdc.Person_Address_CT ORDER BY __$start_lsn DESC EXEC sys.sp_cdc_disable_table @source_schema = N'Person' , @source_name = N'Address' , @capture_instance = N'Address' EXEC sys.sp_cdc_enable_table @source_schema = N'Person' , @source_name = N'Address' , @role_name = NULL -- , @capture_instance = N'Address' , @capture_instance = NULL , @supports_net_changes = 1 , @captured_column_list = N'AddressID, AddressLine1, City' , @filegroup_name = N'PRIMARY'; GO INSERT INTO AdventureWorks2008R2.Person.Address (AddressLine1,AddressLine2,City,StateProvinceID,PostalCode,SpatialLocation,rowguid,ModifiedDate) VALUES ('188 Football Avenue', 'Suite 188', 'Seattle', 10, '80230', NULL, NEWID(), GETDATE()); SELECT TOP 1 * FROM Person.Address ORDER BY AddressID DESC UPDATE Person.Address SET AddressLine1 = '199 Football Ave' WHERE AddressID = 32524 DELETE FROM Person.Address WHERE AddressID = 32524 GO
Views: 40549 CodeCowboyOrg
Oracle Database | Bangla Tutorials 23 :: Constraint Not null
 
01:33
www.facebook.com/oracle.shohag Email : [email protected] Website : www.oraclebangla.com Topics : Constraint Not null
Views: 988 Oracle Bangla
58. Create, Alter and Drop named constraints in PL/SQL Oracle
 
05:41
In this video you will learn about Create, Alter and Drop named constraints in Oracle. For Support =========== Email: sup[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: 3282 ITORIAN
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]_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 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: 16025 Caleb Curry
Oracle Sql Step by Step Approach (041 how are null values treated while sorting data)
 
02:07
Oracle Sql Step by Step Approach (041 how are null values treated while sorting data) 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 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: 9351 Caleb Curry
Reading SQL:  Inserting New Rows, with Null Values: SQL Tutorial  84
 
00:32
Please watch: "Install Oracle Database 12c Release 2 on Windows 10 Professional 64 bit" https://www.youtube.com/watch?v=5705VFJmku0 -~-~~-~~~-~~-~- : SQL Tutorial
Views: 44 Solution Wizard
How to Change Schema Password Using Oracle SQL Developer | Oracle SQL Developer Tips and Tricks
 
01:56
How to Change Schema Password Using Oracle SQL Developer | Oracle SQL Developer Tips and Tricks Oracle SQL Tutorial for Beginners Oracle SQL Developer Tips and Tricks Oracle Tutorial for Beginners Oracle Database Tutorial for Beginners Oracle SQL Developer Tips and Tricks Oracle Tutorial How to change sql developer password Changing password with Oracle SQL Developer How to Change Oracle Schema Password How to Change Schema Password in Oracle How to Change Password Using Oracle SQL Developer Resetting Your Oracle Database Password with Oracle SQL Developer oracle database, password reset using sql developer Reset Oracle Schema Password Using Oracle SQL Developer
Views: 167 Oracle PL/SQL World
Difference between Delete and Truncate and Drop in Oracle Sql
 
14:04
This is a free tutorial on understanding difference between drop, delete and truncate statements. I have tried to cover most of the major difference between all these three statements and have also shown the same with simple and easy to understand examples. Hope it will be helpful to all. If you want more such videos of exciting and amazing 'difference between' concepts, check out the links below : union and union all : https://youtu.be/n9FqQOd8liY char and varchar2 : https://youtu.be/039qzwjWf4k replace and translate : https://youtu.be/HKYF77BGzOE procedure and function : https://youtu.be/q3LmOenL120 in and exists : https://youtu.be/REX4IjRYlFw rank and dense_rank : https://youtu.be/WGSX998hZ9M %type and %rowtype : https://youtu.be/MlLUFeZ_3eM
Views: 1874 Kishan Mashru
How to Change Oracle SQL Developer Font Type & Font Size | Oracle SQL Developer Tips and Tricks
 
02:02
How to Change Oracle SQL Developer Font Size & Font Type | Oracle SQL Developer Tips and Tricks Oracle SQL Tutorial for Beginners Oracle Database Tutorial for Beginners Oracle SQL Developer Tips and Tricks Oracle Tutorial Oracle Tutorial for Beginners how to change sql developer font size how to configure sql developer for oracle sql developer ui font size how to change sql developer font type How to increase font size in sql developer Oracle SQL Developer Tips and Tricks How to increase font size in Oracle sql developer How to increase font size in pl sql developer How to chnage font in pl sql developer How to chnage font in sql developer best font for sql developer Oracle SQL Developer Tips and Tricks sql developer ide font size sql developer high resolution sql developer high dpi Oracle SQL Developer Tips and Tricks sql developer resolution oracle sql developer ui font size
Views: 389 Oracle PL/SQL World
SQL - Mais Primary Key e not null
 
07:38
Curso Oracle PL/SQL Essentials http://bit.ly/1N3upVn Curso Oracle SQL Expert - Certificação 1Z0-047 http://bit.ly/1G4rKWG Curso Oracle Aprendendo SQL - Preparatório exames 1Z0-051/1Z0-061 http://bit.ly/1eqDlsr Curso de Administração de Redes de Computadores http://goo.gl/nXjaXS Neste Curso de SQL aprenda a linguagem universal de banco de dados onde poderá ser aplicada em qualquer SGBD. Para se aprofundar em banco de dados acesse os links da descrição e confira ótimos cursos. Tags: sql cursos gratuitos curso sql banco de dados comandos sql
Views: 1019 Cursos Interativos