Can you alter start with clause?
Answer / ashok
No.....When altering a sequence,
MAXVALUE, INCREMENT BY, CACHE, CYCLE can be altered as we wish
But Startwith we cant alter
and also Minvalue should not be altered less than seq.CURRVAL
| Is This Answer Correct ? | 3 Yes | 0 No |
Explain some predefined exceptions.
How many sql are there?
How do you declare a user-defined exception?
What is pl sql code?
Can a table have no primary key?
i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#
What is a dynamic query?
write sub query for eliminating duplicate rows using analytical function?
What is the difference between the sql*loader and import utilities? : aql loader
What is prepared statement in sql?
How to check if a column is nullable before setting to nullable?
What is difference sql and mysql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)