1,488 Topics
 | |
| | Hi Everyone, Just joined the community and wanted to share a quick "how-to" for anyone experiencing errors when setting up Oracle GoldenGate's archive settings. The default configuration of an Oracle database created with DBCA is to allow archiving to follow default settings. This in essence sets the log archive location … |
 | Hi there I got a little problem with a small bit of code am unfamiliar with orcale database the scripts I have were done by a other person for version 6/7 am currently using version 8i for compatibley reasons with the server software I am currently setting up. the script …  |
| | hi all I had make this samll method to insert data from c# forms into my oracle database the code processed fine but when I go to sql developers software to check if the record has been inserted or not I found nothing... so whats wrong with it please thanks … |
| | Dear All, I am trying to understand RMI Concept and have tried the sample steps and programs written in Oracle website [http://docs.oracle.com/javase/tutorial/rmi/compiling.html](null) In this URL they have mentioned to run the command as below javac -cp c:\home\jones\public_html\classes\compute.jar client\ComputePi.java client\Pi.java mkdir c:\home\jones\public_html\classes\client cp client\Pi.class c:\home\jones\public_html\classes\client I have tried the exact command … |
| | I installed oracle 11g R2 on centos 6.4 and it was successful. However, If I am not on LAN(Local Area Network), then it does not start properly i.e the TNS fails. During installation, There is no where I specified IP Address;yet, it can only work when I plug network cable. … |
| | We have ERP application that store the data to ORACLE database and also we have a lot of another web applications that use the ERP database. We got the performance issues when ERP and another application use the same database. We are planning to do mirroring of oracle database into … |
| | After installing Oracle 8.06 on Windows XP (Pentium (R) D CPU 3.2GHz 3.20GHz - 480 MB RAM). I'm Attempting to run "Oracle Net8 Easy Config" when error comes up saying "jre.exe has encountered a problem and needs to close.." I tried: -Doing a system restore and installed it again (after … |
 | i want block of code,, that deletes data from different table concurrently,, so that i can save time |
| | Hello people, I declared a field in my table : [B]my_field VARCHAR(20)[/B], but I don't want it to contain any number: can you tell me how I can do that using a trigger or using a constraint ? Thank you in advance for any help |
 | How do I retrieve image saved as a blob from oracle database please kindly help out.  |
| | What's the simplest way to read an excel file, get cell 'A1' in table(1,2,3), B3 to table(1,2,3), B6 to Table... import specific cell to table.  |
| | hey all I just need someone who can explian to me what the ESCAPE keyword does here ?? nd what the deference if I remove it ?? SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA\_%' ESCAPE ''; note working on the sample database SQL developers  |
| | how to configure oracle datasource in jboss 5.0 ?? and then how can I use this datasource in hibernate.cfg.xml file to make connection to the database ? |
| | hey all Im using SQL Developers version 1.1.3 and I want to totally remove it I sareched alot about an offical way to remove it but I found veryone remove its folder so I go though it but now when I want to install the software agian... I am getting … |
| | hi all i want to execute sql loader in windows 7 but i get this error :\Users\Admin>sqlldr access_dept1/access_dept1 control=G:\data1.ctl; SQL*Loader: Release 11.2.0.1.0 - Production on Fri Sep 27 19:11:51 2013 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. SQL*Loader-500: Unable to open file (G:\data1.ctl;) SQL*Loader-553: file not … |
| | I install orecal 9i but it require user id and password... i try scott/tiger system/manager sys/change_on_install but it not working plz solve this problem immedetly.... |
| | hi all i want to insert 110 million record in oracle database but i am using java application to insert the data but it takes 4 days to complete i check the program to see if there is a problem but what i found that the insert to the database … |
| | Hi, Please advise which database should choose for developer and dba profile  |
| | Guy...please help, I'm running Sql plus 9.... Can u guys help me with the host string? |
| | What is the Diffrence between Db2 and Oracle databse please explain |
 | just installed SQL Developer 4 and I'm using Oracle Database 11g. I want to execute multiple insert into statements in the worksheet at once. That works fine if I copy paste via command line of SQL but in Develop 4, only one row is being inserted at a time. Is … |
 | Java vulnerabilities have hardly been out of the news during the last year. Here at DaniWeb we've covered a number of the stories as they surfaced: [Java in the cross-hairs: the security debate rolls on](http://www.daniweb.com/software-development/java/news/445532/java-in-the-cross-hairs-the-security-debate-rolls-on), [Is Java 7 still insecure? Oracle Patch doesn't fix underlying vulnerability](http://www.daniweb.com/software-development/java/threads/432479/is-java-7-still-insecure-oracle-patch-doesnt-fix-underlying-vulnerability), [Update my insecure Java … |
| | hi I had a question in an exam that asked for the code of a trigger that cancels a transaction if a query result doesn't meet a condition in oracle database. is it possible? I am googleing but I can't find an answer thanks |
| | hi all i want to select data base of the value of the cursor but i donot know how to do it . thanks in advance |
| | Ok, here is one that we are strugglling with to find a potential source of "slowness" (as defined by the users). We have 4 staff that have new, Windows 7 machines connected to a Cisco 3750 Access Switch (connection is 1 GB, and connected through a Cisco 7975 phone). Connections …  |
| | Is it possible to use Kohana ORM with MySQL AND Oracle DB? More wider questions is is it possible to use two different databases (RDBMS) with Kohana? |
 | update mytable set mycolumn = trim(mycolumn) I am using above query where mycolumn is of type char. It trims the leading blank but not trailing. I tried update mytable set mycolumn = TO_CHAR (trim(mycolumn)) But it didn't help either. Can anyone help here? |
| | Hi, I am using windows 7 sp1 32bit, try to install "Oracle 11g release 2" I am getting below errors and not properly installed help me to solve this errors thanking you file not found C:\app\I\product\11.2.0\dbhome_1\oc4j_applications\applications\em.ear file not found C:\app\I\product\11.2.0\dbhome_1\oc4j_applications\applications\em\em.war file not found C:\app\I\product\11.2.0\dbhome_1\ctx\admin\dr0ulib.sql.sbs file not found C:\app\I\product\11.2.0\dbhome_1\ctx\admin\dr0ulib.sql.sbs file not …  |
| | Hi, I am trying to generate a spool file through below anonymous block in order to find out views on a particualar table. declare cursor c1 is select view_name,text from users_view; rt c1%rowtype; begin open c1; loop fetch c1 into rt; exit when c1%notfound; dbms_output.put_line(rt.view_name || '|' || rt.text); end … |
| | |
| | A friend asked me to rewrite a program for him. Though the problem is it s using a rdb database, i am assuming this is a dec/oracle rdb database. Which i honestly never used and have no knowledge of. So i was wondering if there is any way to convert … |
 | Dear All, I am in the mid of my career, I am Computer Graduate, I have equal experience in Networking, Oracle Developer and Oracle DBA as well, as my previous two experiences have a kind that I had to deal all of these very closely, now I am at the …  |
 | [This](http://docs.oracle.com/javase/tutorial/essential/concurrency/deadlock.html) is the example i was looking at. The docs say that trying to access the bowBack() method is creating the deadlock , but im new to threads , and i really dont understand why this is happening. In need of some guidance here...  |
| | i want to ask you when i execute the following sql statement SELECT account_identifier,least(to_number(part_1)),least (to_number(part_2)) FROM TEST5 ; i get the following error ORA-01722: invalid number 01722. 00000 - "invalid number" you should know that when i execute the following sql statement SELECT account_identifier,to_number(part_1),to_number(part_2) FROM TEST5 ; it works fine |
| | I have created four tables in apex oracle and I also need to create four statements which display information from all four tables or just a few of the tables, I have tried writing up advanced statements myself but they are not advanced enough, can someone please help? |
 | weather oracle forms language is usefull in mnc's... how will be its job openings |
| | How do you create lists in an APEX form which allow many checkbox selections? How do you store these in database? |
| | Here i am trying to load data from TABLE1 to TABLE2. The requirement is to consider those records in the TABLE1"where TABLE1.COL1=TABLE1.COL1 (OR) TABLE1.COL2=TABLE1.COL2" As a single group and insert into TABLE2 with COL3 with a unique value for each group thus identified. TABLE1 ~~~~~~ COL1 | COL2 1 | … |
| | [this](http://docs.oracle.com/javase/tutorial/uiswing/examples/components/TextComponentDemoProject/src/components/TextComponentDemo.java) is the code i was looking at.Its about how to use JTextPane and related swing text Components along with actions and keymaps. my question is that in this part textPane = new JTextPane(); textPane.setCaretPosition(0); textPane.setMargin(new Insets(5, 5, 5, 5)); StyledDocument styledDoc = textPane.getStyledDocument(); if (styledDoc instanceof AbstractDocument) { doc … |
| | I have desided to go in database line... many people suggested to go for oracle developer course(sql,pl/sql,oracle forms) and do DBA after getting placed in a company as a oracle developer.. weather oracle developer course will be usefull to get a job as a fresher... else what will a better … |
| | Dear Experts, I am facing following problem with oracle 11g while programming. ORA-12505: TNS:listener does not currently know of SID given in connect descriptor System has four database is connecting through sql developer successfully but ohters are not connected. When i am again creating same database for correcting error it … |
 | I am stuck on the final part of the query, I know that this thing is easy, but I am out of ideas now, so sorry for this. I have prepared a query like this: SELECT A.projectName as PARENT, (select COUNT(*) from PSPROJECTITEM WHERE PROJECTNAME = A.PROJECTNAME) parentprojecount, B.ProjectName as … |
 | i'm new to web designing. i'm planning to create the website which will store user information in oracle database. my questing is is it possible to connect oracle 10g to web page(form)? need tips.. |
 | Hello DBAs, Can any one guide me how can i get the last modified date(insert/update/delete) of a table? Regards, B. Mantri |
| | Hi, I typed the below code in oracle 10g express edition. [CODE]SELECT emp_id, last_name, salary, dept_id FROM employees WHERE emp_id = &employee_num [/CODE] I get an error; ORA-01008: not all variables bound Can you pls help? Thanks. |
| | Hello, I need description about ORA error 26759, i tried to check decumintation for cause or action but with no luck, would anybody help me diagnosing why i saw this error on my 11g Oracle DB. Thank you in advance. |
| | Hi, I am new to oracle. I have this following query : SELECT TYP_CD, SUM( INVC_AMT), trunc(ALLOC_RUN_DT) as "Alloc_Date", MIN(ALLOC_RUN_DT) as "Minimum_Time", MAX(ALLOC_RUN_DT) as "Maximum_Time" FROM allocation_header group by TYP_CD, ALLOC_RUN_DT order by TYP_CD, "Alloc_Date" and the sample output I get is : TYP_CD INVC_AMT ALLOC_RUN_DT Minimum_Time Maximum_Time 01 20520232.31 … |
| | I'm not sure if this is the right place to ask , but is this erd valid? Or is it unacceptable? Thank you for any help. |
| | I have created a application which connection to sql server database as well as oracle database The application is working fine at my end And to connect to oracle i used following namespace using Oracle.DataAccess; using Oracle.DataAccess.Client; But when i run the application on user end It gives following exception … |
| | Am trying to add a constant column to the select query which is quering an inner query. Need your help with the query. select *,'1' as flag from ( select ROW_NUMBER() OVER (PARTITION BY e_id ORDER BY birth_date DESC) as rn,wh.birth_date,e.*, xy.m_id from employee e inner join table2 xy on … |
The End.