how to create an explain plan for the below query? I'm getting ORA-00900: invalid SQL statement error
I'm getting ORA-00900: invalid SQL statement error when i tried. but the sql query is running fine without explain.
Query: create or replace view TaskView as
select T1.PersonID,T2.ID ,T2.Task from Table1 T1,Table2 T2
where T1.TaskID=T2.ID;
oracle-11g-r2 explain
asked 18 mins ago
Neethu BennyNeethu Benny
1
New contributor
Neethu Benny is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I'm getting ORA-00900: invalid SQL statement error when i tried. but the sql query is running fine without explain.
Query: create or replace view TaskView as
select T1.PersonID,T2.ID ,T2.Task from Table1 T1,Table2 T2
where T1.TaskID=T2.ID;
oracle-11g-r2 explain
asked 18 mins ago
Neethu BennyNeethu Benny
1
New contributor
Neethu Benny is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Unrelated, but: you should really stop using those ancient and outdated implicit joins in the WHERE clause and start using the "modern" (introduced 20 years ago) explicit JOIN operator.
– a_horse_with_no_name
15 mins ago
add a comment |
I'm getting ORA-00900: invalid SQL statement error when i tried. but the sql query is running fine without explain.
Query: create or replace view TaskView as
select T1.PersonID,T2.ID ,T2.Task from Table1 T1,Table2 T2
where T1.TaskID=T2.ID;
oracle-11g-r2 explain
asked 18 mins ago
Neethu BennyNeethu Benny
1
New contributor
Neethu Benny is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I'm getting ORA-00900: invalid SQL statement error when i tried. but the sql query is running fine without explain.
Query: create or replace view TaskView as
select T1.PersonID,T2.ID ,T2.Task from Table1 T1,Table2 T2
where T1.TaskID=T2.ID;
oracle-11g-r2 explain
oracle-11g-r2 explain
asked 18 mins ago
Neethu BennyNeethu Benny
1
New contributor
Neethu Benny is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 18 mins ago
Neethu BennyNeethu Benny
1
New contributor
Neethu Benny is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 18 mins ago
Neethu BennyNeethu Benny
1
New contributor
Neethu Benny is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 18 mins ago
Neethu BennyNeethu Benny
1
asked 18 mins ago
Neethu BennyNeethu Benny
1
1
New contributor
Neethu Benny is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Neethu Benny is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Neethu Benny is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Unrelated, but: you should really stop using those ancient and outdated implicit joins in the WHERE clause and start using the "modern" (introduced 20 years ago) explicit JOIN operator.
– a_horse_with_no_name
15 mins ago
add a comment |
Unrelated, but: you should really stop using those ancient and outdated implicit joins in the WHERE clause and start using the "modern" (introduced 20 years ago) explicit JOIN operator.
– a_horse_with_no_name
15 mins ago
Unrelated, but: you should really stop using those ancient and outdated implicit joins in the WHERE clause and start using the "modern" (introduced 20 years ago) explicit JOIN operator.
– a_horse_with_no_name
15 mins ago
Unrelated, but: you should really stop using those ancient and outdated implicit joins in the WHERE clause and start using the "modern" (introduced 20 years ago) explicit JOIN operator.
– a_horse_with_no_name
15 mins ago
add a comment |
1 Answer
1
active
oldest
votes
A CREATE VIEW statement has no execution plan as the SELECT will not be evaluated when you create the view. You need to first create the view, then run EXPLAIN on a query using the view:
create or replace view TaskView
as
select T1.PersonID,T2.ID ,T2.Task
from Table1 T1,Table2 T2
where T1.TaskID=T2.ID;
Then
explain plan
set statement_id = 'TASK'
select *
from taskview;
or simply explain the underlying query:
explain plan
set statement_id = 'TASK'
select T1.PersonID,T2.ID ,T2.Task
from Table1 T1,Table2 T2
where T1.TaskID=T2.ID;
answered 16 mins ago
a_horse_with_no_namea_horse_with_no_name
39.1k775112
thanks for your guiding. it worked without any error. can't we try the way i tried? is this the only way for this?
– Neethu Benny
8 mins ago
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
});
}
});
Neethu Benny is a new contributor. Be nice, and check out our Code of Conduct.
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%2fdba.stackexchange.com%2fquestions%2f227828%2fhow-to-create-an-explain-plan-for-the-below-query-im-getting-ora-00900-invali%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
A CREATE VIEW statement has no execution plan as the SELECT will not be evaluated when you create the view. You need to first create the view, then run EXPLAIN on a query using the view:
create or replace view TaskView
as
select T1.PersonID,T2.ID ,T2.Task
from Table1 T1,Table2 T2
where T1.TaskID=T2.ID;
Then
explain plan
set statement_id = 'TASK'
select *
from taskview;
or simply explain the underlying query:
explain plan
set statement_id = 'TASK'
select T1.PersonID,T2.ID ,T2.Task
from Table1 T1,Table2 T2
where T1.TaskID=T2.ID;
answered 16 mins ago
a_horse_with_no_namea_horse_with_no_name
39.1k775112
thanks for your guiding. it worked without any error. can't we try the way i tried? is this the only way for this?
– Neethu Benny
8 mins ago
add a comment |
A CREATE VIEW statement has no execution plan as the SELECT will not be evaluated when you create the view. You need to first create the view, then run EXPLAIN on a query using the view:
create or replace view TaskView
as
select T1.PersonID,T2.ID ,T2.Task
from Table1 T1,Table2 T2
where T1.TaskID=T2.ID;
Then
explain plan
set statement_id = 'TASK'
select *
from taskview;
or simply explain the underlying query:
explain plan
set statement_id = 'TASK'
select T1.PersonID,T2.ID ,T2.Task
from Table1 T1,Table2 T2
where T1.TaskID=T2.ID;
answered 16 mins ago
a_horse_with_no_namea_horse_with_no_name
39.1k775112
thanks for your guiding. it worked without any error. can't we try the way i tried? is this the only way for this?
– Neethu Benny
8 mins ago
add a comment |
A CREATE VIEW statement has no execution plan as the SELECT will not be evaluated when you create the view. You need to first create the view, then run EXPLAIN on a query using the view:
create or replace view TaskView
as
select T1.PersonID,T2.ID ,T2.Task
from Table1 T1,Table2 T2
where T1.TaskID=T2.ID;
Then
explain plan
set statement_id = 'TASK'
select *
from taskview;
or simply explain the underlying query:
explain plan
set statement_id = 'TASK'
select T1.PersonID,T2.ID ,T2.Task
from Table1 T1,Table2 T2
where T1.TaskID=T2.ID;
answered 16 mins ago
a_horse_with_no_namea_horse_with_no_name
39.1k775112
A CREATE VIEW statement has no execution plan as the SELECT will not be evaluated when you create the view. You need to first create the view, then run EXPLAIN on a query using the view:
create or replace view TaskView
as
select T1.PersonID,T2.ID ,T2.Task
from Table1 T1,Table2 T2
where T1.TaskID=T2.ID;
Then
explain plan
set statement_id = 'TASK'
select *
from taskview;
or simply explain the underlying query:
explain plan
set statement_id = 'TASK'
select T1.PersonID,T2.ID ,T2.Task
from Table1 T1,Table2 T2
where T1.TaskID=T2.ID;
answered 16 mins ago
a_horse_with_no_namea_horse_with_no_name
39.1k775112
edited 6 mins ago
answered 16 mins ago
a_horse_with_no_namea_horse_with_no_name
39.1k775112
answered 16 mins ago
a_horse_with_no_namea_horse_with_no_name
39.1k775112
answered 16 mins ago
a_horse_with_no_namea_horse_with_no_name
39.1k775112
39.1k775112
thanks for your guiding. it worked without any error. can't we try the way i tried? is this the only way for this?
– Neethu Benny
8 mins ago
add a comment |
thanks for your guiding. it worked without any error. can't we try the way i tried? is this the only way for this?
– Neethu Benny
8 mins ago
thanks for your guiding. it worked without any error. can't we try the way i tried? is this the only way for this?
– Neethu Benny
8 mins ago
thanks for your guiding. it worked without any error. can't we try the way i tried? is this the only way for this?
– Neethu Benny
8 mins ago
add a comment |
Neethu Benny is a new contributor. Be nice, and check out our Code of Conduct.
Neethu Benny is a new contributor. Be nice, and check out our Code of Conduct.
Neethu Benny is a new contributor. Be nice, and check out our Code of Conduct.
Neethu Benny is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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%2fdba.stackexchange.com%2fquestions%2f227828%2fhow-to-create-an-explain-plan-for-the-below-query-im-getting-ora-00900-invali%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
Unrelated, but: you should really stop using those ancient and outdated implicit joins in the WHERE clause and start using the "modern" (introduced 20 years ago) explicit JOIN operator.
– a_horse_with_no_name
15 mins ago