2,627 Topics
 | |
| | Hi Please hang on with me on this one, I would appreciate any advice or insight please.... I come from a coldfusion background, where setting up a connection to a database (Oracle, MYSQL SQL Server etc) was was easy as filling in a few fields in the datasource screen in … |
| | [CODE][/CODE]I was having trouble wording my title. I'll try my best to describe my problem. I'm a SQL newbie, so go easy on me.. I'm trying to match records that "doesn't exist" between two relational tables. For instance, if I have two tables. [CODE]Table 1: Client_ID Client_Name Table 2: Purchase_ID … |
| | Hey guys! I've created this program that allows the user to get a .txt file from anywhere in the hard drive and it displays the contents in the text area. My question is: how can I edit my code so that it only allows picture files to be selected(jpg and …  |
| | Hi! I’m have been following the JAAS turrial: [url]http://download.oracle.com/javase/6/docs/technotes/guides/security/jaas/tutorials/GeneralAcnOnly.html[/url]. And the program works fine when I compile it from the command prompt in Windows. But when I try to compile and run it with eclipse it gives the error: Error: Could not find or load main class java. I think … |
| | Hello programmers, 1. could give me an[b] example code[/b] how to set up username and password for the service, which have been created using wsdl file, which has been given from web service creators on other side of the world. Web service client has been created using NetBeans IDE. When … |
| | I am having a table in oracle without a primary key and table is having 5 columns. Every time while making the insert, i have to ensure that the same combination of records are not bing inserted. For every row if a specific value has been inserted then a common … |
| | Hello people, I want to create 'Voyageur' table that references a successfully created table which name is 'Categorie',. But I get this error message when I click on 'run': [COLOR="Red"]ORA-02438: Column check constraint cannot reference other columns [/COLOR] Here is my 'Voyageur' Table that makes me a problem around its … |
| | I have a problem using the oci_execute function in php. I start by initialising my query then oci_parse it and then oci_execute it. Everything works fine. And data are being inserted or modified in my database. The problem is that these data are inserted randomly. If I have a query … |
| | I am trying to publish my ear and war modules into Oracle weblogic portal 10.3.0.0 server using workshop. I am using pointbase DB. But publishing failed since I was getting the following error, weblogic.application.ModuleException: Exception preparing module: EJBModule(netuix.jar)Unable to deploy EJB: ProxyPagePersistenceManager from netuix.jar: Exception while attempting to deploy Security … |
| | I have a problem making a select tag in php code dynamic. I'm creating a website (homework) using php and connecting to an oracle database which has all the info needed. Each agency has a list of vehicules. I created a select option tag for agencies and for vehicules. I … |
| | |
| | hi ! below is a simple html code which lets a user input a value and then passes it to a php program which runs a sql querry againt an oracle database displaying the result set. what I would like to do is to be able to offer a drop … |
 | Hey All, I am looking to develop a web application on the Java platform with Oracle 11g database. I asked one of the dealers for a quote & the quote is for "20 users". I don't really know how this works, but will I be requiring a license for 20 … |
