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 will be the output: select 1 from emp union all select 2 from emp;
what is union, minus and interact commands? : Sql dba
What are system versioned tables?
What is dynamic query?
Advantages and disadvantages of stored procedure?
What are the types of triggers ?
26 Answers Aspire, BirlaSoft, TCS,
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
what is the difference between implicit and explicit trigger
What is RAC in oracle?
What is materialized view in sql?
What is an emotional trigger?
What are actual parameters and formal parameters?
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)