2,627 Topics
 | |
| | I have some code that adds and removes rows from html tables, the problem is that it does not save the rows if the page is submitted or refreshed. I also cannot see the added attributes in the source(how can i use them)what their ids and names are, so i … |
 | hai, My requirement is given below. In my application one LOV is there to show Insured names.In that if we query for the name like ahemd's% then it is showing wrong(junk) data..................So,my question is how to add single quote to already existing single quote.........................I tried in many ways but I … |
| | Create a trigger for insert/update/delete to the table shruti. if insert/update/delete happens then trigger needs be executed. |
| | hi all, can someone please help out.i am using php to insert data into an oracle 11g database.i have a table bus which has a foreign key franchisee name,i want when i am filling in the form,at the text box containing the franchisee name instead of inputting anything i have … |
| | I want to draw an image at X Y position when the user click the mouse so I'm using an InternalFrame with layout set to NULL , inside a JFrame with Layout free - using netbeans here is the image class [CODE=java] package myPak_1; import java.awt.*; import java.awt.image.*; import java.io.*; … |
| | Hi all, I am looking for a Software that Creates SAS datasets from Oracle. Can anyone please help me out in finding this. I am looking for a software not the solution. That software can be free or by buy option no problem. Thanks mAg |
| | Hi there, I understand that this question might be better off in "hardwareAndSoftware/LinuxAndUnix/LinuxApplicationsAndSoftware". But the truth is, that it takes for ever for someone to respond to posts there, because I don't think anybody visits that forum alot. Anyways, back to the point... I'm trying to install the Java 1.6 … |
| | [CODE] Class.forName("oracle.jdbc.driver.OracleDriver"); Connection connect =DriverManager.getConnection("jdbc:oracle:thin:@172.17.0.14:1521:develop","username","password"); String qry=("update sample set one=2 where two=3"); PreparedStatement ps = null; ps=connect.prepareStatement(qry); int i=ps.executeUpdate(); if(i==1) out.println("success"); else out.println("failed"); [/CODE] The above code is not working The table is create table (one number,two number); i tried some other queries like select and delete and insert is … |
| | hi , i given code for password validation which retrieve the data from oracle table.... it was validating the first record alone... its not validating the next records... help me to validate ... ............... Option Explicit Dim ac As New ADODB.Connection Dim rs As New ADODB.Recordset Private Sub Command1_Click() If …  |
 | Hi All, I am working in Oracle10g and I have been trying to run the following query, and am getting an error: [B]Query:[/B] [CODE=sql] SET VERIFY OFF VARIABLE emp_salary NUMBER ACCEPT empno PROMPT 'Please enter a valid employee number: ' SET AUTOPRINT ON DECLARE empno NUMBER(6):= &empno; BEGIN SELECT salary … |
| | [B]hello everyone ,,,,, i have an assignment that is difficult on me ,,,, its about ((Normalization)) could anyone help me in doing the assignment ,,,plz plz:icon_sad: "please check the attachment" [/B] |
| | |
| | HELLO, in my database, i have the following table: video_hire([U]vide_hire_id,[/U], hire_date, video_code, Cust_membship_no, returning_date, hire_cost) video_code is (fk) ref: to VIDEO_LIST, cust_membship_no is(fk) ref: Customers IM TRYING TO code a PROCEDURE or FUNCTION TO to calculate the ammount of hire from one customer, and print the total, as well the … |
| | Hi to all I have inserted .bmp files to Oracle DB with Delphi7. There is "save to file" option in Toad when on double click blob field. Now I want to save blob data to disk on Delphi7. How do we do it? Thanks in advance. |
 | I have an installer application I am building in javafx but I can't figure out how to get the operating system it is running on so I can place files in the right locations for each system and so I can customize the interface for each. If anyone has any … |
