SQL with Oracle 10g XE - Using INSERT to Add Partial Data to a Table
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.
On this page of the site you can watch the video online SQL with Oracle 10g XE - Using INSERT to Add Partial Data to a Table with a duration of hours minute second in good quality, which was uploaded by the user lecture snippets 24 July 2011, share the link with friends and acquaintances, this video has already been watched 13,609 times on youtube and it was liked by 49 viewers. Enjoy your viewing!
