Answer Posted / nagapawan

Hi,
oracle name took from oracle company. thats right. i heard
that we store unlimed of date permanently. we can retrive
data when ever we want.it has safe secure than other
datbase. but only one dis adv is that we have write long
statement and difficult in code. not easy to write like sql
server. and much more is there . important one only i refered.

for eg: ms-access we cannot store large data in it. it has
limited space also not that much secure as oracle as.

i think this enough to guest

how to load data files into tables with 'mysqlimport'? : Sql dba

1091

---

How many tables can you join in sql?

953

---

What is form and report?

971

---

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1216

---

What is nvl?

1061

---

How do you declare a variable in pl sql?

1019

---

how can we know the count/number of elements of an array? : Sql dba

1057

---

What is difference between pl and sql?

1049

---

What is keys and its types?

1069

---

How many aggregate functions are available there in sql?

979

---

Is it possible to read/write files to-and-from PL/SQL?

1097

---

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

2427

---

What is a dirty read sql?

1124

---

how to check server status with 'mysqladmin'? : Sql dba

1069

---

Is nosql relational?

938

---