srikanth

• Nov 14th, 2006

You can try merge statement option and give commit for a set range from 1000

Answer Question  Select Best Answer

jvilango

 Profile Answers by jvilango Questions by jvilango

• Nov 9th, 2006

The purpose of Product_user_profile table of SYSTEM is to control users from executing SQL commands.  For example, if you dont want one of your users to execute DELETE fommand, this can be implemented in this table.

bhanushiva

 Profile Answers by bhanushiva Questions by bhanushiva

• Jan 20th, 2006

The PRODUCT_USER_PROFILE (PUP) table provides product-level security that supplements the user-level security provided by the SQL GRANT and REVOKE commands and user roles.To create the PUP tableLog in...

Answer Question  Select Best Answer

Neeraj

• Nov 7th, 2006

You can write the query in the following way.select max(sal)-min(sal) difference from emp;

Manikandan

• Sep 22nd, 2006

Select max(sal)-min(sal) as Difference from employee;

Answer Question  Select Best Answer

Peter Wegner

• Nov 5th, 2006

You can use the oraenv script to ensure that user accounts are updated and to switch between databases.

Answer Question  Select Best Answer

sudheer

• Oct 17th, 2006

Hi,  We can't use relational operation in decode.where as we use in case stament.

Answer Question  Select Best Answer

dev

• Oct 11th, 2006

Hi,for every table it is giving the same answer like:SQL> select bytes from user_segments where segment_name='DEPT';     BYTES----------     65536why? I did compress on one table. eventhough it's giving same answer.Thanks in advance.

S.Madhu

• Mar 29th, 2006

 I have created a table in oracle 9i database. How can i know the storage prticulars of  a table  created in oracle database ?please give me the answer to my e-mail id.thank u

Answer Question  Select Best Answer

developer

• Oct 11th, 2006

Hi Mukund,Developers and DBAs use these tools to get the best performance out of their applications. The execution plan is made available to you in the form of rows inserted into a special table calle...

Answer Question  Select Best Answer

raja

• Oct 10th, 2006

    SQL: 1.it is a language for communicating with the oracle server to access data 2.it is based on ANSI standered sql.3.can"t be abbreviated.4.uses fns to perform some formatting.5.do...

madhu sudhan rao

• Sep 18th, 2006

sql*plus is a tool ( interface ) where we enter sql commands, its just like an command line interface like doswereas sql is query language with which we communicate with the database.in order to communicate with the database we can do only with the query language

Answer Question  Select Best Answer

Arijit Basu

• Oct 7th, 2006

How can I call a report from a from in d2k?

Answer Question  Select Best Answer

Mano

• Sep 26th, 2006

Hi,select max(nvl(empno,000000))+1 from empU have to wrie this in pre_text_item trigger of the empno item.Check and confirm.Thanks and bye

Answer Question  Select Best Answer

The Client/Server computing has three components in it namely:

Client
Server
Network

Let us see the functions of each.

Server:
This is one that manages data or information in database. It also takes the role of coordination or assigning process when multiple clients functions which is very common in client/server computing...

All these statements fall in the category of Transaction Control Statements.
Rollback:
This is used for undoing the work done in the current transaction. This command also releases the locks if any hold by the current transaction. The command used in SQL for this is simply:

ROLLBACK;

Savepoint:
This is used for identifying a point in the transaction...

One of the important concepts in database management is Partitioning. Partitioning is the concept by which storage of tables are pre-organized to attain efficiency. That is in other words the rows present in a table are stored across different disks or fields to achieve optimization and performance improvement.

How to achieve this concept in MYSQL

Database statements...

There are functions which return a value for each single row selected. Example of such functions are Arithmetic functions like ABS(column name) in SQL. But in contrast group functions are one in which summary or result of the group of rows is got. For example in an entity DEPARTMENT there may be instance in which the programmer may like to get the average salary of a particular department say d1. This...