Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

0 Answers  

---

How much does sqlite cost?

0 Answers  

---

explain mysql aggregate functions. : Sql dba

0 Answers  

---

difference between SQL and C

1 Answers   Indus Software Technologies,

---

What is write ahead logging in sql server?

0 Answers  

---

---

How to read/write files from pl/sql?

0 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,

---

package specification-3 procedures package body-4 procedures how can i write for other procedure in package body

2 Answers   Reliance,

---

Does sqlite need a server?

0 Answers  

---

What's the difference between a primary key and a clustered index?

0 Answers  

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

0 Answers  

---

suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary

7 Answers  

---