Answer Posted / madhu

The Simple examples is correct but we take the date in date
format not like sysdate or hiredate.
if u select to_char('some date') and to_date('somedate')
explain with this examples if any one know.

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)

719

---

What is an emotional trigger?

686

---

What is consistency?

883

---

Is sql dba a good career? : SQL DBA

705

---

What is right join sql?

706

---

---

What is coalesce in sql?

725

---

Is primary key a clustered index?

703

---

Explain isolation levels. : Transact sql

740

---

Can we write dml inside a function in sql server?

670

---

What is a schema? How is it useful in sql servers?

788

---

What are types of exception?

685

---

What is record variable?

705

---

What is an ndf file?

683

---

What is the maximum size of sqlite database?

719

---

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

744

---