vijay


{ City } chennai
< Country > india
* Profession * it developer
User No # 121480
Total Questions Posted # 0
Total Answers Posted # 7

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 0
Users Marked my Answers as Wrong # 0
Questions / { vijay }
Questions Answers Category Views Company eMail




Answers / { vijay }

Question { 11116 }

What are the components of a PL/SQL block ?


Answer

declare
cursor
user defined exception
variable
begin
sql statement
plsql statement (application wise/business logic)
exception
end;

Is This Answer Correct ?    0 Yes 0 No

Question { 12155 }

how to retrieve only duplicate values in a table


Answer

select count (column_name),column_name from table_name group by column_name having count(column_name)>1;

Is This Answer Correct ?    0 Yes 0 No


Question { Satyam, 12060 }

how to eliminate null values in a column i.e
table vlaues
1 2 3
NULL 3 4
1 5 NULL
i want output like this
1 2 3
3 4
1 5
i dnt want to use nvl is null and i dnt want replace the
NULL value with any value i.e nvl(col,o);


Answer

please use group function is ignore the null values

Is This Answer Correct ?    0 Yes 0 No

Question { Zensar, 5072 }

define sql


Answer

sql --- structure query language
It is a English like language
It can write more line with or without space
It can easy to de buggings
There is no specific limit for sql query

Is This Answer Correct ?    0 Yes 0 No

Question { 4388 }

in sql table following column r there
i want find 1st paid ,2nd paid,3rd paid date for same
|service_type|date |vehicle_no|
|------------|------|_---------|
|paid |23 jan|MH12H2007 |
| | | |
|paid |26 feb|MH12H2007 |
| | | |
| | | |
|paid |28 mar|MH12H2007 |
i want o/p like below
vehicle no| 1st paid date | 2nd paid date|3rd paid |latest
paid date|

pls help me out


Answer

with temp as (select
service type,
paid,
vechile no,
dense_rank()over(order by date asc) as a
from table
select * from temp where a<=3;

Is This Answer Correct ?    0 Yes 0 No

Question { Infogain, 2601 }

What is the criteria while applying index to any column on
any table.


Answer

index syntax
-----------------
create index index_name on table_name (column_name)

Is This Answer Correct ?    0 Yes 0 No

Question { GE, 8382 }

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.


Answer

Hi,
I have used left outer join
select
a,
b
from
tab1 ,
tab2
where
tab1.a = tab2.b(+);

Is This Answer Correct ?    0 Yes 0 No