473,657 Members | 2,727 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Simple SQL to display text

I was wondering - is there some part of sql that can display text?
I wanted to add simple instruictions to the beginning of an sql script
so the user understands what they're entering into the '&value' entry
of the SELECT portion of the script.

I know that anything with REM in the beginning is simply ignored.

Thanks for your help.
Jul 19 '05 #1
3 11242

"Joe Christl" <jc******@zdnet mail.com> wrote in message
news:e9******** *************** ***@posting.goo gle.com...
| I was wondering - is there some part of sql that can display text?
| I wanted to add simple instruictions to the beginning of an sql script
| so the user understands what they're entering into the '&value' entry
| of the SELECT portion of the script.
|
| I know that anything with REM in the beginning is simply ignored.
|
| Thanks for your help.

Not SQL, you're actually asking about SQL*Plus (Oracle very basic UI tool)

PROMPT for one line

DOC for multiple lines (terminate with #) -- or use a c-style multiple line
comment (equivalent of DOC...#)
lots more good stuff in the SQL*Plus manual! -- you might also want to check
out the ACCEPT statement

;-{ mcs

Jul 19 '05 #2
jc******@zdnetm ail.com (Joe Christl) wrote in message news:<e9******* *************** ****@posting.go ogle.com>...
I was wondering - is there some part of sql that can display text?
I wanted to add simple instruictions to the beginning of an sql script
so the user understands what they're entering into the '&value' entry
of the SELECT portion of the script.

I know that anything with REM in the beginning is simply ignored.

Thanks for your help.


If the front-end tool is SQLPlus then look up the prompt command in
the SQLPlus manual. You may also want to look at the accept
statements. Prompt and accept can be combined to ask for and get an
SQLPlus label variable.

HTH -- Mark D Powell --
Jul 19 '05 #3
Yes SQLPlus was what I was talking about.
PROMPT, DOC, & ACCEPT

Thanks Mark and Mark. :)
Jul 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
9647
by: bob | last post by:
Does anyone know if it is possible to display text vertically in HTML? Basically, I want normal text rotated 90 degrees.
1
1895
by: iggie | last post by:
Hello, everyone. How can I display text from another form that currently has the focus. I'm doing a search in sql 2000, to dot it. I call a search form and query my criteria, when it founds the value a display this on a list view. Next, when the user selects the row, I want that to display the information on the main form.
2
13199
by: nsj | last post by:
how to display text in new line in a TextBox in Vb.NET?
3
9494
by: deko | last post by:
I store hyperlinks as text in a table like this: Invoice11-21-2003.pdf#file://P:\Finance\PrefVendors\Receipts\Invoice11-21-20 03.pdf I need to run a report that lists the documents - or whatever the display text of the hyperlink is. As it is now, the entire hyperlink appears in the report - I'm trying to display just the document name.
3
2087
by: Troy Wilson | last post by:
Is there an existing control for Visual Basic that allows me to display text in that control, but also lets me append text to it. The application I have in mind for this control is something like a status page that updates with new information without wiping out the previous info. Thank you.
0
1702
by: yalanue | last post by:
I want to create a combobox with its displaymember populated from a datatable. But once I get it run, the default display member in the combobox is always the first row of the displaymember list. even if I abitrarily set the combobox text to empty string, the value retrieved from the combobox text is still the first row value from the list. How can I set, when I display this combobox, the default display text to be empty, instead of the...
3
1693
by: WebNewbie | last post by:
Hi, please help I've been wrestling with this for a very long time and its not working. I'm trying to display text files from a database when someone selects one or more list items of my listbox. The list box contains names of various professions. The database I'm accessing contains Resumes field, Professions field, and ResumesID field. When a user selects one or more list items, the profession in the Professions field that match the text of the...
5
64214
by: austincollins | last post by:
I have been searching for hours to find a solution to display text rotated at 90 degrees in firefox, and could not find one. css3 and IE has the css command "writing-mode: tb-rl;" but this does not work in firefox. i came to conclusion that SVG is the solution. I have been playing with SVG for few hours now and it is brilliant, you can do graphics and animation like flash but text and javascript based!. anyway check this out, this is one...
3
123
by: Joe Christl | last post by:
I was wondering - is there some part of sql that can display text? I wanted to add simple instruictions to the beginning of an sql script so the user understands what they're entering into the '&value' entry of the SELECT portion of the script. I know that anything with REM in the beginning is simply ignored. Thanks for your help.
0
8394
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8306
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8732
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8503
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
5632
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4152
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4304
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2726
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1955
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.