venkat

• Dec 4th, 2011

From Oracle 9i it allows maximum 1000 columns in a table. In Oracle 8i, it only allows 256 columns in a table.

ambinu

 Profile Answers by ambinu Questions by ambinu

• Jun 14th, 2011

MySQL: Maximum number of columns in one table - 3398; size of a table row - 65534 (BLOB and TEXT not included). Oracle: Unlimited rows@table. Maximum number of columns in one table - 1000. Up to 32 columns in index key. PostgreSQL: Rows - unlimited, columns - 1600; size of a table row - 1.6TB.

Answer Question  Select Best Answer

suganya

• Nov 30th, 2011

No....because sequence is used for creating the integer sequence values only at the time of table creation...
but view is a subset of data for the base table.....so cant create the sequence for the view

shamkohli

 Profile Answers by shamkohli Questions by shamkohli

• Jun 17th, 2008

Sequence is used to generate numbers which can be stored in tables. View does not have data of its own and is generally used to query data. So sequence can not be created to a view.

Answer Question  Select Best Answer

What is a Synonym in Oracle?

jimmy.katiyar11

 Profile Answers by jimmy.katiyar11 Questions by jimmy.katiyar11

• Nov 29th, 2011

Hi, In oracle use SYNONYM as a temporary name of the object ( Table, view, index etc.)

Code
 

Payal Shah

• Sep 5th, 2011

Synonum is a alias of the table..

Answer Question  Select Best Answer

sateeshkonthala

 Profile Answers by sateeshkonthala Questions by sateeshkonthala

• Nov 21st, 2011

There are eight report triggers. Of these there are five global triggers called the Report Triggers. They are fired in the following order : * Before Parameter Form * After Parameter Form * Before R...

selvaspak

 Profile Answers by selvaspak Questions by selvaspak

• Dec 31st, 2010

Total 5 Types of Trigger1. Before Parameter Trigger2. After parameter Trigger3. Before Report Trigger4. Between Pages Trigger5. After Report Triggerthe Action are given below1. Before Parameter T...

Answer Question  Select Best Answer

How we identify instance name, free space, used space in database & datafile that makes up the system tablespace?

kishore

• Nov 15th, 2011

How to find the instance name?


>select instance_name from v$instance;

nattuduraip

 Profile Answers by nattuduraip Questions by nattuduraip

• Dec 29th, 2010

Instance Name Is DATABASE NAME Default

Answer Question  Select Best Answer

dynamic cursors are used in airline reservation system as changes made must be reflected in result set as most updated information is required for booking.
can anyone tell me the exact use of static cursor where most update changes are not required? in which application system it is useful?

vannalas

 Profile Answers by vannalas Questions by vannalas

• Nov 11th, 2011

Hi,

Can you give the examples of static and dynamic cursor ?
I will answer your question.

Answer Question  Select Best Answer

Explain the concept of compond triggers

neeraj06.in

 Profile Answers by neeraj06.in Questions by neeraj06.in

• Nov 10th, 2011

Compound Triggers: -> It combines all DML timing events into single trigger body. -> It also resolves mutating table error and enhance the code maintenance. -> The memory variables are persistent t...

Answer Question  Select Best Answer

murali

• Nov 8th, 2011

Snapshot is just like a image of the previous data for our reference and it's useful for analysing purpose in ADDM

jeyam

• Nov 2nd, 2011

Snapshot is just like a image of the previous data for our reference and it's useful for analysing purpose in ADDM

Answer Question  Select Best Answer

natu4u1979

 Profile Answers by natu4u1979 Questions by natu4u1979

• Oct 18th, 2011

EMC,Sqlplus,Datapump and Import/export

David Lozano Lucas

 Profile Answers by David Lozano Lucas Questions by David Lozano Lucas

• Oct 18th, 2011

EMC, sqlplus, datapump...

Answer Question  Select Best Answer

devarapalli rohini

 Profile Answers by devarapalli rohini Questions by devarapalli rohini

• Oct 14th, 2011

Select * from employees where hiredate in (1995,1996,1997,1998);

Prashanth

• Oct 10th, 2011

Exact query you required..... Try it out if you have any doubts.

Code
span style="color: #ff0000;">'yyyy''yyyy''yyyy');

Answer Question  Select Best Answer

I have some confusion about this question, Max(sysdate) - Min(sysdate) i think the answer is zero but give some detail description about this.....!

Kalpana Mooraka

 Profile Answers by Kalpana Mooraka Questions by Kalpana Mooraka

