17/06/2018 11:47
Yellowfin is set to redefine what BI users and IT Departments willexpect from Business Intelligence vendors Leading Business Intelligence software provider, Yellowfin, todayannounced it would be launching its milestone release on May 5th,2010.
Yellowfin 5.0 is set to redefine what BI users and IT Departments willexpect from BI vendors. With faster deployment and faster analytics,Yellowfin 5.0 is set to establish new BI standards, all the extrafunctionality is integrated and three simple steps a.... read more

2 answersclick here to view

16/06/2018 11:47
Greetings All, I'm struggling with this one.
I'm trying to structure a query for MySQL 3.23.
SELECT * FROM jos_liveshoutbox_temp WHERE id > 20 AND name=me ORname=cathy What I need to get is * WHERE id's > 20 from me and from cathy.
What I'm getting from the above query is only * from cathy.
It would be great if you could work MySQL queries like math: SELECT * FROM jos_liveshoutbox_temp WHERE id > 21 AND (name=cathyOR name=client) Does anybody have any solution? I'.... read more

4 answersclick here to view

15/06/2018 11:47
Hello, You are welcome to test a new great tool for Oracle spClientMonitor.
spClientMonitor provides Oracle database administrators and Oracletuning experts with a convenient and powerful framework to monitor andtrace SQL performance of end users applications accessing Oracledatabases through the TCP/IP network. spClientMonitor enables you towatch the SQL performance from the end-user or target applicationpoint of view. This approach allows you to quickly resolve SQL relatedperformance issues wh.... read more

1 answersclick here to view

14/06/2018 11:47
Hi all, I want to measure oracle (11i) on a regular base doing the sametransaction (inquiry on the same item or something like it) every fewminutes.
Is there any tool to automate and reproduce transactions on a screenmeasuring the start and end time of each transaction? I had one once (veeeery long time ago) on 10.7 but want to monitor ona 11i platform now.
Many thanks in advance.
Ronald.

6 answersclick here to view

12/06/2018 11:47
Hello all - I am beginning to get into transactions and am a little stuck. I haveread the manuals online, but haven't been able to wrap my head aroundthem. I haven't found a good example of what I'm trying to do.
I have some PHP code where I insert a row into a parent table, andthen insert an arbitrary number of rows into the child table. If Ican't insert all of the child rows, I want to rollback all of theinserts. The issues I'm having: 1. How to get the id of the new row .... read more

3 answersclick here to view

11/06/2018 11:47
My linux box(rhel as 4) where oracle instance is located is showingnearly 100 memory utilization (using top command). Changing resourcelimit using 'ulimit' is not showing any significant improvements.Howcan i fix the upper limit of memory utilization.Oracle version is9.2.0.5 Thanks and regards

1 answersclick here to view

10/06/2018 11:47
Hi All, I have a query as below Update AlmEvtTbl SET State = 2 where AlmEvtId in (SELECT/*+ FIRST_ROWS */ AlmEvtSysPeView.AlmEvtId FROM AlmEvtSysPeView where(AlmEvtSysPeView.ParentCustId=0 ANDAlmEvtSysPeView.TimeStamp >= TO_DATE('2004-12-06 18:30:00', 'YYYY-MM-DDHH24:MI:SS')and AlmEvtSysPeView.TimeStamp <= TO_DATE('2004-12-09 18:29:59','YYYY-MM-DD HH24:MI:SS') ANDAlmEvtSysPeView.State <> 3)AND ROWNUM < 2000 If I remove the FIRST_ROWS hint from the .... read more

1 answersclick here to view

09/06/2018 11:47
Strange question. But can somebody shed some light on the internalworkings of an unique index? 1. Insert 1 row into a table with an unique index on it.
2. Old data and index blocks that the insert statement touched aremove to rollback segment.
3. ORALCE enforces the uniqueness due to the index. How? By doing afull scaning on the table column and the index?4. Insert another row into the table. How does ORACLE enforce theuniqueness? ORACLE does not need to look up the rollback segment tocheck for .... read more

3 answersclick here to view

08/06/2018 11:47
Can someone explain why the following query will return 80 records: SELECT DISTINCT c.caseid FROM cases c LEFT JOIN casespecialty cs ON c.caseid = cs.caseid LEFT JOIN examspecialty es ON c.caseid = es.caseid WHERE (cs.uid = 86 OR es.uid = 86) but when c.caseid is wrapped with Count() the query will return 225: SELECT DISTINCT Count(c.caseid) FROM cases c LEFT JOIN casespecialty cs ON c.caseid = cs.caseid LEFT JOIN examspecialty es ON c.caseid = es.caseid WHERE (cs.uid = 86 OR es.uid = 86) The .... read more

6 answersclick here to view

07/06/2018 11:47
Hi, I have a (still theoretical) question.
I'll have two database instances (9.2.0.x) which are used together via database links and distributed transactions. These two databases are no copies but different parts of a product.
How can I ensure synchronous backups? An example: Database A goes down and I restore it. How can I bring the database B into a state, where it is synchron to the restored database A again? Best regards,Peter

7 answersclick here to view

06/06/2018 11:47
Back in the days of Oracle 7 when they used to send you a complete manual set every time you upgraded, or even just requested a patch, the RDBMS manual set was about 30 long ( a foot for the metrically challenged among us.) How long is the 10g manual set? Can you even get a physical set of manuals anymore? For those who can't read a usenet post unless it has a version number in it - 10.2.0.1.

1 answersclick here to view

04/06/2018 11:47
I'm trying to create this table at the command line and get an error: mysql> create table events( -> id INTEGER, -> session_id INTEGER, -> user_id INTEGER, -> when TIMESTAMP, -> eventtype_id INTEGER, -> dataint INTEGER, -> data_id INTEGER -> );ERROR 1064 (42000): You have an error in your SQL syntax; check themanual that corresponds to your MySQL server version for the rightsyntax to use near 'when TIMESTAMP,eventtype_id INTEGER,dataint .... read more

1 answersclick here to view

02/06/2018 11:47
Hi all, I would like to know under what conditions that I(a 4th year undergraduate student at Trinity CollegeDublin, Ireland) student may (or may not) use Oracledatabase products for a degree project? The intended use is for a project which will notcontinue past June 2010. The project will not bedeployed to the public nor commercially and no feesof any sort will be charged to anyone who does useit - use will be restricted to fellow students (testing)and staff (grading).
I would be grateful if a.... read more

4 answersclick here to view

01/06/2018 11:47
Hello, I got a table with timestaps and some data, spanned over years. I canaverage over minutes, hours etc using such an expression (this is for1 hour average) SELECT TIME, AVG( UNCORRECTED ) FROM hourlydata GROUP BY truncate( ( ( TIME_TO_SEC( TIME ) +86400 * TO_DAYS( TIME ) ) / ( 3600 ) ), 0 )ORDER BY TIME but I also need to average across month/ few months and also years,that is, something which has a variable lengths. Please advise me howI could do that in SQL.

1 answersclick here to view

31/05/2018 11:47
Hello guys When installing Oracle, one finds that there are number ofauthorized users in addition to sys, system and scott. what are theirdefault passwords and roles? Thanks in advanceDebashish

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