Q&A Categories

SQL

You have EMP and dept table .how do you get the entire department and corresponding employee details

You have EMP and dept table .how do you get the entire department and corresponding employee details and the department which are not alloted it?what is referential integrity constraint?wat is triggers,stored...

Answers No Answers In: SQL By: deva [1 Grey Star Level] Sep 8, 2010

Write query for the following questions1. sql query for selecting alternate rows in a table2. sql query

Write query for the following questions1. sql query for selecting alternate rows in a table2. sql query for deleting alternate rows in a table '

Answers No Answers In: SQL By: sam [ Grey Star Level] Sep 7, 2010

Write a query to display alternate records from the employee table?

Write a query to display alternate records from the employee table? '

Answers No Answers In: SQL By: neha [ Grey Star Level] Sep 7, 2010

Write a query to display employee records having same salary?

Write a query to display employee records having same salary? '

Answers No Answers In: SQL By: ramesh [ Grey Star Level] Sep 7, 2010

Write a query to find the list of employees whos age is greater than 30 or so given a date of birth

Write a query to find the list of employees whos age is greater than 30 or so given a date of birth column '

Answers No Answers In: SQL By: samir [ Grey Star Level] Sep 7, 2010

Write a query to update third column such that

Write a query to update third column such that There is a table having the following columns :-student id marks1 marks2 maxmarks1 10 20 202 25 30 ...

Answers No Answers In: SQL By: nitin [ Grey Star Level] Sep 7, 2010

Why the Stored functions cannot called from DML statements?

Why the Stored functions cannot called from DML statements? '

Answers No Answers In: SQL By: @mahesh@ [1 Grey Star Level] Sep 7, 2010

Why statistics are different in oracle9i and oracle 10g?

Why statistics are different in oracle9i and oracle 10g? Not sure about this, better we could try again with right samplesize in both the versions. Use DBMS_STATS.AUTO_SAMPLE_SIZE.ExecuteDBMS_STATS.GATHER_SCHEMA_STATS('SCOTT',estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE,GRANULARITY=>'ALL',CASCADE=>TRUE);'

Answers No Answers In: SQL By: sunil [ Grey Star Level] Sep 7, 2010

Why is insert faster than delete?Which indexing technique works best for Oracle based database?

Why is insert faster than delete?Which indexing technique works best for Oracle based database? '

Answers No Answers In: SQL By: deva [1 Grey Star Level] Sep 6, 2010

Why order by clause maintains column number values instead of column names ?

Why order by clause maintains column number values instead of column names ? '

Answers No Answers In: SQL By: @mahesh@ [1 Grey Star Level] Sep 6, 2010

Didn't find what you were looking for?

Add your Question to the site.

You must be Logged In to Add a Question.

Not a member yet? Sign Up Now »

Star Points Scale

Earn points for Asking and Answering Questions!

Grey Sta Levelr [1 - 25 Grey Star Level]
Green Star Level [26 - 50 Green Star Level]
Blue Star Level [51 - 500 Blue Star Level]
Orange Star Level [501 - 5000 Orange Star Level]
Red Star Level [5001 - 25000 Red Star Level]
Black Star Level [25001+ Black Star Level]