Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to get the ddl for datafile in oracle tablespace

SELECT DBMS_METADATA. GET_DDL('TABLESPACE','&TABLESPACE_NAME') FROM dual; --Example: --Enter the tablespace Name then it will get you the DDL for your tablespace.
Comment
PREVIOUS NEXT
Code Example
Sql :: how do you use sql in you company 
Sql :: create table mysql example auto_increment 
Sql :: mysql trigger after update 
Sql :: ALL_TAB_PARTITIONS 
Sql :: mysql tinyint max value 
Sql :: sql string_agg 
Sql :: sql update from select 
Sql :: alter table change default 
Sql :: mysql best varchar length size 
Sql :: différence entre deux dates sql oracle 
Sql :: mysql select utc time in eastern time 
Sql :: reset auto increment in mysql 
Sql :: mysql update inner 
Sql :: mysql shell ERROR: Not connected. 
Sql :: oracle create program if not exists 
Sql :: how to fetch alternate records from two tables 
Sql :: how to check current user in mysql 
Sql :: ora-00054 resource busy and acquire with nowait 
Sql :: sql server date now 
Sql :: sql delete multiple conditions 
Sql :: sql auto timestamp 
Sql :: show size database mysql 
Sql :: not operator in oracle 
Sql :: cast to float with .2 sql 
Sql :: mysql sort by date column 
Sql :: mysql order by desc null last 
Sql :: postgresql get last 10 records 
Sql :: sql group by year 
Sql :: spring import sql 
Sql :: find duplicate keys in mysql 
ADD CONTENT
Topic
Content
Source link
Name
2+6 =