Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11565 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ranvijay
we can only alter MINVALUE,MAXVALYE,Incremented by and
CACHE of sequence.but not alter START WITH.
Alter sequence sequanceName
incremented by 2
minvalue 101;
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
What is microsoft t sql?
what are the different functions in sorting an array? : Sql dba
How to get unique records from a table?
Can a table contain multiple foreign key’s?
How can we solve sql error: ora-00904: invalid identifier?
Is record in pl sql?
Does view contain data?
How do I edit a trigger in sql developer?
What are types of exception?
What does subquery mean in sql?
Is foreign key mandatory?
What is the reports view in oracle sql developer?
explain access control lists. : Sql dba
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What is the advantage of nosql?
