Linked Questions

I have a simple query: select * from countries with the following results: country_name ------------ Albania Andorra Antigua ..... I would like to return the results in one row, so like this: ...

How can I achieve the following in oracle without creating a stored procedure? Data Set: question_id element_id 1 7 1 8 2 9 3 10 3 ...

My inputs are in this way. col1 col2 1 a 1 b 2 c 2 d 2 e O/p: Should Be like col1 col2 1 a,b 2 c,d,e I want a query that can be fired at DB level. I've ...

I have a table that looks like this: A 1 A 2 B 1 B 2 And I want to produce a result set that looks like this: A 1 2 B 1 2 Is there a SQL statement that will do this? I am using Oracle. Related ...

Let’ say I have a table with 3 columns ID INTEGER, OFFSET INTEGER, STR VARCHAR(50) Containing values: ID OFFSET STR 1 1 TestSTR1 1 2 ...

I have a Oracle 11g XE database and I have a query the result set: ID Category 1 Cat1 1 Cat2 2 Cat3 2 Cat4 I want to get distinct id's with all related categories in same row as comma ...

I have a table like this: I need a query (no PL/SQL) that shows this output: So for each Product ID I want the distinct values of Delivery Type in the field Delivery Type. Is there a way to get this ...

I have a table called MY_MOVIES with two columns: MOVIES and GENRES like this (the relationship is one movie to many genres): GENRE MOVIE ---------- -------------- ACTION ...

Don't we hate when evil coding comes back to haunt? Some time ago I needed to generate a string concatenating some fields for some more processing later. I thought it would be a good idea to do if ...

I am stuck in situation where I need a comma separated list from group by result sets. Let me give you a typical schema : username | lotno | img ------------------------ ...

I have a query like: select a.id, b.value from a left join b on a.name = b.name where a.id = 12345; And I get results like id value -------- 12345 value1 12345 value2 However I would like to get a ...

I have below select query: select distinct(e.ENGINE_ID), e.ENGINE_NAME, os.OBJECT_STATUS, br.NAME, env.NAME from ENGINE e, RATOR_MONITORING.OBJECT_STATUS os, ...

I have a package in oracle that contains one stored procedure. It takes a date as a input and a number as input, and outputs the data into a ref_cursor. The purpose of the stored procedure is to ...

I have a table like this id | Name =========== 1 | A 2 | A 3 | A 4 | B 5 | B 6 | C i am writing select id from tbl where name = "A", i want to get all three ids (1,2,3) like this ...

I'm having trouble explaining this, so if someone can make adjustments to the title or question then please do. I have a simple SQL query that I'm running SELECT orders.customer_no, orders.order_no ...