Cross apply missing keyword
I am writing a query in Oracle(11g):
select DBTM,AVNR from E_MW_01Min_MIT m
cross apply(
select Avnr,XDatum1 from E_MW_01DAY_MEX d
where d.AVnr = m.avnr
and d.XDatum1 = m.DBTM
)
but it gives me the error
ORA-00905: missing keyword
where is the problem?
Thank you
sql oracle
asked Nov 17 '18 at 7:05
nnmmss
1,04742038
add a comment |
I am writing a query in Oracle(11g):
select DBTM,AVNR from E_MW_01Min_MIT m
cross apply(
select Avnr,XDatum1 from E_MW_01DAY_MEX d
where d.AVnr = m.avnr
and d.XDatum1 = m.DBTM
)
but it gives me the error
ORA-00905: missing keyword
where is the problem?
Thank you
sql oracle
asked Nov 17 '18 at 7:05
nnmmss
1,04742038
1
Which version of Oracle are you using?
– APC
Nov 17 '18 at 7:13
1
The OUTER APPLY/CROSS APPLY constructs are supported in Oracle starting with v.12c
– Used_By_Already
Nov 17 '18 at 7:26
add a comment |
I am writing a query in Oracle(11g):
select DBTM,AVNR from E_MW_01Min_MIT m
cross apply(
select Avnr,XDatum1 from E_MW_01DAY_MEX d
where d.AVnr = m.avnr
and d.XDatum1 = m.DBTM
)
but it gives me the error
ORA-00905: missing keyword
where is the problem?
Thank you
sql oracle
asked Nov 17 '18 at 7:05
nnmmss
1,04742038
I am writing a query in Oracle(11g):
select DBTM,AVNR from E_MW_01Min_MIT m
cross apply(
select Avnr,XDatum1 from E_MW_01DAY_MEX d
where d.AVnr = m.avnr
and d.XDatum1 = m.DBTM
)
but it gives me the error
ORA-00905: missing keyword
where is the problem?
Thank you
sql oracle
sql oracle
asked Nov 17 '18 at 7:05
nnmmss
1,04742038
asked Nov 17 '18 at 7:05
nnmmss
1,04742038
edited Nov 17 '18 at 11:22
asked Nov 17 '18 at 7:05
nnmmss
1,04742038
asked Nov 17 '18 at 7:05
nnmmss
1,04742038
asked Nov 17 '18 at 7:05
nnmmss
1,04742038
1,04742038
1
Which version of Oracle are you using?
– APC
Nov 17 '18 at 7:13
1
The OUTER APPLY/CROSS APPLY constructs are supported in Oracle starting with v.12c
– Used_By_Already
Nov 17 '18 at 7:26
add a comment |
1
Which version of Oracle are you using?
– APC
Nov 17 '18 at 7:13
1
The OUTER APPLY/CROSS APPLY constructs are supported in Oracle starting with v.12c
– Used_By_Already
Nov 17 '18 at 7:26
1
1
Which version of Oracle are you using?
– APC
Nov 17 '18 at 7:13
Which version of Oracle are you using?
– APC
Nov 17 '18 at 7:13
1
1
The OUTER APPLY/CROSS APPLY constructs are supported in Oracle starting with v.12c
– Used_By_Already
Nov 17 '18 at 7:26
The OUTER APPLY/CROSS APPLY constructs are supported in Oracle starting with v.12c
– Used_By_Already
Nov 17 '18 at 7:26
add a comment |
2 Answers
2
active
oldest
votes
This keywords (CROSS APPLY or OUTER APPLY) is introduced in Oracle 12c version.
You can see this link :
cross apply giving missing keyword error
answered Nov 17 '18 at 10:25
Santosh Vishwakarma
756
add a comment |
cross apply is not available in that version of Oracle. Just use join instead:
select m.DBTM, d.AVNR
from E_MW_01Min_MIT m JOIN
E_MW_01DAY_MEX d
ON d.AVnr = m.avnr AND d.XDatum1 = m.DBTM ;
This is actually more easily expressed using JOIN, so I see no advantage to attempting APPLY even if the database does support it.
answered Nov 17 '18 at 12:36
Gordon Linoff
759k35292399
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%2f53349033%2fcross-apply-missing-keyword%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
This keywords (CROSS APPLY or OUTER APPLY) is introduced in Oracle 12c version.
You can see this link :
cross apply giving missing keyword error
answered Nov 17 '18 at 10:25
Santosh Vishwakarma
756
add a comment |
This keywords (CROSS APPLY or OUTER APPLY) is introduced in Oracle 12c version.
You can see this link :
cross apply giving missing keyword error
answered Nov 17 '18 at 10:25
Santosh Vishwakarma
756
add a comment |
This keywords (CROSS APPLY or OUTER APPLY) is introduced in Oracle 12c version.
You can see this link :
cross apply giving missing keyword error
answered Nov 17 '18 at 10:25
Santosh Vishwakarma
756
This keywords (CROSS APPLY or OUTER APPLY) is introduced in Oracle 12c version.
You can see this link :
cross apply giving missing keyword error
answered Nov 17 '18 at 10:25
Santosh Vishwakarma
756
answered Nov 17 '18 at 10:25
Santosh Vishwakarma
756
answered Nov 17 '18 at 10:25
Santosh Vishwakarma
756
answered Nov 17 '18 at 10:25
Santosh Vishwakarma
756
756
add a comment |
add a comment |
cross apply is not available in that version of Oracle. Just use join instead:
select m.DBTM, d.AVNR
from E_MW_01Min_MIT m JOIN
E_MW_01DAY_MEX d
ON d.AVnr = m.avnr AND d.XDatum1 = m.DBTM ;
This is actually more easily expressed using JOIN, so I see no advantage to attempting APPLY even if the database does support it.
answered Nov 17 '18 at 12:36
Gordon Linoff
759k35292399
add a comment |
cross apply is not available in that version of Oracle. Just use join instead:
select m.DBTM, d.AVNR
from E_MW_01Min_MIT m JOIN
E_MW_01DAY_MEX d
ON d.AVnr = m.avnr AND d.XDatum1 = m.DBTM ;
This is actually more easily expressed using JOIN, so I see no advantage to attempting APPLY even if the database does support it.
answered Nov 17 '18 at 12:36
Gordon Linoff
759k35292399
add a comment |
cross apply is not available in that version of Oracle. Just use join instead:
select m.DBTM, d.AVNR
from E_MW_01Min_MIT m JOIN
E_MW_01DAY_MEX d
ON d.AVnr = m.avnr AND d.XDatum1 = m.DBTM ;
This is actually more easily expressed using JOIN, so I see no advantage to attempting APPLY even if the database does support it.
answered Nov 17 '18 at 12:36
Gordon Linoff
759k35292399
cross apply is not available in that version of Oracle. Just use join instead:
select m.DBTM, d.AVNR
from E_MW_01Min_MIT m JOIN
E_MW_01DAY_MEX d
ON d.AVnr = m.avnr AND d.XDatum1 = m.DBTM ;
This is actually more easily expressed using JOIN, so I see no advantage to attempting APPLY even if the database does support it.
answered Nov 17 '18 at 12:36
Gordon Linoff
759k35292399
answered Nov 17 '18 at 12:36
Gordon Linoff
759k35292399
answered Nov 17 '18 at 12:36
Gordon Linoff
759k35292399
answered Nov 17 '18 at 12:36
Gordon Linoff
759k35292399
759k35292399
add a comment |
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53349033%2fcross-apply-missing-keyword%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
Which version of Oracle are you using?
– APC
Nov 17 '18 at 7:13
1
The OUTER APPLY/CROSS APPLY constructs are supported in Oracle starting with v.12c
– Used_By_Already
Nov 17 '18 at 7:26