25/09/2017 11:47
Hi all,My first question - Is it possible to have an Updatable MaterializedView and the associated Master Table located on the same database? This is the requirement scenario: One unique database D exists.
A is a batch table. Only inserts are allowed on Table A.
M is an updatable materialized view on Table A (Master). Only updatesare allowed on M (no insert or delete).
Requirement is to push updates/changes from M to A periodically andthen get the new inserted records from A into M via a refre.... read more

3 answersclick here to view

24/09/2017 11:47
What are the main differences between NUMBER(p) and INTEGER forstoring integer values? Is there any difference with space orperformance? I understand using NUMBER(p) with a value for Precision only (noscale) gives you an integer, constrained by a max of p digits. IsINTEGER the same as NUMBER(38), since 38 is the max precision? I've also heard it said that Oracle Corp recommends, or oncerecommended, using the NUMBER type with no precision or scalespecified; this way it accepts whatever type o.... read more

2 answersclick here to view

23/09/2017 11:47
Hi folks, I have a db which is similar to the example Name | Country | Typetest | USA | Nmtest2 | UK | Nbtest3 | USA | Nctest4 | USA | Nm What I want to know is if there is a simple SQL statement to do thefollowing: 1) Select all entries where country = USA (for example)2) Group by Type3) Display each group under each heading Type - i.e.
Nmtest | USAtest4 | USA Nctest3 | USA I'm going to keep looking, but I want to keep my SQL to a minimum andwondered what the of.... read more

4 answersclick here to view

22/09/2017 11:47
Again...I'm rusty, and have no documentation around...probably a stupidquestion.
I'm trying to join on a field that has some null values using (+), but,oracle doesn't seem to recognize this anymore. I'm on Oracle 9.2.0.6.
I've been looking up, an seeing that there is a new way to do an outterjoin, but, most examples I see only are using 2 tables and a couple offields, I can't figure how to use this on a large multi-table joinwhere lots of fields are being selected. Can .... read more

3 answersclick here to view

21/09/2017 11:47
Hi NG,Oracle decided to desupport Oracle Names in 10g. Willing or not, we're required to move to LDAP.
We're running here 100s of oracle instances named by the following scheme: INSTANCE.LOCATION.COMPANY.COUNTRY (e.g. db1.mch.oracle.de).
My problem moving to ldap comes with the domain names, of which we have dozens. I'd like to know, how the ldap tree looks like, exspecially how about the dc=OracleContext (required only on top-of-tree or in each domain?).
Could anyone provide a (ano.... read more

2 answersclick here to view

20/09/2017 11:47
Greetings, We are using Oracle 9i. Are regexp functions available in Oracle 9i, or was that introduced with 10? Given the following two strings: str_a='5838 MISSION CENTER RD #C'str_b='5838 MISSION CENTER RD C' orstr_a='7576 PARKWAY DR APT #2A'str_b='7576 PARKWAY DR APT 2A' is it possible to write an expression in Oracle 9i that will return true if the only difference between the two strings is the presence of the '#' symbol?

2 answersclick here to view

18/09/2017 11:47
Hi,I am pretty newbie to OCI layer. I was trying to make a connection tooracle, and was trying to fetch timestamp datatype by bindingtimpstamp datatype.
This datatype shows different behavior for different sub secondprecisions.
For my program(in c++) I was able to fetch data successfully fordirect execution for both Timestamp(6) and Timestamp(9). I am able tosee data value's.
On the other hand when I was trying to bind timestamp data,1) if my datatype is timestamp(6), it is unable to fetc.... read more

8 answersclick here to view

17/09/2017 11:47
Hi, Please let me know how to connect with the remote server in oracle asOS User.
ex:- sqlplus /@remote_database RegardsMahesh S

1 answersclick here to view

16/09/2017 11:47
Dear list members, now I have my first Oracle database running.
I can access it using sqlplus on command-line mode.
After creating the database I also could use theEnterprise Manager webtool using port 1158.
But after a reboot it wasn't started again (unlikethe rest of my database).
Could anyone tell me which service I have to start toprovide the EM manager web-tool (and how to configure itto start on mashine-boot) ? Best regards, Daniel Wetzler

4 answersclick here to view

15/09/2017 11:47
Hi, how can I set up an 9i Application Server only with Forms and Reports service? We don't need the other things LDAP, single sign on, Oracle Internet Directory, ...
But I'm only able to install the Forms and Report services after installing single sign on, ...
thanks Frank

2 answersclick here to view

14/09/2017 11:47
Folks,I am reading the Oracle 9i Database Performance Tuning Guide andReference, chapter 10 (Using SQL Trace and TKPROF). When I triedtracing my own SQL query (I am using Oracle 9.2.0.4 on SUN [sparc]Solaris 9), the output was slightly different than what appears inthe documentation. My output contained some extra details regardingthe query execution plan, for example: Rows Row Source Operation------- --------------------------------------------------- 1 SORT AGGREGATE (cr=2 r=0 w=0.... read more

2 answersclick here to view

13/09/2017 11:47
Hi everybody,I have a mysql db where i call a user defined function named exception when a constraint fail occurs. The function exception executes a fetch on an empty cursor to generate the SQL exception. I would like to know if there is a way to pass a parameter to the function exception, so I can get the type of occuring error from the function and print a significative message on the screen.
Thanks for the help.
Dymios

4 answersclick here to view

11/09/2017 11:47
Hello, I am looking for a Crystal Reports writer (version 10 a plus). I amfinding however, that not all Crystal aficionados post themselves onstandard job boards like Monster or Careerbuilder. Do you, or someoneyou know have Crystal Reports (in an Oracle 9i database) and need aposition in Massachusetts? Please give me a call at the number below,any info you may have, even on how to track down Crystal users, wouldbe much appreciated!Thanks! Emily McElfreshRecruiterGeneration Technologies, Inc..... read more

1 answersclick here to view

10/09/2017 11:47
So far I had been mostly satisfied with Pro*C/C++. It is a hugeimprovement from by previous programming environment (OCI. I can'tbelieve I ever programmed in that assembly language). All my programshave been written written in C so far. However, since I have beenknown to get myself into trouble :-) I decided to try the C++ side ofPro*C/C++, to take it for a spin.
Long story short: It was a bad decision, and I decided to go back togood ole' C.
Reasoning: (1) That is not real C++. I us.... read more

3 answersclick here to view

09/09/2017 11:47
Hi there.
My system is Oracle 9.2.0.5 on Windows.
I have 3 tables tblProbe, tblProbeType, tblProbe_HTTP (see at the end of this message) withSELECT pt.Name INTO v_Name FROM netprobe.tblProbe p INNER JOIN netprobe.tblProbeType pt ON p.PROBETYPE = pt.ProbeTypeID WHERE p.ProbeID = intProbeID;I get the Name, which I use for the Table.
Then I need to do: SELECT * FROM tblProbe_HTTP I tried to create a function which I can call from java laterI tried: CREATE OR REPLACE FUNCTION sp_getProbe.... read more

2 answersclick here to view

eDiscover
Helpforce eDiscover provides technical articles updated each day
Click the logo to go back to the main page
Databases

Helpforce eDiscover RSS feed contains the latest technical articles in RSSWe have a vast archive of technical informationA database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality in a way that supports processes requiring this information. This category deals with general databases and more specific vendor products such as MySQL and Oracle.

Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS