2,627 Topics
 | |
| | [code]import java.awt.*; import java.applet.*; import java.awt.Event; import java.awt.event.ActionListener; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; //private Connection connection=null; //private Statement st=null; //private ResultSet rs=null; public class Example extends Applet implements ActionListener,Connection { public void init() { Connection con=null; Statement st=null; ResultSet rs=null; String qa="insert into demo1 values(' ',' ',' …  |
| | From where can I download sql plus 8.0? Please help as I have to submit the project tomorrow..:scared:  |
 | [URL="http://www.youtube.com/watch?v=b-Cr0EWwaTk&feature=player_embedded#!"]An Oracle produced song to promote Java; fun stuff[/URL]. ;-) Lyrics at: [url]http://www.adam-bien.com/roller/abien/entry/code_hard_with_java[/url]  |
 | Hi everyone, I've been trying different commands that check inputs that will be entered into the tables I've got. I want to check that Amount/Ename columns can not be NULL. What's <> do in SQL? [CODE] // first command ALTER TABLE Emp ADD CONSTRAINT CK_AMOUNT CHECK ( AMOUNT NOT NULL); … |
| | |
| | Im trying to pull two different account numbers from an ms query on an Oracle DB via ODBC with PHP. The problem is that two of the columns have the same name, e.g. ACCOUNT_NO [CODE]SELECT V_GUARANTORS2.ACCOUNT_NO, V_GUARANTORS2.GUARANTOR_NAME, V_GUARANTORS2.LOAN_NO, CURRENT_LOANS.ACCOUNT_NO, CURRENT_LOANS.LOAN_PRINC, MEMBERS.SHARES FROM LOOK.CURRENT_LOANS CURRENT_LOANS, LOOK.MEMBERS MEMBERS, CU.V_GUARANTORS2 V_GUARANTORS2 WHERE CURRENT_LOANS.ACCOUNT_NO … |
| | Hi friends I have a question about savepoint The SQL statements executed in a user session are as follows: SQL> CREATE TABLE product(pcode NUMBER(2), pname VARCHAR2(10)); SQL> INSERT INTO product VALUES (1, 'pen'); SQL> INSERT INTO product VALUES (2,'pencil'); SQL> SAVEPOINT a; SQL> UPDATE product SET pcode = 10 WHERE … |
| | Hi guys, I need some help from you. I know it's lame to ask for help for college, but for oracle databases we have a professor that really doesn't know how to explain anything. We are learning it all theoretically and nothing practically and now he gave us a code … |
| | i have a query is to lookup CREDIT_CARD table using CREDIT_CARD_ID and get the MIN_REPAY_AMT. if SUM(AMOUNT_DEPOSITED) < MIN_REPAY_AMT for that month Then populate 1000 else 0 i have attempted the query below kindly help me out and i am getting the following error. Error: [CODE]ERROR at line 2: ORA-00923: … |
 | First off, I am a Java Noob coding in latest version of NetBeans. I am trying to create a program the will allow the user to enter two decimal values: time and earnings in a swing GUI. [B]Basic Flow[/B] [LIST=1] [*]The user will enter the values in two different text … |
 | Provide a list of Students in zip code 11214 that registered more than 2 days after their student record was created. what i have so far right now i have it where it checks for if created date after registration date just can't figure out how any points in the … |
