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 |
What is localdb mssqllocaldb?
What is normalisation in sql?
What is a CTE (Common Table Expression), and how is it different from a subquery?
What is the best strategy to use COMMIT in a pl/sql loop?
What are primary key and foreign key and how they work?
Why do we use function in pl sql?
Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)
What are the key differences between SQL and PL SQL?
Explain the working of primary key?
What has stored procedures in sql and how we can use it?
What is the basic structure of PL/SQL ?
what are enums used for in mysql? : Sql dba
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)