Answer Posted / lokanath

Because its a Column Level constraint.
Not Null is a Constraint which will ensure the Column
should not be null.

What are the differences between char and nchar in oracle?

1032

---

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2138

---

How to write numeric literals in oracle?

1135

---

Can we connect to ORACLE db using Windows Authentication?

1196

---

How to retrieve the count of updated rows?

1069

---

What is MTTR advisor in Oracle?

1047

---

What is a parameter file in oracle?

1066

---

How to define a record variable to store a table row?

1021

---

How translate command is different from replace?

1027

---

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1384

---

How to use "startup" command to start default instance?

979

---

How do I spool in oracle?

953

---

How to get maxsal , minsal, ename department wise in single query

1508

---

What does sharding mean?

956

---

Please explain oracle left join with an example?

971

---