2,627 Topics
 | |
| | I have created a csv file, and display data from database into that file, how can I add a pie chart to that file, this is the code which I made: File file = new File("C:/Users/MY TOSHIBA/Desktop/chart.CSV"); Writer output =null; output = new BufferedWriter(new FileWriter(file)); Connection con = DriverManager.getConnection("jdbc:oracle:thin:@ 127.0.0.1:1521:XE","username","password"); … |
| | Hi, I have a string like this: ABC_STRING_DEF_GHI_JKL. Where the "STRING" part is constant. I am trying to get its corresponding regex pattern. Something like %_STRING_%_%_% So far I managed to get to this point: SELECT 1 FROM DUAL WHERE REGEXP_LIKE('abc_STRING_def_ghi_jkl', '(^(\w[^_])+)_STRING_([^_]+)_([^_]+)_([^_]+)$'); It's not really working, so if you have …  |
| | I did the coding to create a pie chart file in png format file, the pie chart shows the percentage but in the bottom of the file, I want the percentage to appear in the chart itself, This is the codes I have used, String query = "SELECT name,flag from …  |
| | Hello, I am hoping to get some help on a view which needs to be pivoted, I am not sure though. View is in following format: Case CASE_ORDER MANAGER CURRENT_MONTH_CASES FISCAL_YEAR_CASES ------------------------------------------------------------------------------- case_1 1 John 15 84 case_1 1 Jeff 10 80 case_2 2 John 20 90 case_2 2 Jeff …  |
 | Hi there, I am trying to find an explanation for what the `findWithinHorizon()` does. I landed on this page http://docs.oracle.com/javase/7/docs/api/ and I know that the method is part of the `java.util.Scanner` class (isn't it?). How do I find it in the page above please? thanks |
