Shulou(Shulou.com)06/01 Report--

Query the existing tables:

Show all tables (table is abbreviated, only table name)

Select * from tab

Show all tables (all table fields)

Select * from user_tables

Query the table under user xxk (user name should be uppercase, only table name)

Select TABLE_NAME from all_tables where owner = 'XXK'

Query sequence:

Show all sequences (full field, maximum, minimum, size [how much each time], next value, etc.)

Select * from seq

Query the next value of the sequence tbgridinfo_autoinc. After the query, the sequence has been incremented.

Select tbgridinfo_autoinc.nextval from dual

Change the self-increasing range of the sequence, which can be a negative number, indicating the minus sign, how much is minus

Alter sequence tbgridinfo_autoinc increment by + 1

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.