Answer Posted / shriram2012

SQL> select * from quest;

Cityno cityname mails
---------- -------------------- ----------
1 bangalore 8km
2 hsr layout 20km
3 mejistic 30km
4 jayadeva 55km
5 itpl 80km
6 hebbal 115km

6 rows selected.

SQL> with data as (
2 select level as lvl,lag(level,1,0) over(order by level) as pre_lvl
3 from dual
4 where mod(level,50) = 0
5 connect by level <=150)
6 select count(cityno),pre_lvl||'-'||lvl
7 from quest
8 ,data
9 where to_number(replace(mails,'KM',0))/10 between pre_lvl and lvl
10 group by lvl,pre_lvl;

What is vector point function?

1055

---

how to shut down the server with 'mysqladmin'? : Sql dba

1014

---

What is dense_rank in sql?

988

---

What is embedded sql with example?

1056

---

What is compound trigger?

1042

---

How much does sqlite cost?

1044

---

What is the difference between nested table and varray?

1006

---

How do I edit a stored procedure?

996

---

Define sql delete statement.

1016

---

Why is sql*loader direct path so fast?

1107

---

What is t sql in sql server?

1078

---

Is pl sql different from sql?

1001

---

What is difference between hql and native sql?

1177

---

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.

1583

---

How to fetch alternate records from a table?

1245

---