Answer / rahul khanke

hi,
basic oracle architecture is devided in 3 stages
1. storage structure
1. physical storage
a. data file
b. control file etc..
2.logical storage
a. tablespace
b. extents etc..
2. memory structure
a. SGA
b. PGA
2. process structure
1. mandatory process
a. SMON
b. PMON etc
2. optional process

and much more

There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?

4 Answers   IBM,

---

What is database sql?

0 Answers  

---

I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,

---

Can ddl statements be used in pl/sql?

0 Answers  

---

what is “go” in t-sql? : Transact sql

0 Answers  

---

---

What are the sql versions?

0 Answers  

---

Why coalesce is used in sql?

0 Answers  

---

What is sql and its types?

0 Answers  

---

What is referential integrity ?

3 Answers   BirlaSoft,

---

How do I save a stored procedure?

0 Answers  

---

What are different types of tables in sql?

0 Answers  

---

Is sql sequential or random?

0 Answers  

---