Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

TCS SQL PLSQL Interview Questions
Questions Answers Views Company eMail

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

 3 6684

How to count the no of records of a table without using COUNT function?

 11 24972

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?

 4 18365

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

 9 8861

What is the difference between UNIQUE KEY and UNIQUE INDEX?

 3 7554

What is the differnce between view and materialized view

 4 7581

What is dynamic SQl and how you will create and execute dynamic sql?

 2 6345

Query for second maximum salary in each in each department

 15 34387

query to retrive the employees whose sal is greater than avg sal

 10 12302

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?

13 19877

select sal from emp group by sal

 3 5136

counting the no.of characters occurs in a string by using pl/sql function

 1 5544

What is the relation b/w view and trigger

 3 14746

how to create temparary sequence

2 6792

What is the Difference between Procedure and Function.Can we call a Function in a DML?

 2 7053

Post New TCS SQL PLSQL Interview Questions


TCS SQL PLSQL Interview Questions


Un-Answered Questions

What do I need in order to install exchange 2003?

544

In Bootstrap what are the two ways you can display the code?

5

how can you implement fine-grained auditing?

608

How do you calculate the due date of a document?

706

What is the purpose of serialization in swings?

554




What are the disadvantages of stored procedures?

499

How do you invoke a Servlet? What is the difference between doPost method and doGet method?

650

Why “no suitable driver” error occurs?

623

Explain what is the difference between far and near ?

657

How to improve the cache performance? : .NET Architecture

558

How does python input work?

471

What are the advantages and disadvantages of air refrigeration system?

670

Dear all i am new to testing my company using vb.net and we are developing web based application. How i can test those application with winrunner if any one have some good tutorial or link kindly provide thanks u.

1563

Explain different ways of creating a thread. Which one would you prefer and why?

579

What is j std 001 class 3?

666