Oracle Developer

Oracle Developer

Trending Questions and Lessons

Follow 13,584 Followers

Ask a Question

Feed

All

All

Lessons

Discussion

Lesson Posted on 29/12/2016 IT Courses/Oracle Training/Oracle Developer IT Courses/Oracle Training/Oracle PL/SQL IT Courses/Oracle Training/Oracle Developer/Oracle Developer OCA +1 IT Courses/Oracle Training less

SQL - Structured Query Language - DQL Commands - SELECT

Kasyap

10+ years experience on Oracle Applications / E-Business Suite Implementation Projects 6+ years experience...

Structured Query Language allows to store , manipulate, control and retrieve the information from Relational Database Management Systems. Following are some RDBMS products. Oracle Databse, Microsoft SQL Server, MySQL, PostgreSQL etc. SQL commands can be categorized under DDL - Data Definition Language... read more

Structured Query Language allows to store , manipulate, control and retrieve the information from Relational Database Management Systems. Following are some RDBMS products. Oracle Databse, Microsoft SQL Server, MySQL, PostgreSQL etc.

SQL commands can be categorized under

  1. DDL - Data Definition Language      (CREATE, DROP, ALTER)
  2. DML- Data Manipulation Language   (INSERT, DELETE, UPDATE)
  3. DCL- Data Control Language            (GRANT, REVOKE)
  4. DQL- Data Query Language              (SELECT)

In this session we will focus on DQL SELECT Statement

SELECT T2. DepartmentName, T1. StudentName, SUM(MARKS)

FROM Students T1, Departments T2, MARKS T3

WHERE T1.DEPTCODE=T2.DEPTCODE  

AND T1.STUDENTID=T3.STUDENTID

AND T3.EXAMNAME='SEMESTER 1'

GROUP BY  T2. DepartmentName,T1. StudentName

HAVING SUM(MARKS)> 900

ORDER BY T1.StudentName

 This is old fashioned way of writing clean SQL statements, New way of writing statements to achieve the same result will be discussed in the actual course.

SELECT Clause: Here one has to list the columns in a table(s) to display as a result of the query. columns can be from the list of tables mentioned in FROM clause. A from clause can have a sub query instead of a physical table or view. we will cover this in detail, don't get lost. We can also use Oracle functions or custom functions to return single value return functions.

FROM Clause: This is to include the tables and optionally subqueries (logical table with in memory)

WHERE Clauase: This is to filter the results of the entire select statement. you can exclude or include certain criteria. Apart from this you also join other tables with appropriate unique column to match appropriate record/row with appropriate record/ row in other table.

GROUP BY Clause: This is to group set of columns to use aggregate functions. example Average sales by city or state etc.

HAVING Clause: This is to filter the group results, unlike where cluase it is applied at the group result. example Average Sales > 10000.

ORDER BY Clause: This is to sort the results using specific selected list of the columns in SELECT clause.

read less
Comments
Dislike Bookmark

Answered on 02/12/2016 IT Courses/Oracle Training/Oracle Developer/Oracle Developer OCA

What is difference between replace and translate in oracle?

Kasyap

Oracle Technical Consultant

Replace can change Single character with Multiples characters, where as Translate can be used to change Single character with another Single character.
Answers 1 Comments
Dislike Bookmark

Lesson Posted on 01/09/2016 IT Courses/Oracle Training/Oracle PL/SQL IT Courses/Oracle Training/Oracle Developer IT Courses/Oracle Training/Oracle Developer/Oracle Developer OCA +2 IT Courses/Oracle Training/Oracle Developer/Oracle Developer OCP IT Courses/PL/SQL less

Write a query

Praneeth Vasantha

I have 8 years of real time experience in Oracle SQL and PL/SQL. Will provide good notes and interview questions.

To find out how many 'a' characters are present in the string 'database'?
Comments
Dislike Bookmark

Looking for Oracle Developer

Find best Oracle Developer in your locality on UrbanPro.

FIND NOW

Answered on 25/01/2016 IT Courses/Oracle Training/Oracle Developer/Oracle Developer OCA

Deepak

Oracle Trainer

dumps and practice
Answers 3 Comments
Dislike Bookmark

Answered on 05/02/2016 IT Courses/Oracle Training/Oracle Developer/Oracle Developer OCA

Deepak

Oracle Trainer

you can get all information on oracle site.
Answers 3 Comments
Dislike Bookmark

Answered on 04/12/2015 IT Courses/Oracle Training/Oracle Developer/Oracle Developer OCA

Aashish Kumar

Informatica/Oracle Trainer

1-2 months
Answers 3 Comments
Dislike Bookmark

Looking for Oracle Developer

Find best Oracle Developer in your locality on UrbanPro.

FIND NOW

Answered on 15/02/2016 IT Courses/Oracle Training/Oracle Developer/Oracle Developer OCP

Raghavendra Rao

Senior Oracle Developer

You can prepare the Oracle Student guides to crack the OCP exam. Questions will be asked from it only. Each chapter of the student guide contains separate practice session. Practice them well and prepare the Braindumps, actual tests lots are available in website. Search for them with particular exam... read more
You can prepare the Oracle Student guides to crack the OCP exam. Questions will be asked from it only. Each chapter of the student guide contains separate practice session. Practice them well and prepare the Braindumps, actual tests lots are available in website. Search for them with particular exam code. Practicing dumps and preparing through Oracle student guide will make you to crack the OCP exam. read less
Answers 3 Comments
Dislike Bookmark

Answered on 19/01/2016 IT Courses/Oracle Training/Oracle Developer/Oracle Developer OCP

Deepak

Oracle Trainer

Oracle Certified Professional (OCP) OCP candidates have proven skills for managing a large scale database or developing robust applications that are deployed enterprise-wide. Format: All exams are closed book exams. No written materials or notebook computers will be allowed in the testing area. All... read more
Oracle Certified Professional (OCP) OCP candidates have proven skills for managing a large scale database or developing robust applications that are deployed enterprise-wide. Format: All exams are closed book exams. No written materials or notebook computers will be allowed in the testing area. All questions are either multiple choice, fill in the missing word or match these against those. read less
Answers 3 Comments
Dislike Bookmark

Answered on 06/12/2015 IT Courses/Oracle Training/Oracle Developer/Oracle Developer OCM

I'm already an experienced DBA so do I need to study for the OCM certification?

Neeraj A

Its not necessary. Hands on experience is very important.
Answers 2 Comments
Dislike Bookmark

Looking for Oracle Developer

Find best Oracle Developer in your locality on UrbanPro.

FIND NOW

Answered on 06/12/2015 IT Courses/Oracle Training/Oracle Developer/Oracle Developer OCM

Which version of the database should I certify against?

Neeraj A

It depends on which database you want to learn and master. Based on that the version will apply.
Answers 2 Comments
Dislike Bookmark

About UrbanPro

UrbanPro.com helps you to connect with the best Oracle Developer in India. Post Your Requirement today and get connected.

Overview

Questions 15

Total Shares  

Top Contributors

Connect with Expert Tutors & Institutes for Oracle Developer

x

Ask a Question

Please enter your Question

Please select a Tag

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more