Question

Suppress / hide sqlplus prompts / parameters in the output file

Rating9.2Excellent

I know all kind of "Set" System Variables, but none could supress / hide the sql prompt / parameter in my output, the output files always opens up with "Enter Value for xxxxx" which referes to the prompt I supplied the sql code with when I initially ran it.

Your thoughts please.

Thx

  1. Explanation of XMLELEMENT function output
    Oracle Documentation (http://download-east.oracle.com/docs/cd/B14117_01/server.101/b10759/functions203.htm#sthref2032) The above link is from the Oracle documentation for the XMLELEMENT function. The example shown indicates the expected results. However, when I ran the query (copied and pasted) in…
  2. How to open a file/write sth iwithn PL/SQL
    Have a sql statement sqlplus scott/***@testDB spool c:\test.sql select 'select count(1) from '||table_name ||';' from user_tables; spool off exit; Would like to write the statements within the pl/sql block and generate the file test.sql, and then execute it. How to do that in Oracle v10.2
  3. Problem with ctl file for SQL Loader
    Here is my control file and a snippet of the log file. I am getting an error - column not allowed here. OPTIONS (SKIP=1) LOAD DATA APPEND INTO TABLE HB_DWH.POST_PARTUM FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLEID_TEMPFIELD …
  4. Query for output in tabular format
    Dear Experts I have a query as below which is on ORACLE 10G SELECT MEMBERMASTER.MEMBERNAME, BMBILL.MEMBERID, BMBILL.BILLDATE, BMBILLDTL.AMOUNT FROM BMBILL, BMBILLDTL, MEMBERMASTER WHERE (BMBILL.INTNO = BMBILLDTL.INTNO) AND (BMBILL.MEMB…
  5. send oracle output as an email
    Hi guys I am trying to send oracle output as an email using the Oracle Reports 10g and typing the email address in a parameter

Solution

Sign up now to view this solution! It's quick, easy, and secure to subscribe. We will return you to this solution, unlocked, when you’re done.

About this Solution
View This Solution - Start Your 30 Day Free Trial
Zone
Troubleshooting
Tags
Oracle sqlplus
Participating Experts
2
Solution Grade
A

Replies

 
by: ajexpert

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: codedigger

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by:

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Stay Connected

Oracle Around the Web

The latest Oracle news, tips, and tricks

Oracle Unveils Netra SPARC T3 Servers

New Carrier-Grade Blade and Rackmount Servers Deliver Better Performance, Density and Power Efficiency for the Communications Industry ...

read more

Oracle fixes 21 flaws in Java SE, Java for Business

Oracle is fixing 21 flaws in its Java SE and Java for Business products in its February critical patch update issued this week ...

read more

Obama’s Silicon Valley “Tech Supper”

Why was he there? Who wasn’t invited and why? What did they talk about? Why was he really there? These are the questions being debated ...

read more

Featured Oracle Experts

slightwv

slightwv has answered more than 2,000 Oracle questions and oversees database management within the U.S. Government. Slightwv

sdstuber

A regular presenter at the Collaborate conference, Oracle developer sdstuber is a top expert in PL/SQL and Oracle 9, 10 and 11. sdstuber

Testimonials

What users are saying about our experts

"The Oracle gurus provide answers, solutions and valuable workarounds"

User: schwertner

"Wow! Excellent, valuable explanation. Hats off to you"

User: aseshu70

"Solution worked fantastic and performs excellent! Thanks heaps"

User: klausbrandlhuber

Top Experts

  1. sdstuber

    2,000

    0 points yesterday

    Profile

BrowseBecome an Expert