SELECT cols.column_name FROM all_constraints cons, all_cons_columns cols WHERE cons.constraint_type = 'P' AND cons.constraint_name = cols.constraint_name AND cons.table_name = cols.table_name AND cons.owner = cols.owner AND cons.table_name='my_table_name' AND cons.owner='my_schema_name' See ... Read more
Tag Archives: Oracle
Batch export data from Oracle tables to HTML files
Want to batch export data from Oracle tables to HTML files? Using OraLoader, you can batch export data from Oracle tables to Html files easily and fast, just a few mouse clicks! Here you can download and install OraLoader. Batch export data from Oracle tables to Html files Click ... Read more
Batch export data from Oracle tables to SQL files
Want to batch export data from Oracle tables to SQL files? Using OraLoader, you can batch export data from Oracle tables to Sql files easily and fast, just a few mouse clicks! Here you can download and install OraLoader. Batch export data from Oracle tables to Sql files Click “Unload ... Read more
Batch export data from Oracle tables to JSON files
Want to batch export data from Oracle tables to JSON files? Using OraLoader, you can batch export data from Oracle tables to Json files easily and fast, just a few mouse clicks! Here you can download and install OraLoader. Batch export data from Oracle tables to Json files Click ... Read more
Batch export data from Oracle tables to XML files
Want to batch export data from Oracle tables to XML files? Using OraLoader, you can batch export data from Oracle tables to Xml files easily and fast, just a few mouse clicks! Here you can download and install OraLoader. Batch export data from Oracle tables to Xml files Click “Unload ... Read more
Batch export data from Oracle tables to TSV files
Want to batch export data from Oracle tables to TSV files? Using OraLoader, you can batch export data from Oracle tables to Tsv files easily and fast, just a few mouse clicks! Here you can download and install OraLoader. Batch export data from Oracle tables to Tsv files Click “Unload ... Read more
Batch export data from Oracle tables to TXT files
Want to batch export data from Oracle tables to Txt files? Using OraLoader, you can batch export data from Oracle tables to Txt files easily and fast, just a few mouse clicks! Here you can download and install OraLoader. Batch export data from Oracle tables to Txt files Click “Unload All ... Read more
Export data from Oracle query to HTML file
Want to export data from Oracle query to HTML file? Using OraLoader, you can export data from Oracle query to Html file easily and fast, just a few mouse clicks! Here you can download and install OraLoader. Export data from Oracle query to Html file Click “Unload From Query” at ... Read more
Export data from Oracle query to SQL file
Want to export data from Oracle query to SQL file? Using OraLoader, you can export data from Oracle query to Sql file easily and fast, just a few mouse clicks! Here you can download and install OraLoader. Export data from Oracle query to Sql file Click “Unload From Query” at task ... Read more
Export data from Oracle query to JSON file
Want to export data from Oracle query to JSON file? Using OraLoader, you can export data from Oracle query to Json file easily and fast, just a few mouse clicks! Here you can download and install OraLoader. Export data from Oracle query to Json file Click “Unload From Query” at ... Read more