Answer Posted / hari

select max(sal) from employee;
or
select * from employee where sal in(select max(sal) from employee);

What is your daily office routine?

2274

---

what is union? : Sql dba

1033

---

When you have to use a default "rollback to" savepoint of plvlog?

1204

---

What are the subsets of sql?

1138

---

How to run sql statements through the web interface?

1048

---

Is sql considered coding?

1050

---

What is pl sql collection?

978

---

Are subqueries faster than joins?

1024

---

What are expressions?

1019

---

how to convert dates to character strings? : Sql dba

1178

---

How to write a query to show the details of a student from students table whose

1002

---

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.

1586

---

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1163

---

Which nosql database is best?

986

---

what is cursor. write example of it. What are the attributes of cursor.

1398

---