Home » SQL & PL/SQL » SQL & PL/SQL » Select Command doubt
Select Command doubt [message #212974] Tue, 09 January 2007 00:04 Go to next message
anitha.s
Messages: 4
Registered: January 2007
Junior Member
Sir,
I have attached Book1.xls with this topic. In that, I have to retrieve the workflow for particular workflow id( ex:wrkflwid_01)

My doubt is how to retrieve the rows between wrkflwid_01 and wrkflwid_02?

Plz help me to write sql query to retrieve this. It is urgent.
Thanks in advance
anitha
  • Attachment: Book1.xls
    (Size: 14.00KB, Downloaded 202 times)
Re: Select Command doubt [message #212978 is a reply to message #212974] Tue, 09 January 2007 00:08 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Please try to reduce your problem to a size that you can explain in plain text, without the use of some weird propriety format (xls).
You will notice that a) people are very reluctant to open xls attachments, and b) you will learn a great deal about your actual problem when you try to reduce it to a reproducable testcase.
Re: Select Command doubt [message #212981 is a reply to message #212974] Tue, 09 January 2007 00:48 Go to previous messageGo to next message
anitha.s
Messages: 4
Registered: January 2007
Junior Member
ok..

my excel sheet contains 3 columns(Workid, steps, tasks)

The workid contains sequence of steps and tasks

In my excel sheet, first row has workid_01 , step01, task01
Second row has empty cell, step02, task01
Third row has empty cell, empty cell, task02

I want to fetch all these rows by using workid_01. I need the query to fetch all the rows by using single workid_01.


anitha
Re: Select Command doubt [message #212989 is a reply to message #212981] Tue, 09 January 2007 01:11 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Do you want to select from an excel sheet or do you want to select from an Oracle table? (You are aware that this is an Oracle forum, right?)
Show us what your tables look like and provide some sample data. In the newbie forum, there is a topic at the top of the forum describing how to post sample data.
Re: Select Command doubt [message #212999 is a reply to message #212974] Tue, 09 January 2007 01:38 Go to previous messageGo to next message
anitha.s
Messages: 4
Registered: January 2007
Junior Member
Thanks for your response.
I am using SQL query to fetch the rows from excel sheet.

S.No Workflow_id Steps Task Subtask
1 wrkflwid_01 step01 task01
task02 subtask01
subtask02
step02 task01 subtask01
subtask02
2 wrkflwid_02 step01 task01
task02
step02 task01 subtask01
subtask02


Re: Select Command doubt [message #213002 is a reply to message #212999] Tue, 09 January 2007 01:51 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Once again: this is Oracle forum (not Excel, not Microsoft SQL Server one). Just to make sure you understand it.

Now, as you have data in an Excel file and would like to select its contents using Oracle, you might save it as a CSV (Comma Separated Values) file and load it into an Oracle table using SQL*Loader utility or, if your database version supports it, use this file as an external table.

There might be some other way, but I've never used it.
Re: Select Command doubt [message #213015 is a reply to message #212974] Tue, 09 January 2007 02:41 Go to previous message
anitha.s
Messages: 4
Registered: January 2007
Junior Member
Thanks a lot
Previous Topic: ...Verify this Answer...
Next Topic: put a result into an array
Goto Forum:
  


Current Time: Sun Dec 04 04:46:29 CST 2016

Total time taken to generate the page: 0.07532 seconds