How To Create and Populate Tables in SQL Developer
Vložit
- čas přidán 4. 10. 2013
- 📝 Get my free SQL Cheat Sheets: www.databasestar.com/get-sql-...
🎓 Learn and become confident in SQL: databasestar.mykajabi.com/sql...
A demonstration of how to create and populate the tables needed for the Introduction to Oracle SQL course. - Jak na to + styl
Very well and clearly explained tutorial! Thank you!
Glad you like it!
Thanks sir helped me for my project
Glad it helped!
does this software need oracle 11g or oracle 12c to create, edit and/or delete tables ?
or does it work without it?
if not then how do i go about it?
also how to access saved tables?
I have just installed oracle SQL developer v4.0.3 , so are the mechanisms the same for this too?
You should be able to use this with any version of Oracle (11g or 12c) as the SQL is standard.
To access the saved tables, you can run a SELECT statement on them (SELECT * FROM ). I have some other videos that show you how to do this.
Hope this helps!
No, what i meant was is it a stand alone software or does it need oracle 11g or12c to run (create table , run queries ,etc.)?
Tejas Patel Oh, I see. Yes, you'll need to install Oracle Express, which is the actual database, and SQL Developer which is how you query the database. You might also need Java JDK to run it.
I have a few videos on my playlist on CZcams here which explain how to download and install these, which you can see here:
czcams.com/play/PLZDOU071E4v7KSeIwKjtJxuEwWq3iSaGO.html
Thanx for the intel
Hi there ! I hope that all is well, thank you for the lovely video, where may I find the scripts to practice ?? I am not signed up anywhere I just want to use it to practice
Glad you like the video! I don't have the scripts handy for this video unfortunately...
Hi where can i download the sql folder script for practice?
Mike Brown Hi, I've used this as part of my Introduction to Oracle SQL course on Udemy, so you can download the file there if you've signed up.
lekker bezig pik Hugs from the netherlands
i am getting error like
Error starting at line : 1 in command -
DROP TABLE Enrollment
Error report -
ORA-00942: table or view does not exist
00942. 00000 - "table or view does not exist"
*Cause:
*Action:
This error happens because the enrollment table does not exist. Is it spelt correctly? Can you create the table?
10 years ago wow. I’m curious to know how are you and if this kind of programming was worth it also what are you doing these days, what do you work in and your role. That is quite some experience brother. I do not wanna be a creep but I’m just getting started and I’m tryna know if there’s light at the end of the tunnel.
Wow, yeah this video is 10 years old! I'm still doing a similar thing - running this CZcams channel (which I've been working on better videos since 2020), working on the Database Star website, and a day job. My day job is a role called a Business Analyst which doesn't involve much SQL but I do this on the side.
Can you give link, where i can downloand this script? , thx)
Hey, I don't think I have this script anymore as it's one of my older videos.
@@DatabaseStar U don’t save this file ?
NO CODE ..... NO SUBSCRIPTION.....
What do you mean, Daniel?
@@DatabaseStar the practice files