| | friends i m using vc++ 6.0 and oracle 10g version.i created mfc file and connected database. i done insert and delete operation.but i cant check or view the data(table).can you any one tell how to do? and any other option 2 view the database thanking you  |
| | hay this is samar here actually i have to get values from tha my sql foe a perticular string which i pass through a xt box i think i'm not able to pass the vehicle no. to the querry this is my cade pls help [code]package p2c; import java.awt.Container; import … |
| | Hi. I am using visual studio with visual basic. I have create a combo box which data is from oracle. I want to know how to check the value in combo box is choose before i proceed to save the record? Thank you. |
| | hi all i m facing problem populating jtable with the data of database !m using arraylist to populate jtable .but the problem is that m unable to add databse data into jtables.i m only getting the last row elements of databse. i should be getting this data in the jtables … |
| | hello every1 actually m new to vb.net, i have installed oracle 9i on my system and i dont knw how to connect even a simple form to my sql table in which i have two fields named first_name and last_name, the name of the table in sql is user. can … |
| | how to call oracle report using form builder on which command button.If i press command button report should be run. |
| | Hi!!This is Chetana... I m TE IT student. I need some good topics 4 the mini-projects in dbms considering vb as front end and oracle as back end(apart from the library,railway,hotel management etc ). Plz help...:S |
| | This is homework. Here is the problem: Produce a list of employee last name, first name and department name. Use appropriate, user friendly column aliases. This is from the tables [ICODE]DEMO.EMPLOYEE[/ICODE] and [ICODE]DEMO.DEPARTMENT[/ICODE]. The relevant column names are [ICODE]LAST_NAME, FIRST_NAME, DEPARTMENT_ID[/ICODE] (from [ICODE]DEMO.EMPLOYEE[/ICODE]) and [ICODE]DEPARTMENT_ID, NAME[/ICODE] from [ICODE]DEMO.DEPARTMENT[/ICODE]. As you … |
| | friends i am learning visual c++ 6.0.i need to know how to connect the database(oracle).can you tell me how to do??.give me some example.... mfc application connect to oracle database,any example ??? thanking you  |
| | I am starting a new project and the certain requirements will be: JSF, JPA, JMS, WebServices Rest and EJB3.1. There will be at least 4 servers. Probably this will be the division: first server for backing beans and JSF. Other two servers for EJB cluster and the last server for … |
| | friends i am learning visual c++ 6.0.i need to know how to connect the database(oracle).can you tell me how to do??.give me some example.... mfc application connect to oracle database,any example ??? thanking you  |
| | Alright, I have a members area, area.php, and I used mysql to find the userlevel and display content depending on the userlevel, 1 for user, 2 for admin. I made it, but it displays both the user and admin for 1, and 2. [CODE]<?php // Members Area // session_start(); $usernamee … |
| | |
| | how do i copy a value from a combobox (vb6) to an oracle(9i) database table?  |
| | Hi, I'm trying write a sql statement that will: show all employee id , name, their wages and the project they are doing if their wage's are greater than average wage. The wage is calculated by the hourly rate which is located in allocation table and hrsworked which is located … |
 | Hi Experts, I have asp.net application already published with x86 ( i am not sure but can not working properly on windows server 2008 64 bit with oracle), through googling i found that i need to change application to Specific CPU through VS2005. There is also solution: To explicitly set …  |
| | i need a sample program to implement synchronization concept for a website... i have an application connected with oracle database. i have to open the same application simultaneously in two visual studio ide to perform the same operation or different operation accessing the same database in a synchronized manner using … |
| | This is probably obvious to someone who is familiar with Oracle, however, I'm writing a script file for a class, and it throws an error on the line [CODE]ALTER TABLE FACULTY ADD CONSTRAINT FACULTY_Locid_fk REFERENCES LOCATION;[/CODE] where the table is FACULTY, the column is Locid, and I'm trying to create … |
| | Hi, everybody! I have a big problem. I don't understand Unix, but I work as a system administrator, and sometimes I make some data exports and I have to delete old .dmp files, but today I had a mistake, I wrote rm * 909* This is a part of my …  |
| | Hi Experts: When i run this page on my online website with mysql (already with Oracle), this errors orrurs. Exception Details: System.Data.OleDb.OleDbException: [1]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'exec print_pack.check_print … |
| | Hi all Experts , I am converting my application from Oracle database to Mysql , i am facing alot of problems, some experts are really helping me , i am thankfull to all those how helping people like me. They actually encouraging us to do more n more. Thanks all …  |
| | Hello, I know this kind of questions sound silly most of the times, but still I need to ask it. I am planning to get a web application done, for my business usage; it should be able to handle a huge DB scenario ( think of retailers DB ), support … |
| | [code]select a.div_amt_alloc , b.payment_dt , substr(c.stk_desc,1,38) from noth_stock_alloc a , nomh_announcement b , comh_counter c, comh_client d where a.ann_num = b.ann_num and substr(a.ann_num,5,1) = 'C' and b.stk_cd = c.stk_cd and a.client_cd = d.REM_cd and rtrim(d.rem_cd) = 'ABC' and B.payment_dt between to_date('01/08/2009}','dd/mm/yyyy') and to_date('31/08/2009',''dd/mm/yyyy'')' order by b.payment_dt;[/code] those query will show … |
 | I have to design a database where one requirement says "For each project, for each user, for each skill, store the marks gained". Initially, i had a table where each skill was a column(proj_id, user_id, skill1, skill2, ......., skill_N) I felt this was a bad design because the number of … |
