Helpforce provides free 24/7 online technical support

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

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

eDiscover

Click the logo to go back to the main page

Databases

Search eDiscover

Categories