| | Hey guys I am new to this site, so I would like to say hello to everyone here. So, the title was posted as job situation/IT career advice. I wanted to hear some people give me some advice on the IT career field. Background: I am currently a senior at … |
| | Hi everybody, Actually I'm trying to learn C# by myself, and I was thinking to create a small program, I was thinking to build 4 buttons, First, Next, Previous, Last. I'm using Oracle express database. I tried my best before posting here, and this is my code for next and … |
| | hi! I need to populate a flex combobox with the result query of a oracle db, using coldfusion. I have this code, but it is not functioning: my flex webpage: [CODE] <?xml version="1.0" encoding="utf-8"?> <mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute"> <mx:Label x="230" y="36" text="Selecionar Consolas"/> <mx:Script> < | I have installed SQLPlus on my ubuntu 10.10 and now I want to install Oracle server.. I was following a tutorial on that and at the end of it, I got lost because I don't have access to certain files that were mentioned in the tutorial and I changed permissions … |
| | I just wanted to know what famous algorithms that you should have in hand? or be familiar with? or That is always used?  |
| | Hi, I just want to know from everyone if they have problem on auditing? |
| | Hi guys, hope you can help. I'm creating a mixture of an employee scheduling system with elements of a Human Resource Management System for small to medium businesses. I ideally want to create a java application with a database backend, which I'm trying to see if I can apply sql … |
| | Hi, I have this requirement that I have been trying to solve for a couple of days now. I have this source DB. The objective is to extract data from this source DB and insert into a oracle table. The meta data for both tables are the same (1-1 mapping). … |
| | hi.. i know little bit about the casting in java ie (from "float"to "int" or/etc) like wise my question is how the oracle converts the data in condition this is my sample query branch -t branch_bnk_code number3 branch_brn_code number3 branch_city_code number3 mybranch -t mybranch_bnk_code varchar2 mybranch_brn_code varchar2 mybranch_loc_code varchar2 by … |
| | Hi, I have two tables. Cla_case cc and Cla_event ce. The join between the two tables is on cc.cla_event_no = ce.cla_event_no. In cla_case i have the following columns : Discover_date and Notification_date. In cla_event I have the column Incident_date. I need to perform a SUBQUERY that will find the latest … |
| | Hi I have WAMP server 2.2a server installed on my windows7. I encountered 403 Forbidden error when i run [url]http://localhost:8088/[/url] The weird part is if I go to [url]http://localhost:8080[/url] i can access my oracle 10g express agreement page and go back to [url]http://localhost:8088/[/url] to access my php info page. No … |
| | Hello, I'm trying to make a chatting app just for educational purposes, to improve my skills and I got a question, or maybe a problem. Look at the Code first: [CODE]/* * To change this template, choose Tools | Templates * and open the template in the editor. */ /* … |
| | the problem im faceing here in my code is The events that i want to happen are not occuring after i select an item from the combobox,and also all other components are showing the same faulty behaviour. the faulty behaviour that they are showing is they are not firing the …  |
| | Procedure is created on SQL server inserting the data from sql server to oracle databse When individually run the query it executed in 10 sec When run through procedure it takes sometime 1.5min and 5min [CODE] CREATE procedure sp_Trade_Book as Begin SET NOCOUNT ON BEGIN TRY --Begin of TRY BLOCK … |
| | The below query is updating all the rows in the table1 eventhough the inner query only selects few of the rows. Any help. Appreciate it. Thanks, UPDATE table1 out SET (col1, col2, col3) = (SELECT col1, col2, col3 FROM (SELECT col1, col2, col3 FROM table1 in, table2 a, table3 b … |
| | Hey everyone, Is this the right way how to make a trigger in Oracle? [CODE] CREATE OR REPLACE TRIGGER "TRI_AMOUNT_REDUCTION" BEFORE INSERT ON "PURCHASE" FOR EACH ROW BEGIN IF (:NEW.CLIENTNO =SELECT C.CNAME, T.CLIENTNO, T.TOTAL FROM CLIENT C, ( SELECT A.* FROM (SELECT CLIENTNO, SUM(AMOUNT) AS TOTAL FROM PURCHASE GROUP BY … |
| | Hey everyone, I'm trying to count all Purchases and find ReceiptNo the ones that start with '434'.. [CODE] Select count(p.purchaseNo) from purchase p (select INSTR(TO_CHAR(p.recceiptNo), "434") >= 10; [/CODE] But this line doesn't only select all receipt number starting with 434.. it selects all receipt no that has 434 in … |
| | Hi people, i have a degree in computer science with two years working experience and am interested in Database administration (preferably oracle database), how can i achieve this and become a database administrator? should i take oracle certification or is there any alternative that would make me a pro in … |
| | [CODE]<% String Username = request.getParameter("USER_ID"); String Password = request.getParameter("USER_PASS"); String Mobile = request.getParameter("Mobile"); String Address = request.getParameter("Address"); String sql = ""; { int LoaiSubmit; String DriverName; String connectionURL; Connection con; Statement stmt; LoaiSubmit = 0; LoaiSubmit = Integer.parseInt(request.getParameter("LoaiSubmit")); DriverName = "oracle.jdbc.driver.OracleDriver"; connectionURL = "jdbc:oracle:thin:@"; con = null; stmt = null; …  |
| | Hello all! I'm helping my employer redesign their database system. They're currently using MS Access exclusively, but they are updating their computer systems to Apple machines and want to convert to a standalone application to access a background database (e.g., a standalone Java program using JDBC to access a background …  |
| | Can anyone see anything wrong with this statement? [CODE] CREATE OR REPLACE VIEW V_DEPT_AMOUNT AS SELECT DEPTNO AS DNO, DNAME AS DNAME, MAX(AMOUNT) AS MAX_AMOUNT, AVG(AMOUNT) AS AVG_AMOUNT, MIN(AMOUNT) AS MIN_AMOUNT, SUM(AMOUNT) AS TOTAL_AMOUNT FROM DEPT D, EMP E, PURCHASE P WHERE D.DEPTNO = E.DEPTNO GROUP BY DNAME, DEPTNO; [/CODE] … |
| | Hello, I am using Delphi2010 and TOracleDataSet to access tables in Oracle. My question is how do I insert rows to multiple tables? I was told to use the AppendRecord method. Here is an example: [B]Example of value statements (this has been shortened obviously):[/B] Suffix := trim(edSuffx.text); Salutn := trim(edDear.text); … |
| | hi i have the table in which date valve is like this [COLOR="Red"]11/11/2009 6:08:29 AM[/COLOR] how can i compare the value or select them , the to_date is working in SELECT but,i want to select the records using this colmn and by giving value ie:[CODE]SELECT * FROM SENTMAIL WHERE SENTMAIL_SENT_DATE='01-OCT-2011'[/CODE] …  |
| | Hi All, Is there any Mechanism similar to "Oracle AdvancedQueue" in Altibase database...? Any one have idea about Altibase database please help. Any help will be appreciated. Thank You. |
| | I'm download oracle Database 10g from oracle web site , how i can install it On Ubuntu by details plz |
| | I made a basic JUnit test to set up this oracle database on my computer with hibernate. The database works and everything, but trying to hook it up to Hibernate is proving to be a challenge. My config file is below: [code] <hibernate-configuration> <session-factory> <!-- Database Connection Properties --> <property … |
| | Hey everyone, I have been looking for video tutorials on SWING class and pretty much of GUI side in Java .. I found tutorials on Oracle site but they require lots and lots of reading.. if anyone knows a good site that has videos on GUI, please share it.. Time … |
| | hey everyone, I'm trying to get my head around this Question but it is not making that much sense .. Each receipt is issued from a receipt book whose number is encoded in the first three digits of the ReceiptNo field in the PURCHASE table. For example, the receipt numbered … |
| | Hey, [CODE] CREATE OR REPLACE TRIGGER "TRI_AMOUNT_REDUCTION" AFTER INSERT ON "PURCHASE" FOR EACH ROW BEGIN IF (:NEW.CLIENTNO = 122336) THEN :NEW.AMOUNT := AMOUNT * 0.1; END IF; END; / [/CODE] I have a query that selects my top client then want to pass the clientNo to the trigger. Is it … |
| | Hi, i have 3 tables in oracle sql developer (packing, detail, header). I need to update the packing table's part no with header table's part no. But header doesn't contain the serial id hence i need to refer to detail table for cross reference. I did like below, but it … |
| | Hey everyone, I'm just wondering if there is a way to get around this problem. I'm running SQLplus on UNIX server and SSHing into the server. Whenever I query Oracle DB, a list of results/bunch of tables comes up but I can not scroll up to the top of tables..... … |
 | HI Guys These days I am checking whether amount is correctly upload into one of our table its located in oracle database below query used to check this . Select * from Amount_Paiad where CusID IN ('34343','34343','090094') There is no issue in query.Problem is how many values I can enter … |
| | hello everyone... could anyone tell me how to store images in oracle database..or which datatype has to use for it.. |
| | [B]Here is the [COLOR="Red"]Oracle[/COLOR] site from where [/B]I tried to learn JSP [URL="http://192.9.162.55/products/jsp/html/jspbasics.fm2.html"]http://192.9.162.55/products/jsp/html/jspbasics.fm2.html[/URL] But after following all th instructions and creating folders as per site I got a big error- HTTP Status 500 - -------------------------------------------------------------------------------- type Exception report message description The server encountered an internal error () that prevented it … |
 | Dear all, I have problem i have table name "WO" in oracle db i want "Whenever I start my program, I want it it look at all the works orders, and if any works order has a date that is exactly one month before today's date, then I want the …  |
| | Anyone know how to install Oracle Sql developer on Mac? |
The End.