| | hi. I'm working with php-oracle and I need to do a query that I know will return a unique string, but when I execute the query all that I recieve is a number. Why? this is my code: [CODE] $nombre=oci_parse($conexion, "select nombre_cliente from cliente where cod_cliente=$codigo_de_cliente"); $nombre_de_cliente=oci_execute($nombre); [/CODE] nombre_cliente is … |
| | Just unsure regarding which data type can store data such as multiple language codes e.g. English:EN, Chinese:ZH, Malay:MS and even more in such a format(EN,ZH,MS), is LONGVARCHAR an option??? |
| | What is the difference between oracle and sql? I am new to this field.Please help!!!!!!!!!!!!!!!!!!!!  |
 | Its providing me error................................ [code] insert into products_information values(1,to_timestamp(current_timestamp,'DD-MON-YYYY HH24:MI:SS'),1200,10,1000,12,1100,10) / ERROR: date format picture end before converting entire input string.... [/code] This is making me nuts... Please Help a bit.... |
| | hi. I need to create a table, but I want to set three forgein key each one of different tables. Is that posible to do with oracle? |
| | Hi, I am trying to position a navigation bar from the left side of a div(header) without any padding value(without any space.I would like to position the nav exactly where the content div is started([B]Red line border[/B]) but I do not know why it is not working! Can you please …  |
| | Hi All experts, I am facing problem with mysql view. I have migrated my database from oracle to mysql qith views, View on Mysql is created , but when i try to execute query it takes a long timw , some times it time qout server connection, Any body help … |
| | i have two products , product one has 5 entries of date and product 2 has 4 entries. I want to select max date entries of both... [code] select max(entrydate) from products,products_information where products_information.pno = products.pno [/code] It return a single max date of one product.... Please Help .............. |
| | Hello My task is to write a procedure which has to get information about price of a product and updates the data base for produc_id=777. if product_pirce < 400 then product_price=500 if product_price > 400 then product_price=300 IN PL/SQL: [CODE] create or replace procedure change_price is begin if (select price … |
| | I am looking for query to select the last row of a table. Please help. |
| | Hi, I have a java appllication which has a query depending on the requirement, select EmployeeID, TransactionAmount from employee where EmployeeID IN ('E123','E234') group by EmployeeID; which works well in mysql, but for oracle a get an error like [Err] ORA-00979: not a GROUP BY expression Can anyone help me … |
| | Hi, i work with SQl Navigator and Oracle and i want to buy Mac laptop, but i am not sure if Oracle 11g is going to Work in Mac. So the question is: If SQL navigator 6.2 and Oracle 11g can work in Mac OS. Thank you. |
| | can anyone tell me what field(java or oracle) should i chosse for my better career as i am B.tech I.T student. |
| | Hi, I have a select statement and I need to find a way to apply a filter to it: [CODE] select * from my_table where my_table.field_1 like :filter_item [/CODE] The real problem is that filter_item can be a string, a string that includes '%' or a comma-separated string that can … |
| | Not quite sure if im in the right section but lets try ... In my project i want to use a "Local Database Cache" and sync it with my online MYSQL server. Problem here is, the MySQL data-provider is not showing up when doing the wizzard for the Server/Client properties. … |
The End.