Define variables in SQL Developer
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
Hi I am quite new to Oracle SQL Developer. It looks like a very simple thing, but it is driving me nuts.
DEFINE START_DATE = "to_date('03/01/2018', 'dd/mm/yyyy')";
DEFINE END_DATE = "to_date('01/06/2018', 'dd/mm/yyyy')";
SELECT
SOMETABLE.JOB_BASE_NUM,
SOMETABLE.CUSTOMER_CODE
FROM
SOMETABLE
WHERE
SOMETABLE.WORK_END_DATE>= &START_DATE
AND SOMETABLE.WORK_END_DATE < &END_DATE;
It always ask me to Enter value for END_DATE:
Can someone help please? Thank you.
Edit:
I run this in SQL Developer:
sql oracle oracle-sqldeveloper
add a comment |
Hi I am quite new to Oracle SQL Developer. It looks like a very simple thing, but it is driving me nuts.
DEFINE START_DATE = "to_date('03/01/2018', 'dd/mm/yyyy')";
DEFINE END_DATE = "to_date('01/06/2018', 'dd/mm/yyyy')";
SELECT
SOMETABLE.JOB_BASE_NUM,
SOMETABLE.CUSTOMER_CODE
FROM
SOMETABLE
WHERE
SOMETABLE.WORK_END_DATE>= &START_DATE
AND SOMETABLE.WORK_END_DATE < &END_DATE;
It always ask me to Enter value for END_DATE:
Can someone help please? Thank you.
Edit:
I run this in SQL Developer:
sql oracle oracle-sqldeveloper
1
Are you running all the Lines in the script as one batch or just SELECT?
– rs.
Nov 16 '18 at 19:39
One batch in SQL developer
– Heisenberg
Nov 16 '18 at 19:47
By the way, Oracle supports the ANSI standard syntax for date literals, e.g.date '2018-01-03'
– William Robertson
Nov 17 '18 at 10:50
add a comment |
Hi I am quite new to Oracle SQL Developer. It looks like a very simple thing, but it is driving me nuts.
DEFINE START_DATE = "to_date('03/01/2018', 'dd/mm/yyyy')";
DEFINE END_DATE = "to_date('01/06/2018', 'dd/mm/yyyy')";
SELECT
SOMETABLE.JOB_BASE_NUM,
SOMETABLE.CUSTOMER_CODE
FROM
SOMETABLE
WHERE
SOMETABLE.WORK_END_DATE>= &START_DATE
AND SOMETABLE.WORK_END_DATE < &END_DATE;
It always ask me to Enter value for END_DATE:
Can someone help please? Thank you.
Edit:
I run this in SQL Developer:
sql oracle oracle-sqldeveloper
Hi I am quite new to Oracle SQL Developer. It looks like a very simple thing, but it is driving me nuts.
DEFINE START_DATE = "to_date('03/01/2018', 'dd/mm/yyyy')";
DEFINE END_DATE = "to_date('01/06/2018', 'dd/mm/yyyy')";
SELECT
SOMETABLE.JOB_BASE_NUM,
SOMETABLE.CUSTOMER_CODE
FROM
SOMETABLE
WHERE
SOMETABLE.WORK_END_DATE>= &START_DATE
AND SOMETABLE.WORK_END_DATE < &END_DATE;
It always ask me to Enter value for END_DATE:
Can someone help please? Thank you.
Edit:
I run this in SQL Developer:
sql oracle oracle-sqldeveloper
sql oracle oracle-sqldeveloper
edited Nov 17 '18 at 10:47
William Robertson
8,55232233
8,55232233
asked Nov 16 '18 at 19:25
HeisenbergHeisenberg
296213
296213
1
Are you running all the Lines in the script as one batch or just SELECT?
– rs.
Nov 16 '18 at 19:39
One batch in SQL developer
– Heisenberg
Nov 16 '18 at 19:47
By the way, Oracle supports the ANSI standard syntax for date literals, e.g.date '2018-01-03'
– William Robertson
Nov 17 '18 at 10:50
add a comment |
1
Are you running all the Lines in the script as one batch or just SELECT?
– rs.
Nov 16 '18 at 19:39
One batch in SQL developer
– Heisenberg
Nov 16 '18 at 19:47
By the way, Oracle supports the ANSI standard syntax for date literals, e.g.date '2018-01-03'
– William Robertson
Nov 17 '18 at 10:50
1
1
Are you running all the Lines in the script as one batch or just SELECT?
– rs.
Nov 16 '18 at 19:39
Are you running all the Lines in the script as one batch or just SELECT?
– rs.
Nov 16 '18 at 19:39
One batch in SQL developer
– Heisenberg
Nov 16 '18 at 19:47
One batch in SQL developer
– Heisenberg
Nov 16 '18 at 19:47
By the way, Oracle supports the ANSI standard syntax for date literals, e.g.
date '2018-01-03'
– William Robertson
Nov 17 '18 at 10:50
By the way, Oracle supports the ANSI standard syntax for date literals, e.g.
date '2018-01-03'
– William Robertson
Nov 17 '18 at 10:50
add a comment |
1 Answer
1
active
oldest
votes
Remove the semicolon here:
DEFINE START_DATE = "to_date('03/01/2018', 'dd/mm/yyyy')"
DEFINE END_DATE = "to_date('01/06/2018', 'dd/mm/yyyy')"
The semicolon is separating your define variable from your sql.
Thank you! silly me!
– Heisenberg
Nov 16 '18 at 22:14
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%2f53344181%2fdefine-variables-in-sql-developer%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Remove the semicolon here:
DEFINE START_DATE = "to_date('03/01/2018', 'dd/mm/yyyy')"
DEFINE END_DATE = "to_date('01/06/2018', 'dd/mm/yyyy')"
The semicolon is separating your define variable from your sql.
Thank you! silly me!
– Heisenberg
Nov 16 '18 at 22:14
add a comment |
Remove the semicolon here:
DEFINE START_DATE = "to_date('03/01/2018', 'dd/mm/yyyy')"
DEFINE END_DATE = "to_date('01/06/2018', 'dd/mm/yyyy')"
The semicolon is separating your define variable from your sql.
Thank you! silly me!
– Heisenberg
Nov 16 '18 at 22:14
add a comment |
Remove the semicolon here:
DEFINE START_DATE = "to_date('03/01/2018', 'dd/mm/yyyy')"
DEFINE END_DATE = "to_date('01/06/2018', 'dd/mm/yyyy')"
The semicolon is separating your define variable from your sql.
Remove the semicolon here:
DEFINE START_DATE = "to_date('03/01/2018', 'dd/mm/yyyy')"
DEFINE END_DATE = "to_date('01/06/2018', 'dd/mm/yyyy')"
The semicolon is separating your define variable from your sql.
answered Nov 16 '18 at 22:13
OptimusPrimeOptimusPrime
1419
1419
Thank you! silly me!
– Heisenberg
Nov 16 '18 at 22:14
add a comment |
Thank you! silly me!
– Heisenberg
Nov 16 '18 at 22:14
Thank you! silly me!
– Heisenberg
Nov 16 '18 at 22:14
Thank you! silly me!
– Heisenberg
Nov 16 '18 at 22:14
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%2f53344181%2fdefine-variables-in-sql-developer%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
1
Are you running all the Lines in the script as one batch or just SELECT?
– rs.
Nov 16 '18 at 19:39
One batch in SQL developer
– Heisenberg
Nov 16 '18 at 19:47
By the way, Oracle supports the ANSI standard syntax for date literals, e.g.
date '2018-01-03'
– William Robertson
Nov 17 '18 at 10:50