I Have A Table Like This. Cityno Cityname Mails 1 Bangalore 8km 2 Hsr Layout 20km 3 Mejistic 30km 4 Jayadeva 55km 5 Itpl 80km 6 Hebbal 115km I Have Data Like This I Want O/p Like This Distance No.ofcity 0-50km 3 51-100km 2 101-150km 4 And So On

6 Answers   DELL, HCL, Oracle,

---

What are pl sql procedures?

0 Answers  

---

What is the use of sqldataadapter?

0 Answers  

---

How does postgresql compare to "nosql"?

0 Answers  

---

Can a varchar be a primary key?

0 Answers  

---

How can we store rows in PL/SQL using array?

0 Answers   MCN Solutions,

---

What are the string functions in sql?

0 Answers  

---

What is difference between function and trigger?

0 Answers  

---

How do you display "13th of November, 17 days left for month end" without hardcoding the date.

3 Answers  

---

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

0 Answers   Prodapt,

---

What is query execution plan in sql?

0 Answers  

---

I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

2 Answers  

---