HomeОбразованиеRelated VideosMore From: Manish Sharma

Oracle Database11g tutorials 5: how to retrieve Data Using SQL SELECT statement || SQL tutorials

759 ratings | 198778 views
This SQL tutorial and Oracle database 11g tutorial for beginners will show how to retrieve data using SQL SELECT statement. Tool used in this tutorial is SQL developer. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 You can download the Script which is used in this SQL tutorial from this link https://copy.com/yDQ46Tb64efm Contacts Email [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/RebellionRider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from The Code makers
Html code for embedding videos on your blog
Text Comments (54)
Nargis Nur (25 days ago)
Gv m some directions
Nargis Nur (25 days ago)
Hi manish ...I saw ur vdo I want to parfect in oracle database ..please give m some idea
Maths_kamlesh (7 months ago)
I cannot find employee table in sample database I have just installed SQL developer
Every video by you, I watched till now is very useful.....Thanks a Ton!!!
Jaideep V (11 months ago)
Hi Manish. This is Jaideep, I am unable to access through COPY.COM as the that service is no long exists. So please help me with this.
jmal salih (1 year ago)
Thanks Manish.Great work .
오승택 (1 year ago)
hey sir, thank you for sharing your video. but I couldn't download your sql file..and this cours could cover everything for certification of OCP?? or OCA?
Suhel Inamdar (1 year ago)
sir i want know information about where the tables and database are stored in our localhost??
Suhel Inamdar (1 year ago)
Thank you sir
Manish Sharma (1 year ago)
Tables and other objects are stored in the database schema. For example, the tables used in this tutorial are the part of HR schema of the database.
Cruiser Ride (1 year ago)
Manish can you please help me with the tables. I want to practice SQL Command but i am not having any tablespace and schema so from where we can download it and after download when it will go in download folder how will i import it. Please Help...
Marcos Almeidah (2 years ago)
Hello, Manish can you available the table that you used, please .How did you make? thank you.
novakaneneri (2 years ago)
Yo Manish!! your videos help me a lot man keep up the awesome work.
dj & pj (2 years ago)
when i try to connect data base its gives error: ORA_12505, TNS: listener does not currently know of SID given in connect descriptor......
Bashiiri Mohamoud (2 years ago)
GO TO C:\app\ABC\product\11.2.0\dbhome_1\NETWORK\ADMIN THEN tnsnames.ora OPEN THAT FILE THEN SEE SID WHAT IS WRITTEN BRO
Bhadra Kona (2 years ago)
Hi manish The cloud links that you given in the description are not loading. it says "too long to respond". how can I solve the issue? help me out pls.
Walid Saleh (2 years ago)
i need this database to practice on it ,would you kindly provide us the link please.
Divya Gupta (2 years ago)
audio should be more clear
table reference does not work (((
Manish Sharma (2 years ago)
Apologies for the inconvenience. Initial videos were recorded using laptop’s inbuilt microphone but later I switched over to a professional mic. Hope you find the audio in the later videos clearer. Thanks for bearing with me.
Hartron Billing (2 years ago)
how do i connect oralce 11g with visual studio 2015
M Nagarjuna (2 years ago)
Hi Manish. This is Nagarjuna, I am unable to access through COPY.COM as the that service is no long exists. So please help me with this.
Bhadra Kona (2 years ago)
I am also facing the same issue.
theo motsisi (2 years ago)
Great videos Manish learning a lot and fast, quick question how did you format your script output to display results in a grid form?
theo motsisi (2 years ago)
+theo motsisi Never mind, had to execute using F9 :)
Shagun Kansal (3 years ago)
how can i load a dummy database in sql developer
Manish Sharma (3 years ago)
+Shagun Gupta Please watch this tutorial. hope you will find it helpful https://youtu.be/gR47cdxZibA
SinghaiGglobe (3 years ago)
sir i want to try all the queries on my command prompt first, but whenever i try to connect with database it shows an error and even when i open up the link that copied when i install the oracle 11g, it also showing an error like as 503 bad server... sir but when i try to connect sysdba as sys user it gets connected... but queries r not working plz help.... \\\\\Thanks/////
Bilal Mazhar (3 years ago)
hy i have question that i have prepared my self from books and tutorials so i can give certification exam ??? do i need training certificate for to sit in exam ????
B.N Gupta (3 years ago)
Thanks Manish !!! Great JOB
Mohammad Aman (3 years ago)
how to create username and password like u created username= sys and pwd = oarcale
Vijay G (3 years ago)
if possible show some real-time work or any project that would be lot more helpful.....anyhow u did a great job
Vijay G (3 years ago)
thanks alot manish... i am learning oracle . your videos helped me alot...
Vinod Kumar (3 years ago)
Hi Manish, Can we update single letter at particular position of the word... e.g if the word is Manish I should update the letter 'a' at 2nd position to some other letter let it be 'i' , now after updating the result should be Minish note:- update should not affect the other positions of the same letter in that word. I have gone through almost all videos.
mohammed shoab (3 years ago)
Great tutorial! Thank You.
Deepan Dhanabal (3 years ago)
can i workout in the sql plus
Manish Sharma (3 years ago)
+Deepan Dhanabal Sure, why not after all all the command and statements showed in all the tutorial on my channels are also command line and linux terminal compatible.
san dav (3 years ago)
Hi Manish, Thanks for the video tutorial it's very helpful. i have tried 4 to 5 times to install Oracle11gR2 but every time show me the same error that "[INS-13001] Environment does not meet minimum requirements" on my windows 8.1 laptop with high hardware and software configurations but finally i was able to install Oracle database 12c and also created connection between database and sql developer. Now i was trying to run sql statement like select statement but it show following error ORA-02019: connection description for remote database not found 02019. 00000 -  "connection description for remote database not found" *Cause:     *Action: Error at Line: 1 Column: 25 what is this meaning for this error. Kindly help me out. Thanks.
raghvan gachli (3 years ago)
i made connection using the ip address of my computer but the test shows an error " that network adaptor couln't  establish the connection.", then i did it with cmd prompt. then it says connected. my question is that m i really connected and where is my db like the local db i made earlier.
Ansari Rahil (4 years ago)
GREAT WORK MATE!!!!!!!! REALLY APPRECIATE THE EFFORT.. 
Nadeem Khan (4 years ago)
Manish bro your videos is very use full !!!!.. bro how can i ask Question from you?
Golam Kibria (4 years ago)
when i write select * from employees; it says ORA-00942: table or view does not exist 00942. 00000 -  "table or view does not exist" *Cause:     *Action: Error at Line: 1 Column: 15  what to do
pavan medam (11 months ago)
Thank You Very Much!!! Your Reply Helped Me!!!
Milkesa Haile (1 year ago)
you have to connect as .....conn hr/hr to a HR schema and select * from tab; to see if there is employees table in HR schema. This is the only way you can select from a table.
Golam Kibria (4 years ago)
my connection is sys as SYSDBA
Manish Sharma (4 years ago)
Hi +Fuad Hussain employees table belongs to HR schema so make sure you are connected with the same. 
Abadhesh Panda (4 years ago)
Thanks Manish
Manish Sharma (4 years ago)
Ma pleasure. Please Like and subscribe.. Thanks
jackimite (4 years ago)
You are a Good Manish.  man of great help. thanks
Manish Sharma (4 years ago)
Thanks, your appreciation means allot to me.:-) 
Jit Chakraborty (4 years ago)
Man, You are just awesome. Thanks for sharing ! Need to learn a hell lot of stuffs from your tutorials :)
Manish Sharma (4 years ago)
Thanks for your compliments I am always grateful to help my friends and peers. Please do share these videos with your friends. Thanks :-)
איציק א (4 years ago)
Great
איציק א (4 years ago)
Great

Would you like to comment?

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