Employee table has : Emp.Name, Emp.ID, Dep.ID & Location ID
Department Table has: Dep.ID, Dep. Name
Location table has: Location ID & Location Pincode

Need to find the list of employees who is from Finance department having 1200 pincode

sanjiwani

• Sep 8th, 2020

SELECT Emp.name, Dep.Name, Location Pincode FROM Employee JOIN Department on Dep.ID.Employee = Dep.ID.Department JOIN Location on employee.Location ID= Location.Location ID where Dep....

Answer Question  Select Best Answer

Using ORACLE PRECOMPILERS, SQL statements and PL/SQL blocks can be contained inside 3GL programs written in C,C++,COBOL,PASCAL, FORTRAN,PL/1 AND ADA.The Precompilers are known as Pro*C,Pro*Cobol,...This form of PL/SQL is known as embedded pl/sql,the language in which pl/sql is embedded is known as the host language. The prcompiler translates the embedded SQL and pl/sql ststements into calls to the...

RamaKrishna.Yerra,TCS,Hyd,9989018508

• Aug 21st, 2006

Hi !! PRAGMA is one of the Precompiers of Oracle ..Wht it does is similar to Pre compier Directives in C Lang.. Thanks&RegdsRamaKrishna.Yerra,TCS,Hyd,9989018508

Answer Question  Select Best Answer

Hash joing is implemented in CBO and comparatively faster.  Merge joing is comparatively slow because both the row sources are to be sorted before merging.

Sampath

• Oct 22nd, 2005

Hash join occupies lots of memory as it creates hashes

Answer Question  Select Best Answer

Vijay

• Jul 9th, 2005

Yes it possible to insert/update/delete data for CLOB, BLOB, NCLOB columns. Now how to do it.  1. Suppose if you are using JAVA applications to modify the database columns, then you have t...

Answer Question  Select Best Answer

Ashish Dhagat

• Nov 15th, 2005

SRW is a package name, used while creating a report using rdf. it helps to perform action at runtime. for example changing the colour of the col. according to value fetched by the report, Calling...

Answer Question  Select Best Answer

rajamuna

 Profile Answers by rajamuna Questions by rajamuna

• Apr 4th, 2006

SELECT *,ROWNUM r FROM (SELECT COUNT(url_name) hit,url_name FROM URL_DETAILS_TBL WHERE url_name IN (SELECT DISTINCT url_name FROM URL_DETAILS_TBL WHERE TO_DATE(ENTRY_DATE,'MM/DD/YYYY') = '12/13/2005')...

Answer Question  Select Best Answer

manu

• May 18th, 2006

check this link.....http://asktom.oracle.com/pls/ask/f?p=4950:8:16663421538065257584::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:766825833740

Answer Question  Select Best Answer

Debasis

• Aug 12th, 2006

Merge can be called 'UPSERT'. Using merge we can insert records if it was not present in the table earlier , if present It will update the record without appending.....

Answer Question  Select Best Answer

Maria Antony Samy

• Oct 14th, 2006

Very Simple question! But should be explained a lot.Databse data is stored in data_file's of the databse. For every table's data some space from the data_files would be allocated. This space is known ...

Answer Question  Select Best Answer

CD

• Nov 5th, 2007

You may use a functions called 'characters'.Syntax:characters ()

Answer Question  Select Best Answer

sangeeta

• Oct 18th, 2006

The start with .. connect by clause can be used to select data that has a hierarchical relationship (usually some sort of parent->child (boss->employee or thing->parts). It is also being used when an sql execution plan is explained.

Answer Question  Select Best Answer

Musharraf Dabre

• Sep 19th, 2006

 Hi ,    any kind of oracle error ,go to this link::             http://ora-00904.ora-code.com/all.html

Answer Question  Select Best Answer

Write a SQL query to select 10 random records from a table?

Rajasekhar

• Jul 22nd, 2011

SELECT Top 10 * from Emp order by NEWID()

Answer Question  Select Best Answer

How to display data in the table between mth column to nth column in a table in Oracle?

AnithaLetchumi

 Profile Answers by AnithaLetchumi Questions by AnithaLetchumi

• Jul 27th, 2011

Hi, I don't think there exists predefined pseudo column for column number in oracle. I have done a procedure, which creates a view for displaying data from Mth to Nth column in a table. Hope it helps....

Answer Question  Select Best Answer