Sql

SELECT * FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'tbs_name' ORDER BY FILE_NAME;

SELECT
FILE_NAME, 
BLOCKS, 
TABLESPACE_NAME
FROM DBA_DATA_FILES;

PREVIOUS	NEXT

Code Example
Sql :: get the mysql table columns data type mysql
Sql :: create procedure with encryption
Sql :: load mysql dumb
Sql :: oracle check numeric
Sql :: scaffold npgsql net core
Sql :: oracle session date format
Sql :: oracle get nls settings
Sql :: oracle sql first day of year
Sql :: update substring in mysql
Sql :: sql get table last modified time
Sql :: sql list users and roles
Sql :: oracle split string
Sql :: split first name and last name in sql
Sql :: mysql show tables in database
Sql :: how to see all table partition in oracle
Sql :: select sql in descending order
Sql :: get all table names in sql
Sql :: sql drop table statement
Sql :: reset sql auto increment
Sql :: view linked servers sql
Sql :: oracle create program if no exists
Sql :: mysql change primary key
Sql :: Syntax of for-loop in SQL Server
Sql :: using distinct count in sqlite3
Sql :: centos 8 install mysql
Sql :: if not exists insert sql
Sql :: sql add months to date
Sql :: join to find results not in another table
Sql :: this is incompatible with sql_mode=only_full_group_by laravel
Sql :: mysql order by desc null last