Oracle plsql store 2 values from same column in 2 different variable
up vote
0
down vote
favorite
My table tbl has values something like this:
+-------+
|name |
+-------+
|n1 |
|n2 |
+-------+
What I want is to have a single query that store the values n1 and n2 into two different variable in the same time.
declare
val1 varchar2(2);
val2 varchar2(2);
begin
select name
into --val1,val2
from tbl
where ...
end;
val1 value must be n1 and val2 must be n2
sql oracle plsql
edited Nov 19 at 10:02
Barbaros Özhan
11.4k71530
asked Nov 19 at 8:21
Miracle
27319
add a comment |
up vote
0
down vote
favorite
My table tbl has values something like this:
+-------+
|name |
+-------+
|n1 |
|n2 |
+-------+
What I want is to have a single query that store the values n1 and n2 into two different variable in the same time.
declare
val1 varchar2(2);
val2 varchar2(2);
begin
select name
into --val1,val2
from tbl
where ...
end;
val1 value must be n1 and val2 must be n2
sql oracle plsql
edited Nov 19 at 10:02
Barbaros Özhan
11.4k71530
asked Nov 19 at 8:21
Miracle
27319
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
My table tbl has values something like this:
+-------+
|name |
+-------+
|n1 |
|n2 |
+-------+
What I want is to have a single query that store the values n1 and n2 into two different variable in the same time.
declare
val1 varchar2(2);
val2 varchar2(2);
begin
select name
into --val1,val2
from tbl
where ...
end;
val1 value must be n1 and val2 must be n2
sql oracle plsql
edited Nov 19 at 10:02
Barbaros Özhan
11.4k71530
asked Nov 19 at 8:21
Miracle
27319
My table tbl has values something like this:
+-------+
|name |
+-------+
|n1 |
|n2 |
+-------+
What I want is to have a single query that store the values n1 and n2 into two different variable in the same time.
declare
val1 varchar2(2);
val2 varchar2(2);
begin
select name
into --val1,val2
from tbl
where ...
end;
val1 value must be n1 and val2 must be n2
sql oracle plsql
sql oracle plsql
edited Nov 19 at 10:02
Barbaros Özhan
11.4k71530
asked Nov 19 at 8:21
Miracle
27319
edited Nov 19 at 10:02
Barbaros Özhan
11.4k71530
asked Nov 19 at 8:21
Miracle
27319
edited Nov 19 at 10:02
Barbaros Özhan
11.4k71530
edited Nov 19 at 10:02
Barbaros Özhan
11.4k71530
edited Nov 19 at 10:02
Barbaros Özhan
11.4k71530
11.4k71530
asked Nov 19 at 8:21
Miracle
27319
asked Nov 19 at 8:21
Miracle
27319
asked Nov 19 at 8:21
Miracle
27319
27319
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
up vote
2
down vote
accepted
Use a simple aggregation as :
select max(name), min(name)
into val1, val2
from tbl;
which also works for non-numeric variables.
Or alternatively use a correlated subquery in a single query as :
select ( select name from tbl where name = 'n1' ),
( select name from tbl where name = 'n2' )
into val1, val2
from dual;
answered Nov 19 at 8:24
Barbaros Özhan
11.4k71530
this is what i'm looking for! thank you sir!
– Miracle
Nov 19 at 9:58
1
@Miracle you're welcome.
– Barbaros Özhan
Nov 19 at 10:02
add a comment |
up vote
0
down vote
To make it readable you can add 2 select into statements:
select name
into val1
from tbl
where name = 'n1';
select name
into val2
from tbl
where name = 'n2';
answered Nov 19 at 8:25
user7294900
18.8k93056
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
2
down vote
accepted
Use a simple aggregation as :
select max(name), min(name)
into val1, val2
from tbl;
which also works for non-numeric variables.
Or alternatively use a correlated subquery in a single query as :
select ( select name from tbl where name = 'n1' ),
( select name from tbl where name = 'n2' )
into val1, val2
from dual;
answered Nov 19 at 8:24
Barbaros Özhan
11.4k71530
this is what i'm looking for! thank you sir!
– Miracle
Nov 19 at 9:58
1
@Miracle you're welcome.
– Barbaros Özhan
Nov 19 at 10:02
add a comment |
up vote
2
down vote
accepted
Use a simple aggregation as :
select max(name), min(name)
into val1, val2
from tbl;
which also works for non-numeric variables.
Or alternatively use a correlated subquery in a single query as :
select ( select name from tbl where name = 'n1' ),
( select name from tbl where name = 'n2' )
into val1, val2
from dual;
answered Nov 19 at 8:24
Barbaros Özhan
11.4k71530
this is what i'm looking for! thank you sir!
– Miracle
Nov 19 at 9:58
1
@Miracle you're welcome.
– Barbaros Özhan
Nov 19 at 10:02
add a comment |
up vote
2
down vote
accepted
up vote
2
down vote
accepted
Use a simple aggregation as :
select max(name), min(name)
into val1, val2
from tbl;
which also works for non-numeric variables.
Or alternatively use a correlated subquery in a single query as :
select ( select name from tbl where name = 'n1' ),
( select name from tbl where name = 'n2' )
into val1, val2
from dual;
answered Nov 19 at 8:24
Barbaros Özhan
11.4k71530
Use a simple aggregation as :
select max(name), min(name)
into val1, val2
from tbl;
which also works for non-numeric variables.
Or alternatively use a correlated subquery in a single query as :
select ( select name from tbl where name = 'n1' ),
( select name from tbl where name = 'n2' )
into val1, val2
from dual;
answered Nov 19 at 8:24
Barbaros Özhan
11.4k71530
answered Nov 19 at 8:24
Barbaros Özhan
11.4k71530
answered Nov 19 at 8:24
Barbaros Özhan
11.4k71530
answered Nov 19 at 8:24
Barbaros Özhan
11.4k71530
11.4k71530
this is what i'm looking for! thank you sir!
– Miracle
Nov 19 at 9:58
1
@Miracle you're welcome.
– Barbaros Özhan
Nov 19 at 10:02
add a comment |
this is what i'm looking for! thank you sir!
– Miracle
Nov 19 at 9:58
1
@Miracle you're welcome.
– Barbaros Özhan
Nov 19 at 10:02
this is what i'm looking for! thank you sir!
– Miracle
Nov 19 at 9:58
this is what i'm looking for! thank you sir!
– Miracle
Nov 19 at 9:58
1
1
@Miracle you're welcome.
– Barbaros Özhan
Nov 19 at 10:02
@Miracle you're welcome.
– Barbaros Özhan
Nov 19 at 10:02
add a comment |
up vote
0
down vote
To make it readable you can add 2 select into statements:
select name
into val1
from tbl
where name = 'n1';
select name
into val2
from tbl
where name = 'n2';
answered Nov 19 at 8:25
user7294900
18.8k93056
add a comment |
up vote
0
down vote
To make it readable you can add 2 select into statements:
select name
into val1
from tbl
where name = 'n1';
select name
into val2
from tbl
where name = 'n2';
answered Nov 19 at 8:25
user7294900
18.8k93056
add a comment |
up vote
0
down vote
up vote
0
down vote
To make it readable you can add 2 select into statements:
select name
into val1
from tbl
where name = 'n1';
select name
into val2
from tbl
where name = 'n2';
answered Nov 19 at 8:25
user7294900
18.8k93056
To make it readable you can add 2 select into statements:
select name
into val1
from tbl
where name = 'n1';
select name
into val2
from tbl
where name = 'n2';
answered Nov 19 at 8:25
user7294900
18.8k93056
answered Nov 19 at 8:25
user7294900
18.8k93056
answered Nov 19 at 8:25
user7294900
18.8k93056
answered Nov 19 at 8:25
user7294900
18.8k93056
18.8k93056
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%2f53370738%2foracle-plsql-store-2-values-from-same-column-in-2-different-variable%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
