2,627 Topics
 | |
| | 1. I have heard that database is measured in blocks...My question is how the database stores the data in memory device.What it follows to store an entire record??whether each field is stored in different locations or in adjacent locations??? 2. The data is stored in a file called data file..Do … |
| | I want to install a perl module - "Test-NoWarnings-1.03". But while installing its giving a warning - "prerequisite module (Test-Tester-0.107) is not found". So I installed this prerequisite module "Test-Tester-0.107" and then I tried to install "Test-NoWarnings-1.03" .But still I am getting the same warning - "prerequisite module (Test-Tester-0.107) is … |
 | I know that this is probably the stupidest question that I have ever asked but here goes....... I am trying to create a new application in netbeans..... and having no luck at all. First I create a new project called Interactive Campaign Manager by choosing java category and then Java … |
| | I only have experience using pretty basic Oracle. However, I'm now in need of a better understanding of SQL. I'm trying to write a query using CASE statements (as this seems to be the best approach), but am admittedly lost at the moment. Here is what I have as a …  |
| | Hi, I'm getting the following error "" for the query as shown below. Any help is very much appreciated. SET SERVEROUTPUT ON; DECLARE v_CARE_COUNT NUMBER := 0; v_PHONE VARCHAr2(40) := NULL; BEGIN select count(distinct care_level) into v_CARE_COUNT from Table1 where user_id = '100'; IF(v_CARE_COUNT > 0) THEN select phone into …  |
 | hi any one with an idea on how to create user ineterface of sql oracle database.  |
