how to create an explain plan for the below query? I'm getting ORA-00900: invalid SQL statement error












0















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;



error










share|improve this question







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
















0















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;



error










share|improve this question







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














0












0








0








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;



error










share|improve this question







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;



error







oracle-11g-r2 explain






share|improve this question







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.











share|improve this question







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.









share|improve this question




share|improve this question






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




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



















  • 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










1 Answer
1






active

oldest

votes


















0














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;





share|improve this answer


























  • 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













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.










draft saved

draft discarded


















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









0














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;





share|improve this answer


























  • 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


















0














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;





share|improve this answer


























  • 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
















0












0








0







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;





share|improve this answer















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;






share|improve this answer














share|improve this answer



share|improve this answer








edited 6 mins ago

























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





















  • 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












Neethu Benny is a new contributor. Be nice, and check out our Code of Conduct.










draft saved

draft discarded


















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.




draft saved


draft discarded














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





















































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







Popular posts from this blog

Liste der Baudenkmale in Friedland (Mecklenburg)

Single-Malt-Whisky

Czorneboh