SUB Queries: 1. List the employees working in research department 2. List employees who are located in New York and Chicago 3. Display the department name in which ANALYSTS are working 4. Display employees who are reporting to JONES 5. Display all the employees who are reporting to Jones Manager 6. Display all the managers in SALES and ACCOUNTING department 7. Display all the employee names in Research and Sales Department who are having at least 1 person reporting to them 8. Display all employees who do not have any reportees 9. List employees who are having at least 2 reporting 10. List the department names which are having more than 5 employees 11. List department name having at-least 3 salesman 12. List employees from research and accounting having at-least 2 reporting 13. Display second max salary 14. Display 4th max salary 15. Display 5th max salary -- Answer for nth Max Salary Co-Related Subqueries: 16. Write a query to get 4th max salary from EMP table 17. Wri
Mithun Ashok's Experience, Summary, Trainings and Knowledge Sharing on Oracle Database, Oracle Applications, Fusion Middleware, SQL, PL/SQL and Database Testing
Comments
Now SQL online reference is not worrking ....what is the reason?
Hi, Chandrasehar Here, Now SQL online reference is not worrking ....what is the reason?
Please check the link again, it works fine.
Regards,
Mithun
PL/SQL Procedure:
1. Doesn't need to return values but can return value.
2.Stored as a pseudo-code in database i.e. compiled form.
3.Can affect the state of database using commit etc.
4.Cannnot be invoked from SQL statements e.g. SELECT.
5.Procedures are mainly used to process the tasks.
Triggers:
Triggers provide a way of executing PL/SQL code on the occurrence of specific database events.
Oracle enables triggers to be invoked by many events other than table insert, update and delete operations.
Mithun
No, it is not possible to download the slides.
Mithun
Whatever applications either it is MS word / Notepad / C, C++, Java, Perl, .Net / whatever it is... they need to have some database to function right? These don't come under any type of DBMS coz they don't belong to any of the structure (Tree, N/W, Table, Object) right? But still y dont we call them as a DBMS? (even when they don't belong to any type of DBMS). Can u explain in detail?
You need to understand the definition first, Database is a place where data is stored in an organized format.
DBMS is a program or a software which will give you access to any database.
Word, Excel are File based programs which stores data in files and do not require any language to manipulate the data.
C/C++/.Net etc are purely programing languages used to create programs/softwares/Applications etc. Infact some of the DBMS softwares are built using C/C++. These languages do not require DBMS rather they can only be executed using a compiler.
Hope this is clear.
Mithun
Pls explain the definition of identifying relationship and Derived attributes with an example? In given slides example is bit difficult to understand for me. So pls give an simple example……..
Any relationship between a Strong entity and a Week entity is classified as Identifying relationship.
Derived attributes are logical attributes of an entity which can be derived by some means.
Regards,
Mithun
Thanks a lot for such wonderful comments.
Mithun
Mithun
I am also sending out a mail to your yahoo id of the screen shot what i am seeing....
There was some problem with the presentations and I have fixed it now.
Pls check.
Mithun
How its working sir
'm ur student pleas tell me sir
You should login as user SCOTT and use the default password tiger. This will work if you have installed enterprise edition of 10g or 11g.
Regards,
Mithun
Acer is working fine and it has not given me any problem for last 1 year.
If you are planning to install database on your laptop then I would suggest you go for a laptop with DUAL Core CPU and minimum 2GB or 4GB RAM.
Regards,
Mithun
mgr=NULL will not work, you should use mgr is NULL. In oracle NULL <> NULL.
Use the following statement,
select * from emp where mgr is null;
Regards,
Mithun
please go bit slow in the class..
thank you.....
pinji here...
sir,i have a doubt,not related to SQL.Actualy,i have been done engineering from chemical branch 2011 batch,so wlil i get opportunity in software field if i will learn this software testing coach nicely.
thnking you.
You will if you work hard.
Regards,
Mithun
your teaching is awesome
Thank you,
Mithun
may i know the difference between data model and schema?
please go bit slow in the class..
couldnot understand tuesday(6.3.2012) class.because i am basically b.com stundent
am a new student in Q-spiders morning batch...
m following u very well ur teaching is very good
u hv mistaken me as Rajnikant as i sit in d last once wen i came late
i was able to download the oracle 10 g client, got the SQL tool too...couldn't log in though!. it wasn't authenticating the "scott "and "tiger "as the user name and password.I'm not sure if that's the enterprise edition.
How do I download the PPTs on your blog?
I dont see an option like that here.
Kindly help.
Thanks,
Swetha
sir first of all i want to thank to u for---that u teaches Sql very well.Being a ECE student I am able to understand all 3 to 4 classes u have taken.
My question to is that............u told server is that machine on which server program is installed(e.g in the context of DB u told DBMS server programs) but in genral there are a lot of softares avialble on each PC which can modify or access date(for example....word can modify dat,media softwares can be used to editing video data.) so is that machine also severs.
or is there any restrictions on softwares to be called a server programs......which programs only called server programs?
thanks
regards
rahul kumar(evening 40'clock batch)