Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974
5 11544need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
2 6089i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject
8 10240write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35
TCS,
1 5371wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh
TCS,
6 13603write 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
TCS,
3 7840wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010
6 15834In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop
JDA,
4 8660
What is the difference between the conventional and direct path loader? : aql loader
What is difference between sql and excel?
How do you sort in sql?
What is snowflake sql?
What are sql triggers used for?
Is left join same as join?
Is left join faster than join?
How do you update a value in sql?
What are the different types of joins in sql?
What is sql character function?
Do prepared statements prevent sql injection?
How long will it take to learn pl sql?
Describe sql comments?
What is compute?
what is recursive stored procedure? : Sql dba
