Answer Posted / nagaraju

Null value is unknown value bcoz it has no space&no data

null value use for enter nay value for utilize

How to empty your oracle recycle bin?

1022

---

what is the dual table in oracle?

993

---

How to convert numbers to characters in oracle?

1030

---

What is ASM (Automatic Storage Management) in Oracle?

1196

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1947

---

What is the sql query to concatenate column values from multiple rows in oracle?

1056

---

What are the ways tablespaces can be managed and how do they differ?

2368

---

What is query image?

981

---

Explain the use of tables option in exp command.

1117

---

Explain enable novalidate constraint.

1083

---

What is the use of aggregate functions in oracle?

1026

---

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1787

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4366

---

What is a sub query? Describe its types?

1018

---

if you ctreate table identity

2374

---