gemini burj

 Profile Answers by gemini burj Questions by gemini burj

• Nov 18th, 2007

 the translate function replaces a sequence of characters in a string with another set of characters. However, it replaces a single character at a time. For example, it will replace the 1st chara...

Answer Question  Select Best Answer

what is the difference between the null in C and one in SQL?

Sudhir Sorout

 Profile Answers by Sudhir Sorout Questions by Sudhir Sorout

• Feb 4th, 2008

Null is a special marker used to indicate that a data value is unknown in the sql. But in case of ‘C’ A "null statement" is a statement containing only a semicolon; it can appear...

Answer Question  Select Best Answer

This is one of the questions I have on my interview exam. It is a take home exam and I have not learned SQL but the employers want to know my know my skills to find answers using any means possible. Question: Review the following SQL code and give a brief explanation SELECT 'AD', B.AccountID,'Change' FROM (SELECT DISTINCT A.sAMAccountName As AccountID from (select AG.sAMAccountName...

ajith007

 Profile Answers by ajith007 Questions by ajith007

• Dec 6th, 2007

Use of distinct, not in keywords make this code altogether complicated. But what I discern from this code 'catch' lies in FULL OUTER JOIN since it retreives all the data including your null values.The union here returns the cross product of query mentioned that includes your null values.

Answer Question  Select Best Answer

What is water mark apporach in SQL?

godsrikanth

 Profile Answers by godsrikanth Questions by godsrikanth

• Dec 3rd, 2009

A High Water Mark is when a database (or database table) has reached its maximum capacity, for example, the EMPLOYEE table including current and past employees, could have 1000 rows. That would be its...

Answer Question  Select Best Answer

What is pivotal query?

mv_sivavardhan

 Profile Answers by mv_sivavardhan Questions by mv_sivavardhan

• Aug 6th, 2008

Pivot is a keyword using which the values in vertical rows can be displayed as horizontal columnsEx: If there is a table with all dates of month from 1st to 30th and values against each date...

Answer Question  Select Best Answer

what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?

Pintu_unix

 Profile Answers by Pintu_unix Questions by Pintu_unix

• Jul 20th, 2008

SHARE UPDATE EXCLUSIVE  This mode protects a table against concurrent schema changes and VACUUM runs. Acquired by VACUUM (without FULL), ANALYZE, and CREATE INDEX CONCURRENTLYEXCLUSIVE This ...

Answer Question  Select Best Answer

What is the meaning of I and G in Oracle 9i & 10g versions

poonam192005

 Profile Answers by poonam192005 Questions by poonam192005

• Nov 2nd, 2010

Meaning of i in ORACLE 9i is INTERNET and meaning of g in ORACLE 10g is GRID COMPUTING

Answer Question  Select Best Answer

How can I insert an image into oracle database?

Mythili karanam

• Aug 9th, 2011

1)Create one directory in OS(Operating System) Place all the images in this directory 2) create one directory in data base with the link of this os directory eg:E:ordb Create table images(img_na...

Answer Question  Select Best Answer

Which type of binding does PL/SQL use?

kanhaiya

• Oct 9th, 2014

Early binding

Answer Question  Select Best Answer

Dear All,Suppose i have Excel table and within that i have some records. Please tell me the SQL query so that i can create table and populate the Excel sheet data

vannalas

 Profile Answers by vannalas Questions by vannalas

• Feb 17th, 2011

Elaborate the question.?

Answer Question  Select Best Answer

dinesh.smhdr

 Profile Answers by dinesh.smhdr Questions by dinesh.smhdr

• Sep 13th, 2011

"oracle8 declare cursor c_emp (cin_No NUMBER) is select count(*) from employee where id = cin_No; v_deptNo employee.id%type:=10; v_countEmp NUMBER; begi...

Answer Question  Select Best Answer

Supplier Name
Supplier Site
Supplier Street
Supplier Contact Person
Supplier City
Supplier State
Supplier Phone number

Business requirement is : One Supplier can have multiple ( n number of
Sites ), One Supplier Site can have Multiple Contacts Persons ( n
number of Contact persons ), One Supplier Contact Person can have
multiple phone...

ashadevi21

 Profile Answers by ashadevi21 Questions by ashadevi21

• Oct 5th, 2011

Supplier Table Columns : Supplier id , supplier name (Supplier ID, supplier name as Primary Key) Supplier Site Details Columns : Supplier name , site, street, city, state (Supplier name as foreign Ke...

Answer Question  Select Best Answer

DEPARTMENT_ID ,EMP_COUNT, DEPT_PERCENTAGE

VIBHAV MISHRA

• Jun 30th, 2014

Update

Answer Question  Select Best Answer

what is the size of parameter that we passed in sql query

Kumar

• Sep 27th, 2011

32765 bytes(32KB)

Answer Question  Select Best Answer

What is the difference between inner join and outer join?

Mark Haynes

 Profile Answers by Mark Haynes Questions by Mark Haynes

• Sep 30th, 2011

First to define what Inner Join and Outer Join mean. Inner Join: A join between two tables were only those records in both tables that meet the conditions of the join expression are returned. In most...

Answer Question  Select Best Answer

indira

• Feb 1st, 2012

Sub query: A sub query is executed once for the parent statement. Correlated Sub query: Correlated sub query runs once for each row selected by the outer query. It contains a reference to a value fr...

Answer Question  Select Best Answer

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Feb 18th, 2012

Force view creates the view even if the underlying tables / referenced objects are not present. Force View are used while executing a script that has create tables and views statements or while creating a view for remote table.

Answer Question  Select Best Answer

Hi,

I have 3 files each having 2 cols
e.g
File1
empid deptid
1 100
2 200
3 200
4 100
5 300

File2
empid salary
1 10
2 20
3 30
4 40

Mark Haynes

 Profile Answers by Mark Haynes Questions by Mark Haynes

• Mar 2nd, 2012

I believe what you are looking for is a query like this:

select f3.deptname dept_name, sum(isnull(f2.salary,0)) amt_spent_each_dept
from file3 f3 left join file1 f1 on (f3.deptid = f1.deptid)
left join file2 f2 on (f1.empid = f2.empid)
group by f3.deptname
order by f3.deptname

Answer Question  Select Best Answer

V.E.Rajani

• Oct 3rd, 2012

Only SELECT statement can be used in Functions. INSERT,UPDATE,DELETE are used.

Answer Question  Select Best Answer

In a table the persons name is in lower case "abc" and is there any SQL query to obtain that persons name as "ABC" as an output?

Muzeeb

• Jan 6th, 2013

Yes, using SQL UPPER function.

Code
 

Answer Question  Select Best Answer