| | Hi, I was a beginner in java.I was trying to connect to database(oracle) with the deatails user:scott pass:tiger host string: PC0128166 with code as [CODE] Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); connection =DriverManager.getConnection("jdbc:odbc:abhi","scott","tiger");[/CODE] But i was getting the error as [CODE] Exception is ;java.sql.SQLException: [Microsoft][ODBC driver for Oracle][Oracle]ORA-12560: TNS:protocol adapter error[/CODE] problem is the same …  |
| | i installed Oracle 9i.when i go Start->Program->Oracle-oraHome90- i did not get Isql * plus.Kindly let me know the idea.Any help would be highly appreciated.Kindly find the attachment also. |
| | Hello I've got a problem, I have a Oracle db in a Windows 2003 server, the server has already installed the framework 2.0, and in the same server I published a web site in asp.net 2005, and this site should connect to the oracle db, but when you open any … |
| | Hi all, I am new to database and i want the links for Oracle 10g or 11g for Windows 7 64 bit and I want the link for installation steps also. please provide me the link to download the Oracle software and installation steps. I just got a job as … |
| | Hi, I have an problem with connecting Oracle 10g express edition with java. I am accessing my Oracle 10g with the following URL: localhost:8080/apex I am using the following code: [CODE]try { Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:8080:xe","hr","hr"); System.out.println("Connected Successfully To Oracle"); con.close(); } catch(Exception ex) { ex.printStackTrace(); }[/CODE] Is the … |
| | Hye Does the GC clear memory of running threads with no reference to them ? Consider the following code: [CODE] Thread t = new Thread()... t.start(); t = null; . . . [/CODE] Suppose 't' runs forever, and the rest of the program runs forever - will the GC clean … |
| | Hi all, I am new to Oracle TOAD. I just got a job as a database developer in which it deals with TOAD and Oracle. I want a small help in finding a nice tutorial for beginners. I have a little bit knowledge in backend like Oracle only school knowledge. … |
| | I am thinking of designing a database for financial use, that allows to save the expenditures and pending expenditures and give reports about the cash flow and the balance at the banks. the problem is it will be for a non-profit organization and I am voluntarily in this project. I … |
| | I have a vb 6.0 project which uses access as a database. but i need only oracle as database. Will anybody pls tell me how to change it to oracle database. Does it requires the Complete change in the code of the project or only a little changes. i am …  |
| | sir/madam i need a help.......how to search a string from oracle to vb.......my codings are not working properly so please correct it........i attach my codings below... [COLOR="Red"] accse.Open "Provider=MSDASQL.1;Password=tiger;Persist Security Info=True;User ID=scott;Data Source=facultydetails" rsfdcse.Open "select * from csefacultydetails where name= " & "'&name1.Text '", accse, adOpenDynamic, adLockOptimistic If Not rsfdcse.RecordCount …  |
| | Hello, I am fairly new to SQL and PLSQL and am having a problem debugging some code for triggers, the compiler keeps saying that the trigger is not initialized properly. Here is a posting of the code. This is for a homework assignment, but I am lost so I would … |
| | Hi, I have 2 differnt views v1 in one schema and v2 in another schema. I want to combine/join these 2 views. View v1 is in student schema. View v2 is in information schema. This is one schema: student describe v1; name varchar(300); age number pno number This is another … |
| | I need yo draw a shape as attached in the image using Java graphics. I am struggling with the curve part. The curve part is a arc of an circle whose radius and center is known. But I have to paint the region out side of that arc. How will … |
| | Hi, Yes, I am sure you can tell that I am new. I have a few question and hope someone will answer them. 1)I am a little confused as to where to put certain code. If I am doing inventory and I need to have an array does it go … |
| | Hi All. I have developed a cgi script in C/C++ to dynamically create PDF forms with data filled in from an Oracle database. To do this I used PDFlib (version 7.0.1). The submit button on the form submits a FDF file to the server where it is saved via another … |
| | Hello, How to run command SQLLoader Oracle in c#. I try my sourcode for run this SQLLoader, but nothing happen and error "No process is associated with this object.". Please tell me how i fix it. Thanks. This is my code: [CODE] System.Diagnostics.Process process1; process1 = new System.Diagnostics.Process(); process1.EnableRaisingEvents = …  |
 | is it necessary to install any other s/w like apache etc if i have WAMP or XAMP on my machine to connect php with oracle?  |
