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 a string data type in sql?
What is the difference between RDBMS and DBMS?
20 Answers Practical Viva Questions, Sapient, Stag Computers,
What does the base_object_type column shows in the user.triggers data dictionary view?
Can we join same table in sql?
Does sqlite need a server?
How to select all records from the table?
how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000
What is compilation error in pl sql?
what are tables and fields? : Sql dba
how are mysql timestamps seen to a user? : Sql dba
Write a query to get last 10 records from the table.
What does partition by mean in sql?
Oracle (3253)
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)