Click here to Skip to main content
15,867,568 members
Home / Discussions / Database
   

Database

 
AnswerRe: How to query data base with 3 different conditions Pin
Richard Deeming22-Jan-14 1:49
mveRichard Deeming22-Jan-14 1:49 
GeneralRe: How to query data base with 3 different conditions Pin
VishwaKL22-Jan-14 18:55
VishwaKL22-Jan-14 18:55 
GeneralRe: How to query data base with 3 different conditions Pin
Richard Deeming23-Jan-14 1:32
mveRichard Deeming23-Jan-14 1:32 
QuestionRe: How to query data base with 3 different conditions Pin
Eddy Vluggen22-Jan-14 8:40
professionalEddy Vluggen22-Jan-14 8:40 
QuestionInput required..need help:recursive procedure & container logic Pin
ramina sen21-Jan-14 6:48
ramina sen21-Jan-14 6:48 
AnswerRe: Input required..need help:recursive procedure & container logic Pin
Eddy Vluggen21-Jan-14 6:57
professionalEddy Vluggen21-Jan-14 6:57 
AnswerRe: Input required..need help:recursive procedure & container logic Pin
Mycroft Holmes21-Jan-14 11:59
professionalMycroft Holmes21-Jan-14 11:59 
GeneralRe: Input required..need help:recursive procedure & container logic Pin
ramina sen22-Jan-14 7:04
ramina sen22-Jan-14 7:04 
correct,

but as I have mention my inner query is giving me only parent but I want to make use of the result of the inner query again as input till I did not find any child ,so I am using procedure as I have to collect all the parent I get from the inner query and then update the outer query using the inner query result.it is the requirement what I want to achive,

e.g

update table A
set A.a as "xyz"
//here I will get t
where A.id in
(
select A.child_id from A,B,C

--I get the child by passing parent as input and again consider the child as parent
and find the child

where A.id= b.id
b.name = x and A.prent_id = ?

//few join condtion here
)

e.g

input 1 result 1.1
input 1.1 result 1.1.1
input 1.1.1 result 1.1.1.1

update A
where A.id in
('1.1','1.1.1','1.1.1.1')--here I want to use a container and make use of it


Hope you get my intention now ..Thanks for your response.
Generaljoin query Pin
rushabhp21-Jan-14 0:05
rushabhp21-Jan-14 0:05 
QuestionRe: join query Pin
thatraja21-Jan-14 0:18
professionalthatraja21-Jan-14 0:18 
AnswerRe: join query Pin
rushabhp21-Jan-14 18:50
rushabhp21-Jan-14 18:50 
GeneralRe: join query Pin
King Fisher30-Jan-14 2:17
professionalKing Fisher30-Jan-14 2:17 
QuestionAccess 2007 Trying to get Report to break down Call Count within 3 consecutive time ranges. Pin
Member 1053318518-Jan-14 18:28
Member 1053318518-Jan-14 18:28 
AnswerRe: Access 2007 Trying to get Report to break down Call Count within 3 consecutive time ranges. Pin
Mycroft Holmes18-Jan-14 22:32
professionalMycroft Holmes18-Jan-14 22:32 
QuestionProper databse for a seatmap/multiple? Pin
Yhen Caisip18-Jan-14 3:05
Yhen Caisip18-Jan-14 3:05 
AnswerRe: Proper databse for a seatmap/multiple? Pin
Peter Leow18-Jan-14 3:25
professionalPeter Leow18-Jan-14 3:25 
GeneralRe: Proper databse for a seatmap/multiple? Pin
Yhen Caisip18-Jan-14 4:06
Yhen Caisip18-Jan-14 4:06 
SuggestionRe: Proper databse for a seatmap/multiple? Pin
Peter Leow18-Jan-14 4:50
professionalPeter Leow18-Jan-14 4:50 
GeneralRe: Proper databse for a seatmap/multiple? Pin
Yhen Caisip18-Jan-14 6:00
Yhen Caisip18-Jan-14 6:00 
AnswerRe: Proper databse for a seatmap/multiple? Pin
Jörgen Andersson18-Jan-14 4:24
professionalJörgen Andersson18-Jan-14 4:24 
Questionoracle database 10g SCN Number change Pin
vinayak sharma16-Jan-14 5:43
vinayak sharma16-Jan-14 5:43 
AnswerRe: oracle database 10g SCN Number change Pin
Shameel21-Jan-14 23:37
professionalShameel21-Jan-14 23:37 
Questionpostgresql issues Pin
aswadmanap14-Jan-14 22:35
aswadmanap14-Jan-14 22:35 
AnswerRe: postgresql issues Pin
Eddy Vluggen15-Jan-14 0:31
professionalEddy Vluggen15-Jan-14 0:31 
GeneralRe: postgresql issues Pin
aswadmanap15-Jan-14 15:10
aswadmanap15-Jan-14 15:10 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.