| | Hello everyone i looking forward to learn j2ee using Oracle 10g platform ... anyone have Tutorials for this. i'd be very thankful for this help. hint..> i use jdeveloper thanks in advance  |
| | Hello, How to import csv data into Oracle using c #. Where data to be imported 3GB in size and number of rows 7512263. I've managed to import csv data into Oracle, but the time it takes about 1 hour. How to speed up the time it takes to import … |
| | Hi, I want to download Toad for Oracle database i.e (SQL querying, access, modification and editing) but the oracle server is in Solaris. I have windows XP OS. How to install toad in windows and connect to Solaris for the DB? Where can i download toad and work with Oracle? … |
| | Hi I'm currently using vb6 and ms access for my database. So far the application runs good, but the rumor (or fact) that access are not powerful enough with multiple access and also it has low data limitation (around 2 Gb), it scares me. I don't want my clients to …  |
| | In oracle database birthdate store as 01/01/47 but in asp.net i used dataset to fetch this record and i get the bithdate value as 01/01/2047 visiual studio 2008 oracle 11g |
| | Hi there, thanks for all the help you're providing overhere to everybody. I would like to know if It is possible to have an auto increment column that is somehow attached to the value of another column. so it keeps increasing as long as that value of the other column … |
| | Hi, I was told to build a application that will encrypt data and migrate data from one database platform to another platform. Please i do not hae a clue where to start from as i am a newbie to database. Any info will be well appreciated |
| | Hi Guys, I am trying to make a simple connection from my desktop(local computer) with Oracle 11g which is installed on windows server 2008 R2.Now I have problems with the ConnectionString. could you please let me know how I set a correct connection String while I have parameters like these: … |
| | i have the table with 100 records at the first time the page loading i want to display only 10 records and the more link if the link is clicked display 10 more records the records are populated from the oracle database i don't know how to use the oracle … |
 | Hello Guys, I'm trying to learn how to use the GridBagLayout manager... but when I write it like the following: [B]JPanel panel = new JPanel(new GridBagLayout());[/B], Java tells me the following: [U]cannot find symbol symbol: constructor JPanel(gridbaglayout.GridBagLayout) location: class.javax.swing.JPanel.[/U] When this didn't work, I tried type casting [B]JPanel panel = … |
| | Hi Guys, I need some help. I don't understand how to do an alter table statement. I had a lab last week that used it and I couldn't get mine to work. [CODE]DROP TABLE ENROLLMENT CASCADE CONSTRAINTS PURGE; DROP TABLE COURSE_SECTION CASCADE CONSTRAINTS PURGE; DROP TABLE COURSE CASCADE CONSTRAINTS PURGE; … |
| | Hi all, Firstly- I've written a PL/SQl procedure to what I'm asking about in this posting. However, I'd like to do it with a single(or nested) SQL selection statement (I don't think its possible, but I'm no expert and was interested to hear if anyone has a solution- or just … |
| | Please send me the working link of 'free downloading oracle9i' and steps for downloading it. Thank you! |
| | Hi to all, table name: mail email name [email]abc@gmail.com[/email] abc [email]def@rediff.com[/email] def [email]pqr@yahoo.com[/email] PQR [email]xyz@daniweb.com[/email] XYZ ======================================= QUERY: List all email and names in lower letters without any blanks. ======================================== I ran ltrim(), rtrim() and lower() function on data successfully. But fail to retrieve this data. Will you please help … |
| | I was trying to solve this query: [B]Find all the students who have taken the course taken by a instructor named 'XXX'.[/B] Well the division operator of relational algebra can do it easily. I want to know how to use the division operator in sql(if there is any) or any … |
| | [code]{ sqlplus -S ${DB_LOGIN} << eosql set echo off; set feedback off; set heading off; WHENEVER SQLERROR EXIT FAILURE; ${1} }[/code] can i pass the qurey as a prameter to this function? will that query get executed if the query is echoed as ${1}? |
| | //Hi, //i create following table Table name : person ID AGE FNAME LNAME 1 10 Geek Greek 2 20 Seek Bells 3 30 Creek Dells 4 40 Sreek Sells[/B] // I wrote following procedure which is run successfully. Create or replace procedure proc1 as cursor person_cursor (pAge number) is select … |
| | Hi I have not installed mysql on my own, its the default one that is coming with fedora14 at /usr/local/mysql I am giving you some screenshots, please check if you can find out something. ********************************************************************************************************************************************************* The first issue is while I login using command mysql -u root -p it asks …  |
The End.