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
You can download the Script which is used in this SQL tutorial from this link
Thanks for linking, commenting, sharing and watching more of our videos
This is Manish from The Code makers
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.
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.
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....
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.
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"
Error at Line: 1 Column: 25
what is this meaning for this error.
Kindly help me out.
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.
Looking for someone like-minded? Chances are you’ve already got one thing in common.
15,000 New members.
Soulmates sees over 15,000 new faces every month.
#1 Customer service.
Feel safe and secure, with help from our award-winning customer service team.
Recently joined Soulmates.
Meet some of our latest members.
Online Dating Success Stories.
Intrepid explorers who’ve found the person of their dreams.
Kristian & Zoe.
"We met through Soulmates four years ago. Although were both based in London, the chances of us meeting by other means were slim. We just got married! Zoe is the most wonderful woman Ive ever met, and I know we are going to have an extremely happy life together."
Laura & Phil.
"Phil and I got married just over a year after we met on my first ever internet date through Guardian Soulmates. Weve been recommending the site to friends ever since. Thank you!" (Photography credit to Michael OSullivan)
Robin & Alec.
"I just wanted to let you know that you have another success story! My boyfriend, who I met via your site about two years ago, just proposed and we are getting married next year. THANK YOU!"
Alex & Rosie.
"Rosie and I met through Soulmates and were married in October, just 17 months later. Were wonderfully happy together!"
How does it work?
Find your Soulmate in three easy steps.
Register your free account today.