Oracle Tutorial 1 - Part 3

This video shows you have to check your Oracle 11g install to make sure everything is installed correctly. You will also see how to access the SQL*Plus Window, Login and create your first table. SQL syntax and language will be discussed in the next lecture.

[@hatemshnshn3839]

Perfect videos, really helpful, I hope you continue in this series.

[@americancitizen748]

Very good video for the novice. Thank you!

[@ranaamit1423]

very very nice video........that's really a privilege to watch this one............nice work :)

[@RANAJAMIL778]

this very nice video so must watch it i got lots of knowledge so i love it thanks

[@AdilJawed]

nice tutorial i loved the way you explained and the most awesome was when citylist not found and you made that g.o.t sound ta tata ta haha nice one and nice explanation too am new in it

[@GeekyMushroom]

You may have same version as me, the express version, It did ask for password during install, just not the same window as Barbara had, or you installed this before and the password was already there. If that is the case uninstall it completly and reinstall, paying attention for password window. To follow along with Barbara, I had to goto my oracle programs menu, select option to start database, then I selected program to start SQL command Line. I typed in this command:

[@ulyssesmoore7085]

Great tutorial for beginners.

[@dhunsyamdaji]

thanks really helped really simple and showed common errors thanks for helping me get started

[@benjamindrury777]

Great Tutorial. I wish there was a part 4. Has anyone found anything comparable to this lovely instruction?

[@labpluto123]

Great video! Definitely helped a lot. By the way, where do I find the powerpoint slides you mentioned? Thanks!

[@bjhecker]

I have an entire Oracle Playlist on this channel. I'm not sure where to find other videos but a simple Google search should produce some.

[@oronno87]

nice and informative video. thanks a lot..

[@MrAaCauchi]

Hi Ms Hecker, very useful lectures. Can you be so kind as to send me the link to the next lecture after this one?, that is, Lecture 4 where you will use primary keys, link tables, etc?

[@KJB484]

Very helpful but I was wondering if there was a part 4?

[@tuttirulla]

Part 4 would be appreciated.

[@asanyal296]

Hi - this is a great video. Just what I needed. But where can I find parts 1 and 2 or the powerpoints that you mention. On this account I can see other Oracle videos but those are somewhat unrelated it seems. I need videos that you might have that are hands on with SQL plus.

[@rohityeram5384]

Thank you for this video.

[@halfmanwawe8423]

I tried to create same your table in sql plus but there is issue error at line one missing or invalid option

[@GeekyMushroom]

Thank you for posting your video. When I searched for 11g, I ended up with express version 11.2.0.2.0 I don't have all the same options in my programs menu. Are you using a full version of the program or have the now only release an express version. Thanks@

[@mmmooommmzaz]

to start your oracle service in windows environment type net start oracleservice... where dots are your database name to connect type set oracle_sid=database name if you are connecting from cmd you dont need a listener but if u dont type lsnrctl start in cmd this should start your listener

[@mohsenabdullah1654]

how do I see what is in the table, without all the information showing vertically, I tried, select * from Customer;

[@rajanvaishnav]

thanks a lot

[@leo874life]

Im using vista oracle 11.2g express. So it might not be the same but think you made a mistake. if you dont get that log in screen you have to type in connect, then it will ask for a user-name. and password

[@mamgoran4355]

thanks but I tried to create table as you did but at the end of number 5( zipcode number(5) unique>; ) I do enter give me error message and says(ERROR at line 1; ORA-00922: missing or invalid option) , could you please help to know what is this error and how i can fix to continue with your videos to learn oracle program? thanks in advance

[@janemccoy8213]

I got everything installed, however, it never asked me to enter the password. Now, I can't access to it. Is there anyway that we can get it reset?

[@mmmooommmzaz]

@MidMeOn yes i can because you did not set your oracle_sid type set oracle_sid=database name in cmd

[@selvisaranya9657]

nice video

[@nurawadahismail02]

your explaination is good

[@meenabm9668]

Hi..Thanks a lot for this tut..can u plz let me know wats wrong wit the below command SQL> CREATE TYPE t_experience AS OBJECT(CompanyName varchar2(20),Position varcha r2(20),NoOfYears number(2)); 2 3 4 Thanks in advance

[@MidMeOn]

i got this error can you explian why i get this : ORA-12560: TNS:protocol adapter error

[@fishcious]

What is the title of the next video in the series?

[@sangeenjan1]

nice ,,,, thanks

[@Khatiwodak7]

thank you

[@BhuwanThanet]

how can i find other tutorial of this video

[@GeekyMushroom]

Connect AS SYSDBA; it then asked me for my user name, I typed system as the user name and the next it asks for is password, and this is the password you type. This will allow you to follow along with Barbara.

[@janemccoy8213]

Thank you for this video. I am giving up. There is something wrong with mine. I never saw a window where it asked for a password. I'll learn something esle.

[@jayesh44781]

can you plz explain where to download this Oracle OraDb11g_home1 software ??

[@adaseth]

I believe that the date was just the current date and the "Production" was a part of the title.

[@rameshh6830]

how to find the database address,database servicename in Oracle 11g

[@ihamouinemohamedamine1736]

tnsping database

[@cyf6412]

where is the next video?

[@cherrysingh1349]

my account got locked!! ....tell me what to do??

[@samanthaquintero1732]

where are all the videos

[@mikerayco]

@MidMeOn i get the same error!

[@ShravanKumar-zc5jx]

"clear screen;" command to clear the screen.

[@mmmooommmzaz]

cl screen

[@Koyoshinkai]

Do not download Oracle application, un-istalling it is a NIGHTMARE.

[@anahipena5108]

You take too much time to explain a simple thing.

[@savsurfin21]

Not intended to insult you: Please talk less yet providing the most important information. I found losing interest in listening to you. Sorry