Answer Posted / tripti gour

yes, we can
ex.

create table t1
(empno number(4) not null,
ename varchar2(30),
constraint u_k_t1 unique key (empno));

How to generate query output in html format?

1125

---

Where do we use decode and case statements?

1018

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1052

---

Explain how you would restore a database using RMAN to Point in Time?

2148

---

How to calculate date and time differences in oracle?

1045

---

How to assign a table row to a record variable?

1046

---

What is the parameter mode that can be passed to a procedure?

1054

---

Please explain oracle data types with examples?

1075

---

what is the scripts in data base?

2160

---

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2231

---

How to fetch the row which has the max value for a column?

1002

---

How to loop through data rows in the implicit cursor?

1079

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2628

---

What is the difference between substr & instr functions?

1233

---

What are the various oracle database objects?

1148

---