| | hi all, I need one help.i want to give OCA exam the name and number of exam is "1Z0-047 Oracle Database SQL Expert" these is for "10g".But i don't have any material for that.please send me the material for that. only i know the exam topics which i am send …  |
| | I had c# application that has registration form and another from that user use to sigin in into my application i wonder how to check if user its register or not my login form has to textbox username and passpwrd and im trying this code i gusse its wrong can … |
| | [CODE] try { Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger"); if (con == null) System.out.println("Connection not successful"); else System.out.print("successful...."); con.close(); } catch (Exception e) { e.printStackTrace(); } [/CODE] Error: [CODE] java.sql.SQLException: The Network Adapter could not establish the connection at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503) at …  |
| | Hi Sir I Want to Know about Database connection at runtime using tnsnames.ora  |
| | Could you give me some sample code, which was succesfully used before, which contains connecting and taking multi rows result sets via ODBC from Oracle? If you don't have sample code, which books will must be read by me, to rich the best result? |
| | Hello Everyone, I am having trouble getting a display of my program on the JTextArea "DisplayWindow". My code works and compiles but i do not know how to transfer the program to run on the GUI. It is really simple and I just want it to display and accept the …  |
| | 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 friends I am using eclipse and oracle 11g r2 i tried to configure oracle with eclipse "a driver already exists with that name please provide a unique driver name" This is the error I am getting kindly help me to fix this error thanks for your time.  |
| | 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 … |
 | Hi all, yes still a question about the API! I am looking into event handling at the moment (basic things with text fields, checkboxes etc ) and I have noticed that different components generates different events which are in turn handled by different objects. As an example,let's take a checkbox. … |
 | I would like to make clearly that i do not ask somebody to write the code for me. This is useless for me and also annoying for you: I have to do the following task. Create a Java Frame for some functions in my java project. So here is the … |
| | hi I am trying to save multiple images into one ID and I am getting no where ...I am posting the code so for storing and retrieving image (one image)...but need to store more than one ....need some help here ... using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using … |
| | hiii.. I got this strange problem.i m refreshing my jframe after every second.This jframe contains a button called addbutton.This addbutton opens another jframe.and that jframe contains a JComboBox .The problem is after every second the JComboBox is getting refreshed.I dont understand why.Before the user gets time to select any item … |
| | Hi all, as some of you might know the API is my nightmare. I know it's important and therefore I am trying to use it as much as I can. Today I am looking at a program that uses buttons to change the font of some text. So, I have … |
| | 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 … |
 | Hi guys. I decided to post this simple Photo viewer application. Its strictly for beginners, and cab be improved. /** * * @author Neon Tetras */ import java.awt.Image; import java.io.File; import java.io.IOException; import javax.imageio.ImageIO; import javax.swing.ImageIcon; public class ImageViewer extends javax.swing.JFrame { /** * Class constructor: ImageViewer */ public ImageViewer() … |
| | 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 … |
| | Error: Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException at assignment.MainFrame.validateEmail(MainFrame.java:324) at assignment.MainFrame.btnRegisterActionPerformed(MainFrame.java:208) at assignment.MainFrame.access$000(MainFrame.java:19) at assignment.MainFrame$1.actionPerformed(MainFrame.java:80) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252) at java.awt.Component.processMouseEvent(Component.java:6505) at javax.swing.JComponent.processMouseEvent(JComponent.java:3320) at java.awt.Component.processEvent(Component.java:6270) at java.awt.Container.processEvent(Container.java:2229) at java.awt.Component.dispatchEventImpl(Component.java:4861) at java.awt.Container.dispatchEventImpl(Container.java:2287) at java.awt.Component.dispatchEvent(Component.java:4687) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422) at java.awt.Container.dispatchEventImpl(Container.java:2273) at java.awt.Window.dispatchEventImpl(Window.java:2719) at java.awt.Component.dispatchEvent(Component.java:4687) … |
| | 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 |
| | How do i set up netbeans IDE for use on Windows 8 Enteprise Are there any download links?. I want to use netbeans with the latest oracle database in development. ..How will i set up the connection strings to the database in such a case .Finally how can i use … |
| | Hi all, as much as I don't like the API, it is becoming more and more important for me to start using it. I think I might need a guide of some sort which says what's what and what's where, if anybody has one please let me know. Today I … |
| | Dear Team, I have decided to prepare for Oracle certified Java Programmer certification. When i searched in Oracle site, It showed two certifications for OCJP. 1. 1Z0-851 (Java SE6) 2. 1Z0-804 (Java SE7) For the the second exam which is 1Z0-804 they mentioned, we need to pass two exam first … |
| | 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.  |
 | I was trying to install java JRE7 this earlier. I followed the instructions Mike 2000 17 linkedd in another linux thread. In the installation stage of the setup it said to put this into the terminal: sudo add-apt-repository ppa:webupd8team/java sudo apt-get update sudo apt-get install oracle-java7-installer I did that and … |
| | 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 … |
 | I'm a bit confused about the use of "for" in the above statement.( i read the line from the [oracle tutorials](http://docs.oracle.com/javase/tutorial/essential/concurrency/syncmeth.html) ) I suppose a thread has its run() method , inside which there is some code. That code might call a method **of** an object... and by this point … |
| | How can i restore the backup in my portable harddisk in lunx based operation system runing on imb server system x3650 (oracle application and database runing) when my server get's crush. i don't have command on coding at lunix terminals, please let me know the coding if possible.  |
| | 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 all i have log file with size over 45GB and more than 110 million lines and it is stored in server i want to read the file from the server and insert it to an oracle database in another server but it takes along time so is there is … |
| | So I 1. downloaded the odbc drive from the oracle site, "Connector ODBC 5.2" 2. created a user datasource that tested successfully in ODBC Datasources Administrator 3. created a new db in access 4. External Data->More->odbc database->Link ..., selected the datasource i created and got "ODBC - call failed" Data … |
| | Hi, Please advise which database should choose for developer and dba profile  |
| |  booted from a flash drive to go into the live cd mode , there , as soon as i double clicked a flash video , the screen went all jumbled up , and my pc hanged up. later i tried to check it in oracle virtual box , … |
| | 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 |
| |
The End.