15/01/2019 11:47
good day , I am a new in developing reports with subject tool , and have such problem : I created web-only report 'MODULE2.jsp', and want that this report would be available through net. How do this ? I suspect I need to use web-server, - ok,I used it (http://zzz:80/MODULE2.jsp) and it says next : JSP Error: -------------------------------------------------------------------------------- Request URI:/MODULE2.jsp Exception: oracle.jsp.parse.JspParseException: Line # 1,Error: java.lang.C.... read more

1 answersclick here to view

14/01/2019 11:47
Hi there,assume we got two tables A and B.
Both Tables contain names, while B contains a subset of A thus everyname that is in B can also be found in A.
What I want to do is select all names from A and (and this is myproblem) the count of occurrences of every name in Table B.
Example: A.name: adambob B.name: bob I'm getting as far as this: select A.name, count(B.name) as times_in_B from A join B on a.name =b.name; But: The resulting relation contains only names that are in both tables, Aa.... read more

1 answersclick here to view

13/01/2019 11:47
Hello folks,I am a longtime DB developer but have been doing alot more DBA (Oracle8i) type responsabilities lately. One thing I am somewhat strugglingon is the maintainence of indices. I have read many posts onfragmentation, most of which tell you to look in the data dictionary,and have been running queries against several of the system viewsincluding dba_indexes and index_stats.
I'm finding it strange that index_stats is empty even though I havecomputed stats for most application tables?.... read more

4 answersclick here to view

12/01/2019 11:47
Hi all,I have some knowledge in PlSql, but I do not know where exactly thisbecomes handy.Where to use PlSql ? I have used triggers toautomatically update some tables if some other tables are updated by auser.But I do not knoww where are the other concepts used.If anybodycan point some real life examples , i will be helpful.
Thanks in advance.

2 answersclick here to view

10/01/2019 11:47
Hi, I've got two tables, one of which is a lookup for the other. It works something like this: table jobs: -----------id title manager designer________________________________ 1 dbproj 1 32 email 2 5 table people: -------------id name____________ 1 fred2 nancy3 joe4 ted5 marge I would like to be able to do a query like SELECT * FROM jobs and substitute the names from the people table on the fly. I can do this for one person using a join, like SELECT * FROM jobs WHERE jobs.manager = people.i.... read more

7 answersclick here to view

09/01/2019 11:47
i have lot of problems with letter query: select * from order where id_order in (1,5,9) oracle execute this query without problems, but select * from order where id_order in (:id_order) parametar is 1,5,9 oracle returns error any idea??

2 answersclick here to view

08/01/2019 11:47
I was recently asked to revoke UTL_FILE from PUBLIC by a colleague in IT security, following recommendations from NGSS (and their automated squirrel scanner).
Supposedly, Oracle recommends revoking this privilege: http://oraclelon1.oracle.com/docs/cd/A91202_01/901_doc/server.901/a90117/secure.htm#8738 However, I've noticed that several sys-owned objects in the data dictionary go invalid (and stubbornly remain so until utlrp.sql is executed). One of my Oracle 7 instances went into a tailspi.... read more

2 answersclick here to view

07/01/2019 11:47
Hello! I would like to execute following statement SELECT count(*) FROM TABLE_A WHERE COL_A || '|' || COL_B NOT IN(SELECT COL_A || '|' || COL_B FROM TABLE_B); TABLE_A consists of 37.000 rows. The statement takes over 10 mins.
I have set analyzed indexes to perform the statement but it doesn't helpanyway.
Is it possible to modify the statement to get the same result with muchbetter execution performance? Regards,Robert

2 answersclick here to view

06/01/2019 11:47
I need to view the contents of a DB2 table from Oracle SQL Plus.
Can someone let me know how to do this. Thank's alot.
John

3 answersclick here to view

05/01/2019 11:47
If I use sqlplus to connect to a database, I do it like that: sqlplus user1/secret1@ora1.mydomain.com:1583/db.prd1 where db.prd1 is the service_name.
If I do the connect through JDBC, the connection url is: jdbc:oracle:thin:@ora1.mydomain.com:1583:db1 SQLPLUS uses the service name, whereas JDBC uses the instance_name(resp. sid).
How does this work? Is the oracle protocol so that either instancename or service name can be used? Martin

2 answersclick here to view

04/01/2019 11:47
I hope somebody can help with this at-the-last-possible-moment glitchin the above installation.
In short, everything worked fine except the optional configurationmanager configuration.
Some jeee error or other.
So this is what I'm concerned with: I ran sqlplus and entered as username sys@orcl2 which is the sid asthe installer told me,and entered the password that I had supplied for 'administrator'during the installation.
I got the message you should login to sys as sysdba or sys.... read more

1 answersclick here to view

03/01/2019 11:47
How can I force PMON (Oracle 9i or 10i) to register with listener inold style (COMMAND=service_register) instead of new style(COMMAND=service_register_NSGR)?

4 answersclick here to view

01/01/2019 11:47
First of all, please excuse me as I don't have a depth of knowledgewith oracle. I had a problem where a test machine wouldn't run somesoftware. It was determined that oracle failed. After sometroubleshooting I realized the listener failed to start. I spent abunch of time trying to get it started manually to no avail.
Eventually I found out that one of the network cables was unplugged.
After plugging it in and rebooting it worked like a charm.
Oracle is listening on both network card.... read more

1 answersclick here to view

31/12/2018 11:47
Hi,I have a field to record the current time stamp while inserting eachrecord.
And it reads the Mysql server time while inserting well...
But, i need to record my local time ( Dubai Time)and server is in US ( we can do it through PHP by setting the Time zone while inserting,but how can the Mysql do the same job for me?) Please help Regards,Anees

7 answersclick here to view

30/12/2018 11:47
http://languages-languages.blogspot.com

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