| | Hello, everyone I'm new into databases. I have an Oracle insert sequence that I need to convert to SQL server if anyone could help me to get this to work. I'm not sure if nextval is compatible with SQL Server. Here is the code: // original insert into invoice select … |
| | I am new to sybase. I came to know that i can take contents of a sybase table into a text file using an option called BCP Can anybody here explain how to use BCP in sysbase |
| | Hello, I am trying to compile a Pro*C program, and I am getting a link error "cannot resolve reference to sqlcx2t". I have the libbrary LLIBCLNTSH included in the Imakefile, and have included conio.h in the program. I am not sure how to resolve this issue. I am running on … |
| | Good day? Ive flushed my TP-LINK WR941ND with DD-WRT and it works find. Ive created a Virtual Interface AP for my guest Wifi. Now I want to use the captive portal of Pfsense to work with my DD-WRT Guest Virtual Interface AP. Ive already setup the pfsense in Oracle Virtual … |
| | I am undergraduate student and I have to do a final year project I wish to do something related to new technology ! not frquent idea but i do not konw in which field I have to work I've taken : c, java, web languages(HTML,PHP,Javascript,CSS) , Database systems(Oracle, MySQL), Assembly, … |
| | Hello, I have created an application to a fill a datatable with an OleDb connection which gets data from oracle. This works just fine in Windows 7 and correctly retrieves the data. However whenever I run the application in Windows 8 it gives me the following error: *Error while trying … |
| | ["Objects that are instances of an inner class exist within an instance of the outer class"](http://docs.oracle.com/javase/tutorial/java/javaOO/nested.html) Even though I attempt to create an independent instantiation of the inner class, the outer class is always there because of the statement above. ##Is that ture? If true, then that would also mean … |
| | CREATE OR replace FUNCTION fn_findraise (dept_in IN VARCHAR2, salary_in IN FLOAT) RETURN NUMBER IS salaryraise NUMBER; BEGIN IF dept_in = 'MIS' THEN salaryraise := salary_in * .10; ELSIF dept_in = 'SALES' THEN salaryraise := salary_in * .15; ELSIF dept_in = 'HR' THEN salaryraise := salary_in * .20; END IF; RETURN … |
 | ** Please help me debug the code, I am experiencing error in this part: cmd.CommandText = "select ROUND(((date_from - date_to)/30),0) as months from rental where tenant_id = '" & Me.TextBox9.Text & "'" cmd.CommandType = CommandType.Text It says: Error while retriving record on the table.. There is already an open Data …  |
| | I want to select persons who has orders =<150 tried this query but of course it wrong anyone can point me to the correct one ? using Oracle or SQL select firstname,cost from persons,orders where cost=100 group by firstname CREATE TABLE Persons ( P_Id int NOT NULL PRIMARY KEY, FirstName … |
| | hey I have table that has date column and I want to select just all the sales that hapen in the first three month between 1/1/2012 to 30/3/2012 How I am able to do this select query ?? |
| | I want to dynamically connect a database file(may be MS Access/SQL/Oracle). how can i do that? To make it l'll simpler I want GUI through which user chooses a DBfile and connects backend.  |
| | I did not really understand the benifit of the alias clause... this was in the w3shools tatourial with alias SELECT po.OrderID, p.LastName, p.FirstName FROM Persons AS p, Product_Orders AS po WHERE p.LastName='Hansen' AND p.FirstName='Ola' with out alias SELECT Product_Orders.OrderID, Persons.LastName, Persons.FirstName FROM Persons, Product_Orders WHERE Persons.LastName='Hansen' AND Persons.FirstName='Ola' why we … |
| | I have a trigger(that prohibits the attribution of more than 10000 dollars to a worker that is not manager nor president) that i want to modify. CREATE OR REPLACE TRIGGER restrict_salary BEFORE UPDATE ON EMP FOR EACH ROW WHEN (new.sal > 10000) DECLARE job ename.job%type; BEGIN select job into job …  |
 | Hallo, I have a Java book from before Oracle took over Sun. In the chapter about pictures for buttons etc., the writer suggest to download a free to use icon set from java.sun.com/developer/techDocs/hi/repository Ofcourse this place does not exits anymore and the Oracle site is not clear to me where … |
 | I'm curious. Why is so much code in this forum formatted like this [CODE]if (something) { do something } else { do another thing }[/CODE] rather than [CODE]if (something) { do something } else { do another thing }[/CODE] The first version is harder to read and takes up more … |
| | Hello, I have the following table, for readability I broke down the after every manager for every case number. The last column is the cumulative sum of the second last column. Value for month should ideally run from 1-3 (Like you see for both the cases for Chicago). But from …  |
| | Hi everyone! I am pretty much new to Oracle it has only been 3 months or so I guess and I have a bit of a problem now. I'm running a query which will display the downtime of a machine. It will display the Start/End Time and its difference. The … |
| | hi guys can anyone explain to me what the codes in line 5 and 6 do? How does the WHERE works in those lines? Any explanation would be truly appreciated. Thanks in advance. SELECT LAST_NAME ||', '|| FIRST_NAME AS "NAME" FROM EMPLOYEES E, (SELECT JOB_ID, MAX(SALARY) SALARY FROM EMPLOYEES GROUP …  |
| | I am a little confused about how I am going to update my query in number 1, you may refer to the attachment that I have included for your refererence, the instructions is on number 2 of the printscreen.  |
| | Hi All, We are planning to write automation script to install oracle. Can you please let us know is it possiblw to write any script for the above requirement,if yes please share your thoughts. Thanks, Vas.  |
| | hi guys please refer to the printscreen to see the complete instructions of what I need to do. So far I can now display how many workers are hired before a certain date let's say: workers hired before january 1 1990, the code for this is the following: select count(employee_id) …  |
| | hi guys just wanted to ask how to raise the pay of a worker in sql statement. By the way this is in oracle 10g.  I uploaded the instructions for your reference, thank you for those who will help out. |
 | install problem of oracle 11g release 2 : 1) it wants oracle suppotted passward .what is it ?. 2) i give a password but do not work.What can i do ? |
| | suppose there are given tables that has particular attributes, and for example I need to find how many ordered a specific dish.. example: "How many fried chicken orders were made in 1 month?" How do I do the sql statement for this? Thanks for those who will help. :D |
| | hi guys I really need some help I don't quite understand the instructions in our homework, I uploaded it below for your reference. Please explain to me how to do the things required on the instructions, it's not clear to me at all. Thank you for those who will help. … |
| | Hi everyone, I have a problem with connecting vb.net to oracle database. At first I used VB.net 2010 express, but is does not support oracle so uninstalled it and replaced it with VB.net 2010 ultimate trial edition. Can you please give me some codes on how to properly connect vb.net … |
| | Hi everyone, I have to do an assignment where i need to design my database for now. Later will have to implement it as well. We have to use Oracle for database and I am planning to create a webportal based on MVC architurture. Now I have 2 problems in … |
| | Hi! I'm a 2nd Year IT Student and right now I have a problem in creating an Address Book Program using Java Codes.. It has never been discussed to us in class so i really don't know how to do it but look for it online.. I have used Mr./Ms. …  |
| | Hi there guys I have a question. How do I list names of employees whose salary is the highest for their position (among everyone with same position. I must include the whole name so that's first_name and last_name the name of the table is: employees here are the columns that … |
| | I am able to insert the document with attachments in it as blob into Oracle DB. I am able to download the same document with the same attachments. But When I open it(blob) with Document Builder and write some lines of text in it and convert back to Blob and … |
| | gud morning frends i need ur valuable reply..here is my xml data i want to display dis data in the html table..so i need html code for to display dis data in the form of table.. [xml code] <?xml version="1.0" encoding="ISO-8859-1"?> <!-- Edited by XMLSpy® --> <?xml-stylesheet type="text/html" href="j.html"?> <catalogs> … |
| | Hello, I am facing a problem with the look and feel for oracle forms. I am using the file laf_11112.jar. one Problem is that when we open a window the title bar displayes the text in squares. the language original text is in Arabic. second problem is that we can … |
 | Hi there, I'm supposed to integrate different sources of data into one database. I am given these types of sources: * .txt * .csv * .html * .xls * access file as well. what attributes should I be looking at to construct a global schema because all of them have … |
| | Hello everyone, I'm new here, and reletively terrible at coding, so I was hoping I could get some assistance with a program I've been working on. My assignment is to create a Frame that allows the user to choose where to paint a circle using a horizontal and vertical scroll … |
| | Please help me debug about datetimepicker. I think, the code is written correctly but its not. The program kee[s prompting **ORA-01858: a non-numeric character was found where a numeric was expected** Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim cmd As New OleDb.OleDbCommand 'cnn.ConnectionString = … |
| | **PLEASE HELP ME. THIS CODE WILL RETRIEVE THE SEQUENCE YOU MADE. AND WILL OUTPUT IN THE TEXBOX IN THE NEXT FORM. BUT MY PROBLEM IS THAT IT DOES NOT RETRIEVE/GIVE THE GENERATED SEQUENCE. FOR SHORT NO OUTPUT T__T . PLEASE HELP.** Public Sub getJO() Dim oradb As String = "Provider=OraOLEDB.Oracle; …  |
| | **THIS CODE RETRIEVES DATA FROM THE DATABASE. PLEASE HELP ME DEBUG. I AM EXPERIENCING ERROR CALLED INDEXOUTOFRANGE IN: ** **HERE IS MY CODE:** Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click 'Try Dim oradb As String = "Provider=OraOLEDB.Oracle; Data Source=TRAVELMATE-PC/XE;User Id=cj;Password=me;" Dim conn As New OleDb.OleDbConnection(oradb) … |
 | I got the insert and Delete Data/Row working for my DBMS. The deleteRow method finds the row that contains the same primary key from the database, passed on to the method, and deletes the row. With using the insertRow method, the data I added shows on up on the last … |
| | hello everyone, Ive been trying to alter strings and i am having a very difficult time altering the vlaue after i split them. i understand what i am doing when i split the input(String[] word = phrase.split(" ");), thanks to this site.. and how i am then able to alter … |
 | Hi, i'm a newbie and get stuck with this problem for a few days. I have datatable with two column, line and duration. I want to sum the duration based on the line group. For example: LINE DURATION A1 00:05:20 A1 00:07:00 A1 00:02:10 A1 00:01:50 A2 00:02:01 A2 00:03:45 … |
| | i have a database consisting of a table PROJECT(p_id,p_name,P_manager) i am using oracle 9i as my backend and auto increment is possible only through triggers and sequence. instead i would like to retreive the data p_id onto a combo box. simply put- when i add data into my table PROJECT …  |
| | I have created an application using swing. On clicking a particular menu item, a form is loaded,and after saving it a pdf generates. For reporting, i am using iReport. Here is the code snippet MyiReportViewer.java package sms.ui.ireport; import java.awt.BorderLayout; import java.awt.Container; import java.io.InputStream; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import … |
| | I and my friend are starting aur project based on java . We are planning to create a java based forum software . But we are confused to wheather make it a app on windows communicating a DB server ...Or to make it based on serverlets/jsp etc (somthing like vbulltein …  |
| | Someone told me that even the basic Oracle SQL commands are useful to learn and I can find jobs with it. I will not just learn the basic commands of course, I will do my best to learn it completely but first i need to know if its still commonly … |
The End.