using condition on more than one pl sql blocks
Is it possible to use one condition on more than one pl sql blocks
instead of repeating some condition in all blocks ?
for example something like this :
BEGIN
select user_id from users
if :app_user_id = user_id
then do the bottom blocks
begin
end ;
begin
end ;
begin
end ;
END ;
oracle plsql
edited Nov 24 '18 at 18:14
Mihai Chelaru
2,212101122
add a comment |
Is it possible to use one condition on more than one pl sql blocks
instead of repeating some condition in all blocks ?
for example something like this :
BEGIN
select user_id from users
if :app_user_id = user_id
then do the bottom blocks
begin
end ;
begin
end ;
begin
end ;
END ;
oracle plsql
edited Nov 24 '18 at 18:14
Mihai Chelaru
2,212101122
Maybe nested blocks? plsqltutorial.com/plsql-nested-block
– jdv
Nov 14 '18 at 17:17
It would be helpful to have a bit more detail about what your blocks do - why you have separate blocks if the processing is related (which having one controlling condition suggests).
– APC
Nov 14 '18 at 20:24
add a comment |
Is it possible to use one condition on more than one pl sql blocks
instead of repeating some condition in all blocks ?
for example something like this :
BEGIN
select user_id from users
if :app_user_id = user_id
then do the bottom blocks
begin
end ;
begin
end ;
begin
end ;
END ;
oracle plsql
edited Nov 24 '18 at 18:14
Mihai Chelaru
2,212101122
Is it possible to use one condition on more than one pl sql blocks
instead of repeating some condition in all blocks ?
for example something like this :
BEGIN
select user_id from users
if :app_user_id = user_id
then do the bottom blocks
begin
end ;
begin
end ;
begin
end ;
END ;
oracle plsql
oracle plsql
edited Nov 24 '18 at 18:14
Mihai Chelaru
2,212101122
edited Nov 24 '18 at 18:14
Mihai Chelaru
2,212101122
edited Nov 24 '18 at 18:14
Mihai Chelaru
2,212101122
edited Nov 24 '18 at 18:14
Mihai Chelaru
2,212101122
edited Nov 24 '18 at 18:14
Mihai Chelaru
2,212101122
2,212101122
asked Nov 14 '18 at 16:46
user9925017
Maybe nested blocks? plsqltutorial.com/plsql-nested-block
– jdv
Nov 14 '18 at 17:17
It would be helpful to have a bit more detail about what your blocks do - why you have separate blocks if the processing is related (which having one controlling condition suggests).
– APC
Nov 14 '18 at 20:24
add a comment |
Maybe nested blocks? plsqltutorial.com/plsql-nested-block
– jdv
Nov 14 '18 at 17:17
It would be helpful to have a bit more detail about what your blocks do - why you have separate blocks if the processing is related (which having one controlling condition suggests).
– APC
Nov 14 '18 at 20:24
Maybe nested blocks? plsqltutorial.com/plsql-nested-block
– jdv
Nov 14 '18 at 17:17
Maybe nested blocks? plsqltutorial.com/plsql-nested-block
– jdv
Nov 14 '18 at 17:17
It would be helpful to have a bit more detail about what your blocks do - why you have separate blocks if the processing is related (which having one controlling condition suggests).
– APC
Nov 14 '18 at 20:24
It would be helpful to have a bit more detail about what your blocks do - why you have separate blocks if the processing is related (which having one controlling condition suggests).
– APC
Nov 14 '18 at 20:24
add a comment |
2 Answers
2
active
oldest
votes
As per my understanding of the question, you need to check a condition at different points in your code.
You could put that one condition in a procedure/function (depending upon your code) and execute the same rather than putting down those conditions again and again.
Please correct me if my understanding is wrong.
answered Nov 14 '18 at 19:01
Namandeep_KaurNamandeep_Kaur
11017
add a comment |
It is possible, why wouldn't it be?
I don't know how wise it is (what you accomplish with two consecutive execution blocks at the same level, which you couldn't accomplish in a single block instead), but possible it is. For example:
begin
if 3 > 1 then
begin
dbms_output.put_line('First line');
end;
begin
dbms_output.put_line('Second line');
end;
end if;
end;
/
Output (obviously, SET SERVEROUTPUT ON first, if not already on):
First line
Second line
PL/SQL procedure successfully completed.
answered Nov 14 '18 at 22:57
mathguymathguy
26.3k51736
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%2f53305071%2fusing-condition-on-more-than-one-pl-sql-blocks%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
As per my understanding of the question, you need to check a condition at different points in your code.
You could put that one condition in a procedure/function (depending upon your code) and execute the same rather than putting down those conditions again and again.
Please correct me if my understanding is wrong.
answered Nov 14 '18 at 19:01
Namandeep_KaurNamandeep_Kaur
11017
add a comment |
As per my understanding of the question, you need to check a condition at different points in your code.
You could put that one condition in a procedure/function (depending upon your code) and execute the same rather than putting down those conditions again and again.
Please correct me if my understanding is wrong.
answered Nov 14 '18 at 19:01
Namandeep_KaurNamandeep_Kaur
11017
add a comment |
As per my understanding of the question, you need to check a condition at different points in your code.
You could put that one condition in a procedure/function (depending upon your code) and execute the same rather than putting down those conditions again and again.
Please correct me if my understanding is wrong.
answered Nov 14 '18 at 19:01
Namandeep_KaurNamandeep_Kaur
11017
As per my understanding of the question, you need to check a condition at different points in your code.
You could put that one condition in a procedure/function (depending upon your code) and execute the same rather than putting down those conditions again and again.
Please correct me if my understanding is wrong.
answered Nov 14 '18 at 19:01
Namandeep_KaurNamandeep_Kaur
11017
answered Nov 14 '18 at 19:01
Namandeep_KaurNamandeep_Kaur
11017
answered Nov 14 '18 at 19:01
Namandeep_KaurNamandeep_Kaur
11017
answered Nov 14 '18 at 19:01
Namandeep_KaurNamandeep_Kaur
11017
11017
add a comment |
add a comment |
It is possible, why wouldn't it be?
I don't know how wise it is (what you accomplish with two consecutive execution blocks at the same level, which you couldn't accomplish in a single block instead), but possible it is. For example:
begin
if 3 > 1 then
begin
dbms_output.put_line('First line');
end;
begin
dbms_output.put_line('Second line');
end;
end if;
end;
/
Output (obviously, SET SERVEROUTPUT ON first, if not already on):
First line
Second line
PL/SQL procedure successfully completed.
answered Nov 14 '18 at 22:57
mathguymathguy
26.3k51736
add a comment |
It is possible, why wouldn't it be?
I don't know how wise it is (what you accomplish with two consecutive execution blocks at the same level, which you couldn't accomplish in a single block instead), but possible it is. For example:
begin
if 3 > 1 then
begin
dbms_output.put_line('First line');
end;
begin
dbms_output.put_line('Second line');
end;
end if;
end;
/
Output (obviously, SET SERVEROUTPUT ON first, if not already on):
First line
Second line
PL/SQL procedure successfully completed.
answered Nov 14 '18 at 22:57
mathguymathguy
26.3k51736
add a comment |
It is possible, why wouldn't it be?
I don't know how wise it is (what you accomplish with two consecutive execution blocks at the same level, which you couldn't accomplish in a single block instead), but possible it is. For example:
begin
if 3 > 1 then
begin
dbms_output.put_line('First line');
end;
begin
dbms_output.put_line('Second line');
end;
end if;
end;
/
Output (obviously, SET SERVEROUTPUT ON first, if not already on):
First line
Second line
PL/SQL procedure successfully completed.
answered Nov 14 '18 at 22:57
mathguymathguy
26.3k51736
It is possible, why wouldn't it be?
I don't know how wise it is (what you accomplish with two consecutive execution blocks at the same level, which you couldn't accomplish in a single block instead), but possible it is. For example:
begin
if 3 > 1 then
begin
dbms_output.put_line('First line');
end;
begin
dbms_output.put_line('Second line');
end;
end if;
end;
/
Output (obviously, SET SERVEROUTPUT ON first, if not already on):
First line
Second line
PL/SQL procedure successfully completed.
answered Nov 14 '18 at 22:57
mathguymathguy
26.3k51736
answered Nov 14 '18 at 22:57
mathguymathguy
26.3k51736
answered Nov 14 '18 at 22:57
mathguymathguy
26.3k51736
answered Nov 14 '18 at 22:57
mathguymathguy
26.3k51736
26.3k51736
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.
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%2f53305071%2fusing-condition-on-more-than-one-pl-sql-blocks%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
Maybe nested blocks? plsqltutorial.com/plsql-nested-block
– jdv
Nov 14 '18 at 17:17
It would be helpful to have a bit more detail about what your blocks do - why you have separate blocks if the processing is related (which having one controlling condition suggests).
– APC
Nov 14 '18 at 20:24