FLOOR

Tushar

• May 9th, 2007

TRUNC will give same output as FLOOR

sahu

 Profile Answers by sahu Questions by sahu

• Jan 27th, 2006

Ans:Yes ,we can find the largest integer less than or equal to a specific valueFLOOR

Answer Question  Select Best Answer

naveen_vangapalli1

• May 26th, 2007

The select statement goes to oracle server and the server responds

shashi

• Oct 25th, 2005

First it will look into the System Global Area (SGA) weather the query is been exectued earlier.If it exist, it would retrive the same output present in memory.If not the query we typed...

Answer Question  Select Best Answer

rangunagaraj

 Profile Answers by rangunagaraj Questions by rangunagaraj

• Jul 6th, 2007

NORMALIZATION is a body of rules addressing analysis and conversion of data structures into relations that exhibit more desirable properties of internal consistency,minimal redundancy and maximum stab...

Ranjeev

• Apr 26th, 2006

Normalisation can be defined as a process to minimize, infact eliminate redundancy of data within the database. It first requires that redundancy is detected through the proper use of FD's( Functional...

Answer Question  Select Best Answer

intelmental4

 Profile Answers by intelmental4 Questions by intelmental4

• Jul 23rd, 2007

BLOB is Binary Large ObjectWhen you declare any variable as image, text, ntext ... they would be BLOB data typesText = 2^31-1text = 2^30-1ntext = 2^31-1-Each text, ntext, image colum can in a table ca...

Answer Question  Select Best Answer

B

sivaganeshb

• Aug 14th, 2007

Here, you are de-referring an un-intialized pointer(segmentation fault). A file called?"core" will create and it contains the "images of that program"

sabeena

• Apr 20th, 2007

I want to know what Core Dump means.

Answer Question  Select Best Answer

A

swetha

• Aug 16th, 2007

The answer is A. Extern

robin singh

• Jun 11th, 2006

A: extern becoz v can access it any where

Answer Question  Select Best Answer

meenakvasulochanan

 Profile Answers by meenakvasulochanan Questions by meenakvasulochanan

• Aug 17th, 2007

The column "duration" in all_tables will tell us whether the temporary table is defined with "on commit preserve row" or "on commit delete rows"The values :SYS$TRANSACTIO...

Answer Question  Select Best Answer

Bharath

• Sep 6th, 2007

Actually the query returns an error like "expected NUMBER got CHAR"

SQL Devotee

• Jan 15th, 2007

Use coalesce.Eg:select coalesce(NULL,NULL,NULL,NULL,1,NULL,NULL,'a')This will give you 1 as the result.

Answer Question  Select Best Answer

SELECT TRUNC(1234.5678,-2) FROM DUAL;1200

gemini burj

 Profile Answers by gemini burj Questions by gemini burj

• Oct 23rd, 2007

if the -ive parameter is passed under TRUNC function truncation will be used to below decimal place i.e-1 means Trunc to 10th (1234 becomes 1230)-2 means trunc to 100th (1234 becomes 1200)-3 means tru...

thumati_nagaraju@yahoo.co.in

• Nov 17th, 2006

This is -ve no given so it remove the digits before decimal point ... and replace it by zero if want to check it just try with -1 or -2 or -3 ok seeu byeee

Answer Question  Select Best Answer

The main difference between the IN and EXISTS predicate in subquery is the way in which the query gets executed.IN -- The inner query is executed first and the list of values obtained as its result is used by the outer query.The inner query is executed for only once.EXISTS -- The first row from the outer query is selected ,then the inner query is executed and , the outer query output uses this result...

gemini burj

 Profile Answers by gemini burj Questions by gemini burj

• Oct 23rd, 2007

In case of a big number of list from the select list IN operator should not be used but the exists shall be used with the proper condition this will definetely make the query optimal query.

Mahesh

• Jul 24th, 2007

In operaor scan all the values inside the IN block where as EXIST quit after 1st occurrence.

Answer Question  Select Best Answer

prabakaran

• Sep 18th, 2005

To retrieve data with SQL one row at a time you need to use cursor processing.Not all relational databases support this, but many do.Here I show this in Oracle with PL/SQL, which is Procedural Languag...

Prabakaran

• Sep 17th, 2005

To retrieve data with SQL one row at a time you need to use cursor processing. Not all relational databases support this, but many do.Here I show this in Oracle with PL/SQL, which is Procedural Langua...

Answer Question  Select Best Answer

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

gemini burj

 Profile Answers by gemini burj Questions by gemini burj

• Nov 18th, 2007

Pipelined functions are useful if there is a need for a data source other than a table in a select statementFor more details, following link is available.http://www.adp-gmbh.ch/ora/plsql/pipeline.html

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

anugrah17

 Profile Answers by anugrah17 Questions by anugrah17

• Jan 9th, 2008

above solution is also correct, but a join is always better :)--------------------------------------------------------------------------SELECT     Country.Name AS Country, Senator....

rajakumar_na

 Profile Answers by rajakumar_na Questions by rajakumar_na

• Nov 22nd, 2007

Try this,SELECT  c.name county,  s.name senatorFROM county c, senator sWHERE s.cid = c.cidORDERY BY county; Result;COUNTY          &nbs...

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

Sudhir Sorout

 Profile Answers by Sudhir Sorout Questions by Sudhir Sorout

• Feb 4th, 2008

We can update a view using instead of trigger..... see example on url..http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sqls.doc/sqls365.htm

gemini burj

 Profile Answers by gemini burj Questions by gemini burj

• Nov 18th, 2007

Complex view means that no DML statement could be executed for this view, to test it you may descrive or select the columns from the views.

Answer Question  Select Best Answer

How to calculate the time variation between two different time sessions?

Sudhir Sorout

 Profile Answers by Sudhir Sorout Questions by Sudhir Sorout

• Feb 4th, 2008

Select t1- t2 from dualwhere t1 and t2 are dates then this query will return no of day not hrs.Sudhir Sorout

gbansal4

 Profile Answers by gbansal4 Questions by gbansal4

• Dec 15th, 2007

Select t1 - t2 from dualwhere t1 & t2 are dates.  It will give output in hours.

Answer Question  Select Best Answer

My script contains sql plus set commands. how to execute that script in a pl/sql block i.e. either anonymous ,procedure or function or trigger

hemant.agarwal03

 Profile Answers by hemant.agarwal03 Questions by hemant.agarwal03

• Mar 17th, 2008

First you need to save your file in .sql format, suppose you create set.sql and saved it on c: drive then follow below command.SQL> @C:SET.SQL and press ENTERyour script has been executed. :-)

Susil Kumar

 Profile Answers by Susil Kumar Questions by Susil Kumar

• Feb 20th, 2008

Let me reframe the question as follows:          How to execute pl/sql block in sql*plus environment?If I am on the right path, I'll be able to give th...

Answer Question  Select Best Answer

venkat82.k

 Profile Answers by venkat82.k Questions by venkat82.k

• Mar 19th, 2008

Hi guys  partitionings nothing but a huge table is divided into some meaningfull  parts to do manipulations ,for easy maintainwe divide partitions while creating tables.mainly 3 types of par...

Answer Question  Select Best Answer