using condition on more than one pl sql blocks
up vote
2
down vote
favorite
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 at 18:14
Mihai Chelaru
2,10071022
asked Nov 14 at 16:46
Phillip
112
add a comment |
up vote
2
down vote
favorite
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 at 18:14
Mihai Chelaru
2,10071022
asked Nov 14 at 16:46
Phillip
112
Maybe nested blocks? plsqltutorial.com/plsql-nested-block
– jdv
Nov 14 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 at 20:24
add a comment |
up vote
2
down vote
favorite
up vote
2
down vote
favorite
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 at 18:14
Mihai Chelaru
2,10071022
asked Nov 14 at 16:46
Phillip
112
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 at 18:14
Mihai Chelaru
2,10071022
asked Nov 14 at 16:46
Phillip
112
edited Nov 24 at 18:14
Mihai Chelaru
2,10071022
asked Nov 14 at 16:46
Phillip
112
edited Nov 24 at 18:14
Mihai Chelaru
2,10071022
edited Nov 24 at 18:14
Mihai Chelaru
2,10071022
edited Nov 24 at 18:14
Mihai Chelaru
2,10071022
2,10071022
asked Nov 14 at 16:46
Phillip
112
asked Nov 14 at 16:46
Phillip
112
asked Nov 14 at 16:46
Phillip
112
112
Maybe nested blocks? plsqltutorial.com/plsql-nested-block
– jdv
Nov 14 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 at 20:24
add a comment |
Maybe nested blocks? plsqltutorial.com/plsql-nested-block
– jdv
Nov 14 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 at 20:24
Maybe nested blocks? plsqltutorial.com/plsql-nested-block
– jdv
Nov 14 at 17:17
Maybe nested blocks? plsqltutorial.com/plsql-nested-block
– jdv
Nov 14 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 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 at 20:24
add a comment |
2 Answers
2
active
oldest
votes
up vote
0
down vote
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 at 19:01
Namandeep_Kaur
9017
add a comment |
up vote
0
down vote
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 at 22:57
mathguy
25.6k41536
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
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 at 19:01
Namandeep_Kaur
9017
add a comment |
up vote
0
down vote
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 at 19:01
Namandeep_Kaur
9017
add a comment |
up vote
0
down vote
up vote
0
down vote
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 at 19:01
Namandeep_Kaur
9017
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 at 19:01
Namandeep_Kaur
9017
answered Nov 14 at 19:01
Namandeep_Kaur
9017
answered Nov 14 at 19:01
Namandeep_Kaur
9017
answered Nov 14 at 19:01
Namandeep_Kaur
9017
9017
add a comment |
add a comment |
up vote
0
down vote
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 at 22:57
mathguy
25.6k41536
add a comment |
up vote
0
down vote
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 at 22:57
mathguy
25.6k41536
add a comment |
up vote
0
down vote
up vote
0
down vote
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 at 22:57
mathguy
25.6k41536
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 at 22:57
mathguy
25.6k41536
answered Nov 14 at 22:57
mathguy
25.6k41536
answered Nov 14 at 22:57
mathguy
25.6k41536
answered Nov 14 at 22:57
mathguy
25.6k41536
25.6k41536
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%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 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 at 20:24