Tagged questions

382 results found

Use of bind variables or stored procedures in OBIEE or BI PublilsherAugust 18, 2011

I am investigating the possible use of OBIEE in delivering a BI reporting solution.  I have a query hitting a star schema, which I would like to execute to give me a report. I want to pass parame

13

views

0

votes

9

answers

how to embed oracle client drivers with deployed-to-production web application?August 18, 2011

I am having some issues with retrieving xml resultset from oracle 92 client installed on the production web server. I have the site working on my dev machine. Currently, I am unable to get oracle10g u

51

views

0

votes

52

answers

XML Forest,XML ConcatAugust 18, 2011

Hi, I have a wo function in oracle which returns XML type. Sample XML From First Function <customer> <Fname>testFname</Fname> <Lname>testLname</Lname> </customer> S

27

views

0

votes

10

answers

iSQL Plus does not startAugust 18, 2011

I installed Oracle 10g Developer Suite for my class (I am taking an Oracle database class.) but I cannot connect to the database and cannot start iSQL Plus.  I checked into Services and I saw no

34

views

0

votes

22

answers

How to load an XML document in Oracle 10g xmlTableAugust 18, 2011

Hi experts,                    My task is to process data present in an XML file. For this I need to load this XML document in xmlTable type Oracle ta

21

views

0

votes

8

answers

Writing .Bat files - To login to Oracle 10g XE and import tableAugust 18, 2011

Hi I m trying to write a Batch file to do the following Login to Oracle Server giving the Userid / Pwd Run a PL\SQL command that creates a table if it doesnt exist Import data into the table from a co

15

views

0

votes

3

answers

How to do check/verify db settings?August 18, 2011

Hi guys, How to do check/verify db settings? parameters, storage settings or specifically one schema (important one/s). I've been asked to look into an existing/running db, just want your assistan

35

views

0

votes

15

answers

Get data from an XML file into Oracle TableAugust 18, 2011

Hi Experts,                   I am posting this post again. Till now I havent found an easy solution for this. The problem I am facing is:     &#

50

views

0

votes

5

answers

Oracle 10g Insert Performace IssueAugust 18, 2011

Hi I am using an Oracle 10g db that has a table (about 30 columns) with 15million records in and am trying to do straight insert into another blank table (although this table does have indexes and FK

32

views

0

votes

18

answers

Case insensitive database ?June 20, 2016

Hi , Can anyone tell me if there is any way to make a database,Oracle,case-insensitive? I've heard its possible with some code page in Windows as SQL server does,but have no idea what we need to do,

65

views

0

votes

8

answers