2,627 Topics
 | |
| | hello all My question is, At, the server side i m using 10 G and at the client side i m using 9i when i use export utility then it create the dump file but when i try to import it then my command prompt doesnt show any progress of …  |
 | Hello All, I have a sorta unusual problem (not too sure where to post it either), it goes like this: I am currently using MS Visio 2007 to Reverse Engineer some tables in an Oracle database, MS Visio lists the tables using unprintable characters (lots of little squares). Because of … |
| | i want to know tht how to overwrite data(Tables) with existing tables in oracle database. first i imported some tables using .dmp file then some table_names was in tht .dmp file. then again i run tht import command with tht same syntax now tht showing some tables are already exist … |
 | Hi Guys, I have imported a CSV file into the database and i want to write some functions to ensure that when data is loaded in that all spaces are removed from certain columns. For Example: In the Phone No column the numbers can appear as follows 07712345678 077 1234 … |
| | Hi i'm a newbie in pl/sql and i need some help from the experts. I'm a vb programmer. Just want to ask you how do you do this in pl/sql? If I log in on my account my username should appear in a textbox. From this LoginForm I have 2 … |
| | I am having problem in connecting Oracle to Netbeans. I am using Oracle 10g EE 10.2.0.3.0 and NetBeans 6.9. I have attached an image that will explain the problem. Please help! Thanx |
 | G'day everyone, I'm doing at a tutorial on Oracle website and still following it so far. I have come across this formatter "%,8d" and can't seem to work out how it works. I know it's adding a coma to the integral number. The thing that I can get my head … |
| | [CODE] CREATE TABLE Query3Ans( dname char(20) ); CREATE VIEW deptNonPhDs(dept, numNonPhDs) AS SELECT dcode AS dept, count(*) AS numNonPhDs FROM instructor WHERE idegree != 'PhD' GROUP BY dcode; INSERT INTO Query3Ans( SELECT d.dname FROM deptNonPhDs dp1, department d WHERE dp1.numNonPhDs >= (select max(dp2.numNonPhDs) FROM deptNonPhDs dp2) AND dp1.dept=d.dcode ); select … |
| | I am trying to fix my mom's laptop. It's a dv6000 series hp. It was running slow and having problems. then I took it home and it would boot poorly and I did a system restore. it now wont boot. I tried to wipe the drive and reload the os. … |
| | Hi all when I run commend : "C:\LJava\project\KTest2>java -cp .;org.freixas.jcalendar;.\build components.KTest2" my code runs well I then made a jar file with the command "C:\LJava\project\KTest2>jar -cf KTest2.jar .\build\components\*.class" my MANIFEST.MF 's content is : Manifest-Version: 1.0 Created-By: 1.7.0 (Oracle Corporation) Main-Class: components.KTest2 but when I run command "C:\LJava\project\KTest2>java -jar KTest2.jar" … |
| | I'm trying to make a table and mysql is giving me this error: [QUOTE] #1005 - Can't create table 'likes.users' (errno: 150) [/QUOTE] That would be great to see a website that explains mysql errors like this for oracle [url]http://ora-code.com/[/url] [CODE] CREATE TABLE IF NOT EXISTS `users` ( `user_id` int(2) … |
| | Hi All, I'm stuck regarding to grab connection from app.config file...i'm surf many type and kind to do it..but still can',t.....i need to connect into two database (oracle n firebird).....how to do this..hope u all can help me....tq |
 | Dear Experts, Thanks for your time and help. I am using oracle in my application with ASP.NET and C#, My query is ok but it is going to ELSE Condition. (Goes to green line) Please Help me to solve this issu. [CODE] <%@ Page Language="C#" ContentType="text/html" ResponseEncoding="iso-8859-1" %> <%@ Import … |
