HomeОбразованиеRelated VideosMore From: Lecture Snippets

SQL with Oracle 10g XE - Using INSERT to Add Partial Data to a Table

21 ratings | 8405 views
In this video I use the INSERT command to add a record that has only partial fields. In order to do this you must declare what fields you want to add with the INSERT command. The command I used to add a book to the Books table is: INSERT INTO BOOKS (BOOK_ID, ISBN_10, TITLE, CATEGORY, AUTHOR_ID) VALUES ('11','553108034','A Clash of Kings', 'Fiction',2); 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.
Html code for embedding videos on your blog
Text Comments (2)
ComputerTechFun (2 years ago)
ORA-00001: unique constraint (SYSTEM.SYS_C004057) violated like this error comes please help me out
Sabeen Azmat (3 years ago)
Hi Sir, I did the same thing as you did in your tutorial but i am getting an error ' ORA-00001: unique constraint (SYSTEM.SYS_C003994) violated ' . Could you please help me with this? Thanks Sabeen

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.