1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category
Oracle General Interview Questions
Questions Answers Views Company eMail

in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit

Polaris,

3 4588

Which Department has MOST NUMBER of employees?

IBM, LeadSquared, Mastek,

8 47763

acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account

Polaris,

2 4429

Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here

 2 5320

how to store only time in a data base table

 2 4098

how to get the no employee in each department including the dept which has 0 employee

 5 5415

What is the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index

 1 6393

WHAT IS ecc 6.0

1642

does Oracle has only one table space?

Oracle,

1 3420

how to unbreak sequence numbers during intereptions

Ion Exchange,

1 2789

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

 1737

can we pass two out parameters at a time in function?please answer to my question

Wipro,

3 4995

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 3951

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 5410

i want department wise maxmum salary and empolyee name

 9 27164

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is difference between sid and service name in oracle?

507

How to run the anonymous block again?

586

Can multiple cursors being opened at the same time?

600

How to use select statement to count the number of rows in oracle?

540

What is meant by a deadlock situation?

564




What are the different types of record groups in oracle? Explain each of them

586

Explain about functional dependency and its relation with table design?

539

How to define a sub function?

656

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

1836

What is a read only transaction in oracle?

585

Hi Can any one tell me what are the API's used in requisition import.

1472

Explain oracle’s system global area (sga).

609

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

543

How to get a create statement for an existing table?

558

What do you mean by merge in oracle and how can we merge two tables?

565

For More Un-Answered { Oracle General } Questions Click Here