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


Databases Interview Questions
Questions Answers Views Company eMail

what the meaning of sql

 8 12050

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance

Target,

5 5836

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy

Target,

6 6909

suppose there are two textfields t1,t2 in form and we have some value in textfield t1.now the question is that how can we copy the value of the t1 to textfield t2?

Oasis,

2 4373

Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL

1 3063

what is maximum size of temp db?

iSoft,

4 10433

What is a temp table? how to denote temp table?

Oracle,

4 10249

sequence of firing triggers for text-item is: 1)key_next_item, 2)when_validate_item, 3)post_text_item Now i change sequence of firing triggers like when_validate_item,key_next_item... Is it possible to change sequence? How?

ESS,

1 5437

what is Constraint? How many types of constraints in SQL ?

HCL, IBM, NIIT, Wipro,

38 79837

what r tyhe major differences between oracle 9i & 10g?

 6 12105

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

 1612

How to write a script for upate the data in prod , i have 50000 row are there

TCS,

2 4551

Is primary key = unique key,not null? If yes,please explain IF No,please explain

Genpact,

8 15323

how to connect oracle in unix prompt?

Polaris,

4 11077

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2468

Un-Answered Questions { Databases }

Can you store images in postgres?

432

What is difference between mysql and postgresql?

516

What is indexed view?

601

How to rename an existing column in a table?

541

Explain “row_number()” in sql server with an example?

522




Can we create table in function?

571

How large can a mysql table be?

457

Determine when to use stored procedure to complete sql server tasks?

537

How to load a large xml file?

584

What is limit in mysql?

443

Is sql server difficult to learn?

524

What are database skills?

275

Explain the wait events in statspack report 'enqueue'?

285

What is full form of xampp?

544

What is msaccess exe?

448

For More Un-Answered { Databases } Questions Click Here