2,627 Topics
 | |
| | Hello Friends, I am new to .NET and to this forum too. I need to move approx 2K rows from an oracle to SQL server table every week. I am planning to develop a C# console application to achieve this. Any ideas how to start and what is the best …  |
| | Hi guys... I am student of 3rd Year...Soon my final year will be started...I want you guys to suggest me some good and industry related databases project.. I want to use SAP instead of mysql and oracle in my Final Year Project...Actually i want to do project on databases along …  |
| | please I need a sql command similar to decode in oracle becuase am getting an error when i verified as an sql command. below is my code which, please help by correting the problem [CODE=SQL]SELECT dbo.Trans_Head.Doc_Date, dbo.Trans_Head.Document_No, dbo.Trans_Head.Account_Type, dbo.NewAccount.Surname + '' + dbo.NewAccount.First_Name AS Account_Holder, dbo.Trans_Details.Account_Name,SUM(NVL(DECODE(dbo.Trans_Details.Trans_type, 'DR', dbo.Trans_Details.Amount), 0)) Payemnt, … |
| | I am working on an ASP.net 2.0 application written in C#, pulling data from an Oracle 10g database on a remote server (i.e. the application and database are on different servers). The data is pulled via a SqlDataSource control. When I run small, quick queries, everything works fine, but when … |
 | Good day, i am creating a component, with an enum property for the property grid. [CODE] // The DataSources enumeration. public enum DataSources { MSSQL = 0, MYSQL = 1, POSTGRESQL = 2, ORACLE = 3, DSN = 4, EXCEL = 5, ACCESS = 6, } private DataSources m_DataSources; /// … |
| | hi. In the later versions of mysql5.1 we can create an event which can be scheduled accordingly. What is the siimilar way to create in oracle which can be scheduled. Thanks in advance  |
| | please help me to solve this problem,i want to insert data by checking the multiple entries in my form and retrieve the same data, the check box must checked the corresponding field retrieved. |
| | Hi friends... My system is MS WINDOWS XP, Professional Version 2002 Service pack 2... I Want to Connect PHP with oracle... I searched in GOOGLE... Source: [url]http://me2learn.wordpress.com/2008/10/18…[/url] I Followed the steps given by them... but still i'm not able to connect... I installed PHP and APACHE... PHP version: php-5.3.4-nts-Win32-VC9-x86 Apache … |
| | Hello, I am trying to write an sql query in oracle that solves this question: [B]List top three customers from each state that has the most number of orders (4 points).[/B] Here is my query now that is just ranking every customer based on the # of orders they have … |
| | Hi All, I'm very new to PHP and MYSQL and I'm having hard time trying to insert data from PHP form in MYSQL DB. I'm able to echo out the output on webpage but i'm not able to figure out how to insert the data in DB. Please help me … |
| | Hello, Question: List the top 25% of employees in terms of sales. Your list should include employee number, last name, first name, total number of orders, total sales. Here is what I have so far (not sure if my inner joins or even the query is totally correct): select e.employee_no, … |
| | Please let me know how to drop constraints within a table having no names. :-/ |
| | does anyone of you knows a article about ORACLE REPORTS? thanks :) ps: please post the site  |
| | [ICODE]select eid from(select count(*) cnt,eid from certified group by eid)as foo where cnt=(select max(cnt) from (select count(*) cnt,eid from certified group by eid)as goo);[/ICODE] This query displays the eid with maximum no of entries in the table certified. Which in this case is no. of aircraft licensed to an eid. … |
| | Hello all, I’m getting one strange error on my web. The web was developed with spring and has a tomcat pool connection configured for Oracle DB. After upload the web content into the server, when restarting the server and trying to open the web page, first time display error: [ICODE] … |
 | Hi I am working on a procedure to log the users and times of our reports. Our reports are all executed from stored procedures. The generic logging proc which will be placed in the 30+ report procedures. I'm having a problem with getting the start and end times for the … |
