25/04/2018 11:47
Lets say I had to find the products for which we had a total of $500 or more in sales. I need to see the following information: · product number · total sales (in dollars) · product name So.I write this..
SQL> select orderdetails.prodnum,sum(unit*price) 2 from products,orderdetails 3 where products.prodnum=orderdetails.prodnum 4 having sum(unit*price) > 500 5 group by orderdetails.prodnum; And it produces the correct output: PRODNUM SUM(UNIT*PRICE.... read more

3 answersclick here to view

24/04/2018 11:47
Hi, According to the documentation,I may setup a job to automaticallygather statistics for all the segments in my databasevia EM database control.
I cant find any documentation on how to do this.
I did find a link in EM which will allow meto gather statistics ad hoc but I want it automated.
Thanks, -moi

1 answersclick here to view

23/04/2018 11:47
If I delete data from a child-table, then the father tables get locked.
I can not understand the reason for locking the father-table whendeleting child-entries.
Can someone explane that to me??? Here is my full example: -- Create Tables DROP TABLE TEST_PRODUCTION; DROP TABLE TEST_CONFIG; CREATE TABLE TEST_CONFIG( CONFIGID NUMBER(38) NOT NULL, DESCRIPTION VARCHAR2(1000) NOT NULL, VALIDFROM DATE, VALIDTO DATE, PREVID NUMBER(38), USERNAME VARCHAR2(100) NOT NULL, CONSTRAINT PK_TEST_CONFIG P.... read more

10 answersclick here to view

22/04/2018 11:47
Hi All I have a OCI client on a LAMP server where PHP creates a connection toa Oracle 8i server on a remote location through a WAN link.
If I take my laptop which contains a virtual machine that is a cloneof the LAMP server I can connect at the client's remote WAN link.
However, if I do try to create an Oracle connection on the LAMP serveror through my Laptop on the LAMP server location. I get the followingerror: ORA-12514: TNS:listener does not currently know of service requestedin conne.... read more

1 answersclick here to view

21/04/2018 11:47
Anyone have sample VB code that returns set of connection stringsdefined in local tnsnames.ora ? thx in advance

2 answersclick here to view

20/04/2018 11:47
Hi, Is there another way to do what I'm trying to do in Oracle 9i forSolaris? In a stored procedure, I want to disable some foreign keyconstraints, perform some actions, and then re-enable them. However,when trying to compile the package, I get the errors. The code isbelow that.
LINE/COL ERROR-------------------------------------------------------------------------57/2 PLS-00103: Encountered the symbol ALTER when expecting oneof the following: begin case declare exit.... read more

1 answersclick here to view

19/04/2018 11:47
Hi All, I am new in IAS. I am trying to install IAS 10g (9.0.4), on WIn2000.
both IAS & Infra in same server, one Database.
It used to be running, but today it won't start.
Here is the error : Application Server Control : Status = DownFarm=Infrastructure database is unavailable(but using sqlplus, I have succesfully log-in into that'Infrastructure database') Components : Forms -> UnavailableOC4J_BI_Forms -> UnavailableReports Server: rep_sysloginfra -> Status = [inprogress,.... read more

3 answersclick here to view

18/04/2018 11:47
Hello out there! I am just planning a new Reporting Application for a large chain ofbakeries. I have done already applications like this, but not with thatamount of Data.
Roughly, the Bakery has 120 Shops.
Each Bakery has about 500 Customers per DayEach customer buys 2 Different Items in Average. There are about 100different Items.
so this makes120*500*2 = 120000 Items bought per day120000*6 = 720000 per week720000*50 =36.000.000 per Year with 300 buisness days Raw data is delivered in the fo.... read more

3 answersclick here to view

17/04/2018 11:47
Hi, I've been asked to install Oracle LDAP on 8i.
Ok, I have no clue about where to start. I grabbed a script ofMetalink and tried to compile it and received the following errors: 9/22 PLS-00201: identifier 'DBMS_LDAP.SESSION' must be declared9/22 PL/SQL: Item ignored10/22 PLS-00201: identifier 'DBMS_LDAP_UTL.PROPERTY_SET_COLLECTION'must be declared 10/22 PL/SQL: Item ignored11/22 PLS-00201: identifier 'DBMS_LDAP.STRING_COLLECTION' must bedeclared .... read more

1 answersclick here to view

16/04/2018 11:47
Hi, I am using Oracle 9i (9.2.0.1) on WindowsXP. I created the primarydatabase and using Dataguard, I created a physical standby database ona different machine. The configuration is working good and no problems.
Next i tried to verify the switchover operation using the dataguardmanager GUI.
During the switchover process an error occured (Exception Cobrasomething). After this my management server service is not starting andwhen I try to connect to the primary database the error Ora-0103: Oracle .... read more

1 answersclick here to view

15/04/2018 11:47
I have to copy a DB from Solaris to HP-UX. The versions of Oracle andthe db names will be the same. I have one major hitch and question. The hitch - export/import is not an option. I can get a cold backupfor laying the db down on the HP-UX box, but from then on, I will needto roll forward using logs until the decision is made to cut overbetween the two boxes. My question: Will there be any OS compatibilty issues for the control, data and logfiles? Meaning, will Oracle on HP-UX be able to re.... read more

2 answersclick here to view

14/04/2018 11:47
Win a free guitar today!!!! http://freeguitars.blogspot.com/

2 answersclick here to view

13/04/2018 11:47
I worked on Oracle 9i for a while under Window 2000 environment. Ijust started working on 10g, and work like to clarify a confusion.
In Oracle 9i, it was recommanded that the Archive Log folder (disk)should be doifferent from the folder (disk) for storing the RMANfiles. But in 10g, it looks like they are to be kept inflash_recovery_area. Is this contradict what it should be definedbefore ? Also there is maximum size definition of the flash_recovery_area.
Should I defined the total size of th.... read more

7 answersclick here to view

12/04/2018 11:47
I have a string of id's and True or False values. I could have 50000pairs. Like: 2,t,6,t,9,f I am new to oracle and I am tring to make apackage. so basically I need to look threw the string for updateactive(t or f) where id=number I am new to Oracle. Below does not seem to work. I don't get anyerrors AS PROCEDURE Update_Route_Camera(CSArray IN VARCHAR2)ISi NUMBER;x number;y varchar2(1);BEGIN-- initialisei := 0;LOOPi := i+1;EXIT WHEN instr(CSArray, ',', 1, i) = 0;-- get first valu.... read more

2 answersclick here to view

11/04/2018 11:47
Hi , In oracle 9i, admin. guide in chapter 25 a caution is mentioned: It is on the topic of Specifying Default Roles http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/privs.htmCaution: When you create a role (other than a user role), it is granted to youimplicitly and added as a default role. You receive an error at loginif you have more than MAX_ENABLED_ROLES. You can avoid this error byaltering the user's default roles to be less than MAX_ENABLED_ROLES.
Thus, you should c.... read more

6 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