• Oct 5th, 2011

SQL> select max(sysdate)-min(sysdate) from dual;

MAX(SYSDATE)-MIN(SYSDATE)
-------------------------
0

SQL>

Ramesh hurakadli

• Oct 3rd, 2011

Result of Max(sysdate)-Min(sysdate),it means, it shows the date which is in between last date n first date of the month according to the system information.

Answer Question  Select Best Answer

Both TRUC and ROUND are single value functions.
TRUNC:
TRUNC function truncates that is in other words cuts off to the digits specified.
The general syntax of TRUNC function is:

TRUNC(number, precision);

For instance:
Suppose the value of salary in employee table for ename= ’Exforsys’ is 55.666
Then

Select...

s.siva karthik

• Sep 29th, 2011

SQL> select ceil(14.1) ,round(14.1),ceil(14.01),round(14.4),trunc(14.6) from dual; CEIL(14.1) ROUND(14.1) CEIL(14.01) ROUND(14.4) TRUNC(14.6) ---------- ----------- ----------- ...

avatar

• Sep 10th, 2011

Round function will increase the value by 1 if decimal value is greater than or equal to 5 else it will return same integer value without decimal ex. select round(8.34) from dual; will return 8; sel...

Answer Question  Select Best Answer

venugopal

• Sep 25th, 2011

mutating error is nothing but when we update a table at the same time when we retrieve the data from the same table then the mutating table error occurs.......to overcome we use autonomous transaction...

Ashritha

• Sep 12th, 2011

It occurs when ever we try to perform either select or dml operations on the same table in the trigger created for same table

Answer Question  Select Best Answer

MAHE

• Sep 16th, 2011

It is a Pfile

hkrishna

 Profile Answers by hkrishna Questions by hkrishna

• Jul 28th, 2008

Hi Friend,Here is simple defination initSID.ora will tell you SID is the database name where you are going to creating a new database.when you create database it'll take you as pfile and spfile is the system parameter file which you can convert if you required use in database.

Answer Question  Select Best Answer

What are the differences and similarities (if any) between SCN and and Log Sequence Number?

sagar verma

• Sep 7th, 2011

The SCN plays an important role to determine if the database is in a consistent state when the database is brought online. SMON checks the SCN in all datafile headers when the database is started. Eve...

Answer Question  Select Best Answer

do

• Aug 1st, 2011

Does it return only integer?

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Mar 4th, 2009

Never seen in oracle

Answer Question  Select Best Answer

How to import tables from MS-Access to Oracle?

michaelsmith035

• Jul 30th, 2011

If you successfully exported the data to text file , then you are very close! In the export option of Microsoft Access, you shall see an option like "Export to ODBC database". If you click that, you...

anand_study

 Profile Answers by anand_study Questions by anand_study

• Sep 25th, 2008

This might help someone if need to get table into Oracle from MS Access table.Option-1 - Use MS Access (2003) Export 1. Oracle Client and Oracle ODBC driver should be installed on your PC.2. In O...

Answer Question  Select Best Answer

HARI SHANKAR SHARMA

• Jul 18th, 2011

Select aa_seq.currval from dual

Regards,
Hari Shankar Sharma

Hari Kiran P

• May 14th, 2007

You can get the current value of the Sequence by querying DBA_SEQUENCESColumn name is Last_numberThanksHari Kiran P.

Answer Question  Select Best Answer

Waseem Mehmood

 Profile Answers by Waseem Mehmood Questions by Waseem Mehmood

• Jun 2nd, 2011

Select ename, count(ename) Count From emp Group by ename Having count(ename) > 1 ;

Showstopper

 Profile Answers by Showstopper Questions by Showstopper

• Jun 21st, 2010

We can count the duplicate entry in particular table by using the following queryselect count(*)from a bwhere exists (select rowid           &nbs...

Answer Question  Select Best Answer

No. Only the DDL(Data Definition Language )statements like create,alter,drop,truncate are auto commit.But the DML statements are should be saved by giving the commit statement after execute the query

Hema

• Nov 1st, 2007

DDL is Data Definition Language. DDL commands work on the table directly or on the table structure. By default it has auto commit.DML is Data Manipulation language that affects the data present in the table. Any addition or modification of data has to be saved by the Commit command.

Arindam Ghsoh

• Aug 20th, 2007

DDL and DML are different.DDL is data definition language and it has autocommitBut in DML there is no auto commit.

Answer Question  Select Best Answer