What is the syntax to view structure of table?

What is the syntax to view structure of table?

schema:gisq

What is the syntax to view structure of table?

SELECT * FROM syscat.COLUMNS
WHERE tabname= 'CIA'

SELECT * FROM all_tab_columns
 WHERE TABLE_NAME='CIA'

sp_columns @TABLE_NAME=cia

SHOW COLUMNS FROM gisq.cia

SQL

From within sqlplus we can use the DESCRIBE command. Outside sqlplus we can access the view all_tab_columns

Meta Data

What are my tables?

What are the columns of the BBC table?

Get the first 10 rows of the gisq.cia table.

Get the 11th to the 20th rows of the cia table - by population.

What version of the software am I using?

What is the syntax to view structure of table?

How can you determine the primary key using SQL?

Return a sequential record count for all records returned