| | i want to knw that how to decrypt stored password in oracle database..  |
| | Hi everyone, I hope you can help me with this. I have everything in my code working properly except for the fact that the payment amounts are being displayed in the command window and I need to display them in the text area, as well as adding scroll bars to … |
| | Hi, i need to retrieve the combo box value to the string parameter in the same page parameter for checking condition is it possible in JSP ? [CODE] <%@ page import="java.io.*"%> <%@ page import="java.sql.*"%> <%@ page contentType="text/html" pageEncoding="UTF-8"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <%@ page language="java" session="true"%> …  |
| | I am getting java.lang.nullpointer exception for this code plzz help me out all database linked programs are creating same error [code]import javax.servlet.*; import javax.servlet.http.*; import java.io.*; import java.sql.*; public class retser extends HttpServlet { Connection c; Statement st; ResultSet rs; ServletConfig config; public void init() { config = getServletConfig(); try …  |
| | Hi everyone!!! I wanted to know the incorrect values for oracle data types. like for example, string data type cannot accept ' value. What other values does string data type does not allow.? and what about other data types like number, float. Thanks in advance.. |
| | I'm creating a game in which I draw polygons of varying sizes and shapes using awt/Graphics2D. To smooth out the polygons, I want to use series of cubic Bezier curves to make smoother edges. I spent some time poking around the Java awt and swing classes and saw the Bezier … |
| | Hey buddies i want to know tht How can i redirect my sql query result to text file using sql command. |
| | [B]My project is Housing reservation system for University I design the interfaces by VB and connect to my oracle data base account Oracle 11g, VB express edition are used The proble is with the login form [URL="http://im20.gulfup.com/2011-12-23/1324652639153.png"]http://im20.gulfup.com/2011-12-23/1324652639153.png[/URL] when I debug and enter the ID & password for User : according … |
| | Hi, I am using php mail for sending an email for contact us form. Given below is the code for contact us form. Please let me know how to send these information in table format. [ICODE] <!-- Document : contactus Created on : Aug 26, 2011, 2:15:27 PM Author : … |
| | I need to know how to calculate in c++,using oracle.In this case i must know how to join table.Can I know how this can be done. Thanks. Anjana89 |
| | Hi, I am using SQL Plus Oracle 10g and sometimes when I ran a query such as: select * from employees; some of the columns were cut-off in the results because the table contains too many columns. So my question is: how can I let all columns be displayed in … |
| | This may be old error but I stuck here.. I created java database applet for oracle database. I am going to put this applet in Local Network. My applet works fine in Eclipse and Netbeans but when I run through 'appletviewer' it showing an error : [ICODE]Error e java.security.AccessControlException: access … |
| | My teacher has assigned us a HW to do and I can not seem to figure out how to group the results the way he wants them. What we have is a database of properties and owners. He wants us to generate a report that contains only the Owner names …  |
| | Unable to load DLL 'OraOps9.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E). Following is my scenario: 1 - Previoulsy I had Oracle 09 in my asp.net 4.0 applicaiton working fine on Windows XP. 2 - I updated the windows to windows 7 and installed Orcale 11g. … |
 | hy.... how to get year now and 10 year before with query result is 2009,2008,2007,2006,...... thanx.. |
| | hi can i reset my password and user name for oracle 10g i lost all users and user default it can not log using system . sys or scott at moment plz how i can rest password i have to do project and i cant acess to sql plus |
| | In going through some homework, I was able to do some of the problems, but not others. For example, one problem was "Produce a list of employee last name, first name, job function, department name and department location. Use appropriate, user friendly column aliases." I finished this with this code: … |
| | 1.Procedure named *ship_order* that will accept an order# parameter. It should verify that the ship date for the order# is null and each book ordered has a sufficient quantity on hand. If every book is available, the quantity on hand for each book should be decremented and the ship date … |
| | Hello, I am currently working towards a computer science degree. I am interested in both software engineering and database administration, but I am not sure which I will prefer as a career. I am considering working on an Oracle certificate, just to get my feet wet, and see how well … |
| | Dear community, On a quite regular basis, the screen of one of the laptops I use [COLOR="red"]blinks for a fraction of a second[/COLOR]. It does it like with some screen capture softwares when they are triggered. Besides, I'm observing from time to time some strange behaviour: [COLOR="red"]Command windows that open …  |
| | Hey guys! I created a facebook type program. The user may load an image, tag the image, and remove tags. I've done the loading of an image, now I'm working on tagging the image. My problem is how do i make it so that when I click the "Tag photo" … |
 | Netbeans is a free, open source IDE for developing software in Java. It's been around for almost 15 years, having gotten its start around the time Java began. Version 7.0 is about to be released, and I got my hands on the Beta release of this new version. In the …  |
| | Hi all, I really need help for fixing one of the issue in my project. We have a passenger table which is used for Airlines operation. We need to sort the passengers by their seat numbers. Seat numbers are in format <1/2digits><1Alphabet> eg: 1A, 1B, 1C, 22A, 11B, 24D, 9A, … |
 | I used to write PL/SQL programs in oracle 9i.Since windows 7 doesnt support it, switched to oracle 10g express edition. All my SQL programs are alright. But I cant put mutiple queries on a single run though. Like insert into many rows. But PL SQL programs are going crazy. Too … |
 | Hello all. I have never updated a single column in a specific record. I am using Apache derby embedded database. I have used the update prepared statement to up date a single field with the String value but it updates all the like of every record. How can I update … |
| | This is homework. I have to create two tables with certain constraints. However, I keep getting syntax errors, and I really have no clue exactly how to format it because there are so many different 'templates' out there. Here is what I have so far. [CODE] create table Departments (Department_ID … |
| | I'm having a issue of a variable I'm setting in my PL/SQL Program. I'm subtracting two Number Data types and dividing those by the lower number to get a percent change. Now, for instance, that number is a 2.5. How can I assign that to it's correct value in the … |
| | Hi All, I am updating a column in a table through SQL+ using Select to_char(systimestamp,'YYYY/MM/DD-HH24:MI:SS.FF3')from dual; The same field when updated through an application has a time offset of 4hrs. Select dbtimezone from dual; returns DBTIME ------ -04:00 I want to form a statement which will update the field with … |
| | friends i create mfc application and create two table -same database,same content. ex:table content(table 1,table 1) employee id,employee name,department,salary,mobile no. now i view data from table 1 and that data to insert on table 2. i doing many way,but i didnt done.please any one can help me? this operation only …  |
| | Hey guys! So, created a File Chooser that gets a picture. And I want the program to display the picture on the jFrame. How can I accomplish this? I'm using NetBeans, and I'm still kinda new to it :P Thanks guys! :D Here's my code: [code] import java.awt.image.BufferedImage; import javax.imageio.ImageIO; … |
| | Hi All, I am trying to copy recordset in excel file. When i execute the query in toad it is obtaining 12 records. But when i use ADODB.RecordSet it is returning only one record. Please help me in fixing this.. Set objRec = CreateObject("ADODB.Recordset") objRec.Open SQL, curSession When i return … |
| | Hello, folks. Well, I can't get my head around that particular function. I want to calculate and then return the total amount of hours assigned for a given stage_no. I got confused. Do I have to use COUNT(*)? [CODE]CREATE OR REPLACE FUNCTION total_numbers_hours(hours NUMBER, stage_no NUMBER) RETURN NUMBER IS return_val … |
| | I cannot figure out why i have this error.It may just be a missing semicolon but i can't find where. Here is my code:(error occurs in many lines, so i can't show where exactly is the problem) /* * To change this template, choose Tools | Templates * and open … |
| | I am working on an application in which I select a color from a color selection dialog and click on a graphic shape to change its color. Everything is working fine, but now I would like to change the default arrow-shaped cursor to an eyedropper shape when I am in … |
| | Hi, I am facing OutOfMemory exception in Java, Kindly help me to resolve this issue, really appreciate your help [U][B]ERROR: [/B][/U]java.lang.OutOfMemoryError: Java heap space [B][U]CODE:[/U][/B] [CODE] public Blob getBlob(String databaseInstance, InputStream inputStream) throws SQLException, Exception { applog.info("Entering getBlob"); InputStream stream = null; applog.info("inputStream : " + inputStream); stream = inputStream; … |
| | Hello everyone, I'm working on a little project that use c#, Oracle ODT and asp.net, so, my problem is that i dont know how to convert or store the data retrieved from a sql that is a sequential and then use in other query in the same project. This is … |
| | Hello I found this : [CODE]INSERT .... ON DUPLICATE KEY ...[/CODE] What does [B]'ON DUPLICATE'[/B] mean ? Thank you |
The End.