| | I'm having a really hard time trying to figure out how to make the following search: "Find the sellers specialized in selling cars of the year (They can only sell cars produced during a specific year, example 2010). The tables I have are: Seller: {[U]Seller_Id[/U], Name, City_Residence} Business: {[U]Car_Id,Seller_Id[/U],Year_car_Produced, Business_Date, … |
| | Hi, I have a table in Oracle. Here is the table. [CODE] SQL> select * from test; SDI NAME ---------- --------------- 123 Tapas 345 PradEEp 567 Jagadish 789 Giri [/CODE] I want write this data into a CSV file. I tried this but i am not able to redirect or … |
| | So I am working on a java project for a college asssignment (im a student ...) and dont know what I have done... but my sub menu (when create, delete find or update is clicked) wont display. what should happen is create is clicked and the sub menu displays with … |
| | Hi guys, I'm trying to get to grips with ADO, so I've installed SQL server 2008 and made a database and placed a table called Computers in it. Now ive got the following class... [code] using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.OleDb; using System.Data; using System.Data.SqlClient; namespace …  |
| | Hi, I m very mew to the oracle. I want to teach transaction and locks to the diploma student. I searched so many examples of these topics from the Google Search engine, but fail to search simple and short example. I understood the topics, but can't find simple example. Will … |
| | there is a procedure which have 6 input parameters, 1 for each. All input parameters are of type char. i need to convert those into respective datatypes and insert the data in table. how to convert char to date and int datatypes? |
| | Hi, we have pl/sql objects.for some pl/sql objects we found the object names in the scheduler list to run it.But we didn't found the some objects to run the jobs. the scheduler contains Object list. if you select one object and click on submit button then it will show u … |
| | I have a calendar and when selecting the date the date format inserted to text box is in the format ' 10/10/2010'. This is not getting inserted into oracle database. Oracle accepts only the format '10-OCT-10' . So please help me to change the format of date that getting selected … |
| | Hi everyone. I want to create a crawler with perl and run it on crowntab. The program should use DBI and DBD::Oracle to insert data into my database. When crontab runs it, I get the following error in my mail box. Can't load '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libclntsh.so.10.1: cannot open … |
| | Hey Everyone, My name is Corey, and I am a Software Development "Greenhorn". I am a 29 year old Business Major who has decided to make a career change to what I really wanted to do, before it was too late. I'm currently enrolled at a state tech school in … |
| | hi guys, i am using the vb 2005 to create an application and i created a database from the vb by adding a new Item(Database). i want to know how can i make the id wich is a number,to take an auto number and not to have to enter it … |
| | Hi, I have one Oracle standalone procedure.In this am doing truncating the data and loading the new data into the target table. The issue is , I want to know whether the table is callable from other procedure,if it it callable I want to know the Procedure or Packages list. … |
| | I HAVE LOADED ORACLE 8i ON WINDOWS XP. IT HAD LOADED SUCCESSFULLY AND I HAD WORKED ON IT. BUT ON NEXT REBOOT WINDOWS IS NOT ABLE TO START THE SERVICE CALLED OracleServiceORCL. WHEN I TRY TO START IT AGAIN IT ENDS WITH AN [quote] ERROR:- Could not start the OracleServiceORCL … |
| | Recently, i found a book online that walks you through various elements of java game creation. The code from the book uses the java3D timer, so to compile the example programs, I had to download and install java3D. At Oracle's site, I selected WindowsXP as my OS and downloaded the … |
| | Hi, I'm new bee to JSP.I'm newly joined in company they want to finish this today please help me. I need to check form field contains existing data(want to check database) are not. if that field contain existing data it wants give alert.., In database i set projectcode as Unique.if … |
| | So, I'm making a new game in Java. I am trying to add networking code. I'm using the code at [url]http://download.oracle.com/javase/tutorial/networking/sockets/clientServer.html[/url] but I want it so that when the player moves in my game, it updates their location in the server and then updates it to everyone on the server … |
| | hey friends...i request you all to pls help me out...im damn confused... im planning to make a website by March,2011 in which i will be using HTML/JSP and Mysql as d/b. however, i have a few doubts abt. Mysql.... 1) on the mysql site, there are many packages available to … |
| | Relatively new to VB.NET coding. Am creating a pretty simple console application that needs to insert over 50,000 records into an Oracle table (OleDB connection). I tried 3 different methods so far: Individual INSERT, insert using a dataset, & using INSERT ALL (commit every 25 records due to # of … |
| | Greetings, I'm having some trouble creating a trigger that, before I insert something in a table, it resets an existing record field to 0. Example I have in the table a field named "Name" and another named "Active". Each field has a diferent ID The last entry of a "Name" … |
| | I have a problem whit load of xml file into Oracle using StringBuffer. I get a java.sql.SQLException error “setString can only process strings of less than 32766 characters”. My problem a cure when I try to bind the CLOB with the prepared Statement in the StringBuffer. There are no problem … |
| | Hello, thanks for your time. Jsp + javaBean will not run in tomcat on local host [url]http://localhost:8080/is/scannerForm/process.jsp[/url], when i run it in eclipse though my local tomcat it actually does work and i can step through the jsp page as-well as the .java pages and i can see where they … |
| | hi, i have two combo boxes one for country and another for state both populated from data base dynamically. [CODE] <%@page import="java.sql.*"%> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>JSP Page</title> </head> <body> <select name="ctry"> <% String city=""; Statement pstm; ResultSet rs; try{ Class.forName("oracle.jdbc.driver.OracleDriver"); Connection connect =DriverManager.getConnection("jdbc:oracle:thin:@172.17.0.14:1521:develop","devuser","devuser"); pstm = connect.createStatement(); rs … |
| | Hi, Hope you can help, a client of mine has a site with dynamically generated URL's, I want to make the URL's SEO friendly, clean them and rewrite them as new keyword rich URL's and then redirect the old URL to the new. I am trying to carry out some … |
| | hi guys, thanks for viewing my thread. Being in oracle for database administration is something awesome. I would like to know on how a bulk of documents in .txt file could be cluster using oracle 10g. The documents all are report which are contain Speaker Name , Report ID , … |
| | |
| | [code] <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <!-- saved from url=(0233)[url]http://employer.dice.com/talentmatch/servlet/TalentmatchSearch?op=201&dockey=xml/5/8/588dc5c2940163a08ac76fd58199497b@endecaindex&cskr=1&ranking=0&FREE_TEXT=oracle%2Boracles%2B&DESIRED_POSITION=%2B&RECENT_EMPLOYER=%2B&SCHOOL_NAME=%2B[/url] --> <html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <title>About Steve Peters </title> <style type="text/css"> #wrapper { width: 318px; } #btnHeader { background-image: url( /assets/images/notes_head.gif ); width: 318px; height: 36px; padding: 0; margin: 0; font-size: 11px; font-family: Arial, Helvetica, sans-serif; … |
| | I have heard that oracle 11i is an ERP,i want to know that what is an ERP??? Is it a database or something??? |
 | I'm trying to find some "common" human understandable resources in regards of memory management, beside resources from Sun/Oracle that are sort hard to digest. There are plenty of short articles and blog entries, but they mostly touch just certain aspects of this subject |
| | |
| | Hi, Is there anyway to insert/add a new column between two column in a table without deleting any other column??? |
| | i want the java methods or the mechanism which will work as that of COMPOSE and DECOMPOSE functions in ORACLE/PLSQL. please help me out. thanks in advance.. COMPOSE-ORACLE [CODE]compose('o' || unistr('\0308') ) [/CODE] would return ö DECOMPOSE-ORACLE [CODE]decompose('é') [/CODE] would return 'e´' |
 | Hello. I'm trying to serialize a class that implements Serializable and a Runnable. My class has a transient Thread object as a field that is created and started after the restoration of my class(object). This is proven possibile by a tutorial from Oracle, [URL="http://java.sun.com/developer/technicalArticles/Programming/serialization/"]here[/URL]. But i fail to compile my … |
| | I want to find out days gap between two dates excluding sunday. How can i do this in oracle. Please help me. |
| | hi can any one tell me how to export and import a table in oracle 9i? please be brief. |
The End.