HomeОбразованиеRelated VideosMore From: OCP Technology

How to insert records in multiple tables at same time

51 ratings | 41973 views
How to insert records in multiple table at same time step by step, In this video i'm discus two methods for inserting records in multiple table at same time. #insert #ocptechnology #oracle12c
Html code for embedding videos on your blog
Text Comments (8)
OCP Technology (26 days ago)
#ocptechnology #4usupport (My other channel in Hindi). Thanks for watching please keep supporting.
A 1 App Builders (2 months ago)
email: [email protected] Help. I'm using phpmyadmin. I have the tables all set up. problem - using visual basic i export the database information I want to change/add to the existing tables. There is 6 of them and all works fine. using *.csv file. when I first imported/created the database it has oh 50 tables and all the data was install correct. What I need to do in a text file that I would import is to truncate the tables only 6 table. leaving the structure of the tables and then import the data into the right tables (and do it with one file). Can it be done. Thanks looking forward to hearing from anyone. what am I doing wrong below. TRUNCATE TABLE oc_product_description; TRUNCATE TABLE oc_product_reward; TRUNCATE TABLE oc_product_to_category; INSERT INTO `oc_product_description` (`product_id`, `language_id`, `name`, `description`, `tag`, `meta_title`, `meta_description`, `meta_keyword`) VALUES (1, 1, 'Large Monticello Candle Lantern', 'The stately design of this candle lantern will dress up your home indoors or out. Use the front latch to open the door and insert the candle of your choice. The clear glass panels and the antiqued frame are the perfect accent to beautiful candlelight and the lantern can rest on its base or be hung from the top loop. Candle not included. 20 1/4 high with loop at top. ', '', 'Large Monticello Candle Lantern', 'lanterns', 'lanterns'), (2, 1, 'Large Wire Vase Candleholder', 'This large wire vase turns candlelight into modern glow! Insert a candle of your choice inside the glass cup and light it to create contemporary shine in your room. glass holder: 4 x 4 x 13 high. ', '', 'Large Wire Vase Candleholder', 'candles', 'candles'), (3, 1, 'Antiqued Iron 5-Candle Stand', 'Set the night aglow with help from this romantically rustic candelabra. Five candle seats are perched on top of scrolling wrought iron flourishes finished with antiqued paint to look like an old-world treasure. Place it on your mantel or tabletop and light the candles of your choice for spectacular shine! ', '', 'Antiqued Iron 5-Candle Stand', 'candles', 'candles'), INSERT INTO `oc_product_reward` (`product_reward_id`, `product_id`, `customer_group_id`, `points`) VALUES (1, 0, 1, 2), (2, 0, 1, 2), (3, 0, 1, 2), INSERT INTO `oc_product_to_category` (`product_id`, `category_id`) VALUES (1, 88), (2, 85), (3, 85),
samira virgo (8 months ago)
Hello, thanks for useful video. May I have your email address, please
OCP Technology (8 months ago)
samira virgo thanks for watching [email protected]
jamsheer kutty (1 year ago)
plz explain why select 1 from dual is written in first method ?
ronak modi (1 year ago)
you can also write select * from dual;
siddhartha rao (2 years ago)
I came to know the 2nd method after watching this video..Thank You..
Arun kumar (1 year ago)
yes, me tooo

Would you like to comment?

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