Top "Sqlplus" questions

I have two problematic columns: Fee NUMBER type, AdjFee also NUMBER. After column Fee format a5; select Fee ID smth …

I am required to spool a csv from a table in Oracle, using sqlplus. Following is the format required: "HOST_…

I have to run multiple SQL script file in one go. Like every time i have to write command in …

SELECT dealing_record.* ,shares.* ,transaction_type.* FROM shares INNER JOIN shares ON shares.share_ID = dealing_record.share_id INNER …

I have this running in SQLplus set feedback off set pagesize 0 spool TypeDrop.sql select distinct 'drop type '||object_…

I currently am spooling a pipe file via this sqlplus script: set feedback off set echo off set verify off …

I have Oracle 11 running on a Windows server and I'm logged onto the same server trying to use SQL Plus. …

I'm doing the following spooling statement: SET VERIFY OFF SET FEEDBACK OFF SET HEADING OFF SET TRIMSPOOL ON SET TERM …

I want to connect with my Oracle database without installing Oracle Client. I downloaded: "Instant Client Package - Basic" and "…

Anyone have a good set of sqlplus configuration directives to help transform a given sql query into nicely tab separated …