Answer / lipika

To create a sequence that stops at a predefined limit, for
an ascending sequence, specify a value for the MAXVALUE
parameter.
For a descending sequence, specify a value for the MINVALUE
parameter. Also specify NOCYCLE. Any attempt to generate a
sequence number once the sequence has reached its limit
results in an error.

NOTE:-Interval between the sequence value must be less than
the difference of MAXVALUE and MINVALUE. If this value is
negative, then the sequence descends. If the value is
positive, then the sequence ascends. If you omit this
clause, then the interval defaults to 1.

Explain the components of sql?

0 Answers  

---

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...

0 Answers   Satyam,

---

What is anonymous block in sql?

0 Answers  

---

Explain how procedures and functions are called in a PL/SQL block ?

3 Answers  

---

how to select first 5 records from a table? : Sql dba

0 Answers  

---

---

what is the difference between stored procedure and packaged procedure

1 Answers   Google, Infosys,

---

What is pl/sql tables?

7 Answers   TCS,

---

Are sql database names case sensitive?

0 Answers  

---

How many types of functions are there in sql?

0 Answers  

---

How many sectors are in a partition?

0 Answers  

---

select 1,col1,col2 from table1. output?

5 Answers   Ramco,

---

What are sql built in functions?

0 Answers  

---