Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

range to fetch doubt

639997Mar 26 2009 — edited Mar 27 2009
create table a
(
cont_number number,
range_from number,
range_to number
)
/
insert into a values (1,0,100);
insert into a values (2,0,100);
insert into a values (3,0,100);
insert into a values (4,0,1000);
insert into a values (5,0,100);
insert into a values (6,0,100);
/
i want the output shoulld be displayed as
1-2-3   0  100
4-4      0  1000
5-6      0  100
my version is 9.2

thanks in advance
caps
This post has been answered by Frank Kulash on Mar 26 2009
Jump to Answer

Comments

Robert Ponder
Hi,

edelivery.oracle.com

But if you don’t know that you probably are going to make a lot of mistakes on your install. Why not get help from someone who knows Siebel?

R

Robert Ponder
Lead Architect and Director
Ponder Pro Serve
cell: 770.490.2767
fax: 770.412.8259
email: rponder@ponderproserve.com
web: www.ponderproserve.com
shanmukhdo
Hi Robert,

Thanks so much for ur reply,

Does the siebel 8.1 run on win 7? Is it compatible? I mean can i install and work on client, tools and sample database. I find many cases of incompitibility on internet..

Thanks
Shanmukh

Edited by: Shanmukh on Dec 7, 2010 6:25 PM
shanmukhdo
I have one more question
tanmay.jain
Hi Shanmukh,

Officialy Siebel 8.1 is not supported on Windows 7. However, you can install the sample Tools and Web Client on Win 7 and use them for your learning activities without any issues.
For installing the sample installation ensure the following:
1. before commencing installation, right click on oui.exe and in the properties choose to run it as an administrator and in compatibility mode for Windows Xp.(oui.exe is the installer for Siebel)
2. for installing siebel tools for sample you need not worry about the various parameters. The default hold good. So you can generally do a Next Next button click installation. However, it will be still good to see all the various parameters as this will be informative in your later stages of learning.
3. Same holds true for siebel web client.
4. for installing siebel sample oracle has provided install shield wizard instead of oui.exe. In this the path is generally pointing to the wrong directory. You will need to change this to the Siebel Web Client installation folder. This should normally be like c:\siebel\8.1\client_1\local.
5. The userid and password for accessing the sample db is sadmin / sadmin.

With Regards,
Tanmay Jain
shanmukhdo
Hi Tanmay Jain ,

I am very really thankful for taking your time out and answering my question in a detailed fashion.

I will get back in case of any problems i encounter while installation.

Thanks
Shanmukh
shanmukhdo
Hi,

I downloaded SEA media pack 8.1 from edelivery site, i extracted all the jar files related to enu language but i cant find oui.exe anywhere. Please help.
shanmukhdo
Hi

finally found oui.exe, installed client, tools and sample db

thanks everyone for the help.

Edited by: Shanmukh on Dec 10, 2010 9:56 AM

Edited by: Shanmukh on Dec 10, 2010 10:48 AM
shanmukhdo
thanks
665365
Downloading the Oracle Virtual Machine template seems to be a better option.

You can refer to the following link:

http://www.oracle.com/technology/products/vm/templates/siebel.html

You will find the installation guide and Oracle training on the Siebel VM Template.

You can download the template @ http://edelivery.oracle.com/oraclevm

Select Oracle Product Pack: Oracle VM Templates, then x86 32 bits ou 64 bits.


Best Regards
J. Aquino
612530
Hi
Is it possible to get a free download of siebel trial version?

Cheers
MJ
shanmukhdo
Yes, it is possible. Go to edelivery.oracle.com site and choose Siebel CRM and then you will find lot of things to download, download the 'Siebel Business Application media pack (SEA)' (without translations). And in that package download client (2 parts), tools and sample DB and ignore the remaining.

Thanks Shanmukh
845534
Hello,

I have a Macbook Air (latest model) and using Safari 5.0.3 version. I am not able to access Siebel 8.1 application. When I tried to access the application, it gives me an error message that

Your version of the Siebel High Interactivity Framework for IE, required for use of this Siebel application, may not be current. In order to download a current version of the Siebel High Interactivity Framework, please ensure that your browser security settings are correct and then log in to the application again. Consult your system administrator for details about the Siebel High Interactivity Framework and correct browser settings"

Pl. suggest how do i access siebel 8.1.
780408
Hi Tanmay,

You said officially siebel 8.1 is not supported on Windows 7. Do u know if i can find any documents regarding that. It would be helpful for me.

Thanks.
mroshaw76
@user1138051 :

http://download.oracle.com/docs/cd/E11886_01/V8/CORE/core_8_1.html
mroshaw76
@842531: The Siebel High Interactivity Client is only supported on Internet Explorer in Windows

@user1138051: http://download.oracle.com/docs/cd/E11886_01/V8/CORE/core_8_1.html

Regards,

mroshaw
1 - 15
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 24 2009
Added on Mar 26 2009
11 comments
1,252 views