Answer Posted / sharath

select count(substr('a,b,c',',',instr('a,b,c',',',1,1)-1))
,count(substr('a,b,c',instr('a,b,c',',',1,1)+1,instr
('a,b,c',',',2,1)-instr('a,b,c',',',1,1)-1))
,count(substr('a,b,c',instr('a,b,c',',',2,1)-1)) from
table_name;

Is sql considered coding?

1043

---

What is the need of merge statement?

1038

---

Is sql a oracle?

978

---

How do I save a sql query?

1012

---

What is date functions?

1028

---

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1097

---

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.

1579

---

What is an exception in PL/SQL? What are the two types of exceptions?

1310

---

what is the difference between truncate and drop statements? : Sql dba

1124

---

what are the differences between char and nchar? : Sql dba

1113

---

How do I remove sql plus from windows 10?

1096

---

Can you rollback after commit?

982

---

How do I find duplicates in the same column?

1082

---

Will truncate release space?

950

---

What is #table in sql?

1098

---