Mixing
How to spool or echo comments Oracle
I'm new to oracle and trying to spool comments/line into file using a bash script.but only query output is getting spooled not the comment(Total No Of Students in Class).
Below is the script which i am using:
sqlplus -s test/test<<EOF
set echo on
spool abc.txt
--------------------------------------
--Total No Of Students in Class.
--------------------------------------
select id ||','|| name from students ;
EOF
Expected output:
--------------------------------------
--Total No Of Students in Class.
--------------------------------------
1,joe
2,Tom
3,Jim
oracle shell sqlplus
asked Jan 1 at 14:02
mahimahi
173
add a comment |
I'm new to oracle and trying to spool comments/line into file using a bash script.but only query output is getting spooled not the comment(Total No Of Students in Class).
Below is the script which i am using:
sqlplus -s test/test<<EOF
set echo on
spool abc.txt
--------------------------------------
--Total No Of Students in Class.
--------------------------------------
select id ||','|| name from students ;
EOF
Expected output:
--------------------------------------
--Total No Of Students in Class.
--------------------------------------
1,joe
2,Tom
3,Jim
oracle shell sqlplus
asked Jan 1 at 14:02
mahimahi
173
add a comment |
I'm new to oracle and trying to spool comments/line into file using a bash script.but only query output is getting spooled not the comment(Total No Of Students in Class).
Below is the script which i am using:
sqlplus -s test/test<<EOF
set echo on
spool abc.txt
--------------------------------------
--Total No Of Students in Class.
--------------------------------------
select id ||','|| name from students ;
EOF
Expected output:
--------------------------------------
--Total No Of Students in Class.
--------------------------------------
1,joe
2,Tom
3,Jim
oracle shell sqlplus
asked Jan 1 at 14:02
mahimahi
173
I'm new to oracle and trying to spool comments/line into file using a bash script.but only query output is getting spooled not the comment(Total No Of Students in Class).
Below is the script which i am using:
sqlplus -s test/test<<EOF
set echo on
spool abc.txt
--------------------------------------
--Total No Of Students in Class.
--------------------------------------
select id ||','|| name from students ;
EOF
Expected output:
--------------------------------------
--Total No Of Students in Class.
--------------------------------------
1,joe
2,Tom
3,Jim
oracle shell sqlplus
oracle shell sqlplus
asked Jan 1 at 14:02
mahimahi
173
asked Jan 1 at 14:02
mahimahi
173
asked Jan 1 at 14:02
mahimahi
173
asked Jan 1 at 14:02
mahimahi
173
asked Jan 1 at 14:02
mahimahi
173
173
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
In Oracle -- is comment syntax, so SQL*Plus ignores this:
--------------------------------------
--Total No Of Students in Class.
--------------------------------------
To display it you need to use the SQL*Plus `prompt command:
prompt --------------------------------------
prompt --Total No Of Students in Class.
prompt --------------------------------------
Also you should end your SQL*Plus script with spool off.
answered Jan 1 at 14:06
APCAPC
120k15118230
add a comment |
you cannot spool comments into file. but Inside PL/SQL procedure, you can use
DBMS_OUTPUT.PUT_LINE('My comment Line');
or in SqlPlus
prompt My Comment Line
answered Jan 1 at 14:06
SimonareSimonare
15k11840
DBMS_OUTPUT.PUT_LINE()is a PL/SQL command, so it's not going to be any use in a pure SQL context.
– APC
Jan 1 at 14:09
I mentioned it thank you
– Simonare
Jan 1 at 14:10
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53996088%2fhow-to-spool-or-echo-comments-oracle%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
In Oracle -- is comment syntax, so SQL*Plus ignores this:
--------------------------------------
--Total No Of Students in Class.
--------------------------------------
To display it you need to use the SQL*Plus `prompt command:
prompt --------------------------------------
prompt --Total No Of Students in Class.
prompt --------------------------------------
Also you should end your SQL*Plus script with spool off.
answered Jan 1 at 14:06
APCAPC
120k15118230
add a comment |
In Oracle -- is comment syntax, so SQL*Plus ignores this:
--------------------------------------
--Total No Of Students in Class.
--------------------------------------
To display it you need to use the SQL*Plus `prompt command:
prompt --------------------------------------
prompt --Total No Of Students in Class.
prompt --------------------------------------
Also you should end your SQL*Plus script with spool off.
answered Jan 1 at 14:06
APCAPC
120k15118230
add a comment |
In Oracle -- is comment syntax, so SQL*Plus ignores this:
--------------------------------------
--Total No Of Students in Class.
--------------------------------------
To display it you need to use the SQL*Plus `prompt command:
prompt --------------------------------------
prompt --Total No Of Students in Class.
prompt --------------------------------------
Also you should end your SQL*Plus script with spool off.
answered Jan 1 at 14:06
APCAPC
120k15118230
In Oracle -- is comment syntax, so SQL*Plus ignores this:
--------------------------------------
--Total No Of Students in Class.
--------------------------------------
To display it you need to use the SQL*Plus `prompt command:
prompt --------------------------------------
prompt --Total No Of Students in Class.
prompt --------------------------------------
Also you should end your SQL*Plus script with spool off.
answered Jan 1 at 14:06
APCAPC
120k15118230
answered Jan 1 at 14:06
APCAPC
120k15118230
answered Jan 1 at 14:06
APCAPC
120k15118230
answered Jan 1 at 14:06
APCAPC
120k15118230
120k15118230
add a comment |
add a comment |
you cannot spool comments into file. but Inside PL/SQL procedure, you can use
DBMS_OUTPUT.PUT_LINE('My comment Line');
or in SqlPlus
prompt My Comment Line
answered Jan 1 at 14:06
SimonareSimonare
15k11840
DBMS_OUTPUT.PUT_LINE()is a PL/SQL command, so it's not going to be any use in a pure SQL context.
– APC
Jan 1 at 14:09
I mentioned it thank you
– Simonare
Jan 1 at 14:10
add a comment |
you cannot spool comments into file. but Inside PL/SQL procedure, you can use
DBMS_OUTPUT.PUT_LINE('My comment Line');
or in SqlPlus
prompt My Comment Line
answered Jan 1 at 14:06
SimonareSimonare
15k11840
DBMS_OUTPUT.PUT_LINE()is a PL/SQL command, so it's not going to be any use in a pure SQL context.
– APC
Jan 1 at 14:09
I mentioned it thank you
– Simonare
Jan 1 at 14:10
add a comment |
you cannot spool comments into file. but Inside PL/SQL procedure, you can use
DBMS_OUTPUT.PUT_LINE('My comment Line');
or in SqlPlus
prompt My Comment Line
answered Jan 1 at 14:06
SimonareSimonare
15k11840
you cannot spool comments into file. but Inside PL/SQL procedure, you can use
DBMS_OUTPUT.PUT_LINE('My comment Line');
or in SqlPlus
prompt My Comment Line
answered Jan 1 at 14:06
SimonareSimonare
15k11840
edited Jan 1 at 14:10
answered Jan 1 at 14:06
SimonareSimonare
15k11840
answered Jan 1 at 14:06
SimonareSimonare
15k11840
answered Jan 1 at 14:06
SimonareSimonare
15k11840
15k11840
DBMS_OUTPUT.PUT_LINE()is a PL/SQL command, so it's not going to be any use in a pure SQL context.
– APC
Jan 1 at 14:09
I mentioned it thank you
– Simonare
Jan 1 at 14:10
add a comment |
DBMS_OUTPUT.PUT_LINE()is a PL/SQL command, so it's not going to be any use in a pure SQL context.
– APC
Jan 1 at 14:09
I mentioned it thank you
– Simonare
Jan 1 at 14:10
DBMS_OUTPUT.PUT_LINE() is a PL/SQL command, so it's not going to be any use in a pure SQL context.– APC
Jan 1 at 14:09
DBMS_OUTPUT.PUT_LINE() is a PL/SQL command, so it's not going to be any use in a pure SQL context.– APC
Jan 1 at 14:09
I mentioned it thank you
– Simonare
Jan 1 at 14:10
I mentioned it thank you
– Simonare
Jan 1 at 14:10
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53996088%2fhow-to-spool-or-echo-comments-oracle%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
