Search
 
SCRIPT & CODE EXAMPLE
 

SQL

oracle list data files

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

Oracle list datafiles

SELECT
FILE_NAME, 
BLOCKS, 
TABLESPACE_NAME
FROM DBA_DATA_FILES;
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql datetime to date 
Sql :: sqlite indexes 
Sql :: extract weekday from date in sql 
Sql :: sql percentage 
Sql :: oracle sql select all days between two dates except weekends 
Sql :: mysql to get column name in database 
Sql :: mysql query dates between two dates 
Sql :: sql server insert into select 
Sql :: alter table add multiple columns postgresql 
Sql :: mysql select into new table 
Sql :: oracle revoke grant 
Sql :: postgres list users and roles 
Sql :: laravel jwt 
Sql :: mysql delete table with foreign key 
Sql :: postgresql append array 
Sql :: do postgresql 
Sql :: ascending order and where in sql 
Sql :: The local psql command could not be located 
Sql :: mysql trim spaces 
Sql :: sql change date format 
Sql :: sql substring 
Sql :: postgresql remove new line from string 
Sql :: mysql age by birthdate 
Sql :: date in oracle 
Sql :: sql select rows with different values in one column 
Sql :: ERROR: syntax error at or near "AUTO_INCREMENT" posgtresql 
Sql :: mysql load sql from file 
Sql :: how to remove unique key in mysql 
Sql :: what is datetime in sql server 
Sql :: sql view talbe columns 
ADD CONTENT
Topic
Content
Source link
Name
3+7 =