How to display databases in Oracle 11g using SQL*Plus How to Query Database Name in Oracle SQL Developer? Starting SQL*Plus and Connecting to the DatabaseĮxample 1-3 Connecting to a Local Database User WHERE a.tablespace_name = b.tablespace_name ģ.8.3 Starting SQL*Plus and Connecting to the Database (SELECT tablespace_name, SUM(bytes) total
ORACLE SQL DEVELOPER SPOOL FREE
Round((total - free) / total, 4) * 100 "USED %"įROM (SELECT tablespace_name, SUM(bytes) free SELECT a.tablespace_name "TABLESPACE_NAME", Select dbms_metadata.get_ddl('TABLE', table_name) from user_tables Select dbms_metadata.get_ddl('TABLE', 'table_name') from dual SELECT owner, table_name FROM user_tables -Viewing Tables Owned by Current user SELECT owner, table_name FROM all_tables -Viewing Tables Accessible by Current User SELECT owner, table_name FROM dba_tables -Viewing All Tables SELECT owner, table_name FROM dba_tables WHERE owner = 'owner_name'
Select tablespace_name from user_tablespaces Select username from all_users order by username # 输入 sqlplus / as sysdba 命令表明使用操作系统认证方式(operating system authentication)Ĭ:\Users\Administrator>sqlplus / as sysdba 从 Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production If you don't want to set that on each export you can set it as a default, from Tools->Preferences: When you export and choose CSV or delimited format you can choose whether to include the header and which delimiter and enclosures to use - and you're allowed to choose 'none'. Or you can run the query using Run Statement (Ctrl-Enter) and then export the results from the data grid, from the context menu that appears when you right-click on the output. If you really want CSV format without enclosures you can either build up the output manually by concatenating the column(s) with comma literals, which still allows you to spool to a file: If you have multiple columns or strings that may contain delimiters then the enclosures are useful to stop those delimiters being misinterpreted when opening in Excel or some other external tool. If you are really exporting that one column and don't have delimiters then just leave out the /*csv*/ directive. Using CSV format for a single column seems rather pointless anyway though, unless you have delimiters in your string you want to escape. The slightly more convenient way of doing this now is with the sqlformat command, but even with sqlformat delimited you have to have the string enclosed. You can't get rid of the double-quotes with the /*csv*/ directive.
0 kommentar(er)
