adspace


  1. Categories >> Software >> Databases
  2. Suggest New Category


Databases Interview Questions
Questions Answers Views Company eMail

How to define numeric 9(3) in db2 table without decimal point??

 1 2946

have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.

IBM, Zensar,

8 14978

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

 1 2313

Without giving condition how to retrieve the unmatched records from table.

TCS,

1 5083

can we call primary key a 'address'????

1 2549

what is difference between inner join & nested query or subqueries

 1 3169

Can anybody tell which is the best training institute for learning Oracle in chennai...? And i also i want placement assurance

 1 4209

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

1 2414

when i run my query on yesterday it is fast but today it is slow why?

 1 7758

I have a CURSOR then why we need BULK COLLECT again?

 1 7516

what is the difference between inline query and corelated subquery

1 4618

Can anybody give me link for BOXI R3.1 Key please

 1 2698

how to find find & delete duplicate rows from two different tables?

Accenture, TCS,

3 12106

how to get rank of diffrent student in same table based on newly inserted row in sql server2008

ABC,

4 8480

i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

1 3089

Un-Answered Questions { Databases }

Where can you add custom error messages to sql server?

1229

Is it possible to have clustered index on separate drive from original table location?

1054

Can one drop a column from a table?

1101

Why should you use or avoid select * statements?

1127

What is the current mysql version?

1112

List the ways in which dynamic sql can be executed?

1105

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1213

What are the two main functions of queries in databases?

1551

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1304

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2303

Why we use the openxml clause?

1090

in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1616

How efficient you are in oracle and SQL server?

1270

Is primary key always clustered index?

1102

What are different types of constraints?

1009

For More Un-Answered { Databases } Questions Click Here