1,488 Topics
 | |
| | Hello Everyone I'm currently busy doing a program that can capture sales, and evrything is working fine at the moment. The only problem is that in the stock table I can't update the quantity(when the company purchases stock), and also can't decrease the quantity(when they are sales). If I were … |
| | hello exprts!! i am new 2 database!!! i have oracleXE and jdk 1.6.0_14 installed on windows XP!! i want 2 connect them via my java program.but i am gettting errors after executing the program. my code is: [code=java]import java.sql.*; //import oracle.jdbc.*; //import oracle.jdbc.OracleDriver; public class OracleConnect { public static void …  |
| | i have oracle 9i. my friend created some tables and inserted few records in each. I want these tables with the records inserted. which files should he send me and where should I place those files? will that affect my existing tables? |
| | Hi, I am not able to logn in sqlplus.. while I can logon with the same username and password in Enterprise Manager... EM- username: sys password: ***** option as sysdba.. but with the same username and password i am not able to logon in sqlplus.. can anybody tell me the … |
 | hello, I am not getting which SQL statement should be used to insert multiple data at a same time without writing [ICODE]insert into...[/ICODE] again and again. suppose whenever i want to insert data into 'customer' table then i may write statement as [ICODE]insert into customer(c_id,c_name,c_city,c-street) values('C101','Hayes','Downtown','Main')[/ICODE] But it will create … |
| | Hello Folks, I'm a not an expert in Oracle/SQL Server query and need some guidence and help from the professionals. Basis for my challange is that I have two tables that i need to collect data from. The main table is ACTIVITIES...secondary table is CODESET... Fields (column) To collect/ are... …  |
| | Dear Programmers, How can I dispaly and insert other language (Arabic/hindi/bangla/chinees etc) through form level field at run time window directly by keyboard???.  |
| | |
| | Hi Friends I am working as an asst. DBA in a Software Company. I am using SQL SERVER and Oracle 9i both to create and maintain database. I am also pursuing my administration in Oracle. I usually analyze that most of the companies with high profile are using Oracle and … |
| | I have to create a report based on the customer for particular order. For example find all the customers who ordered an item ‘ABC’ for current month and look back 11 months to find out if the same customers ordered the same item and list all the customers who ordered … |
| | can some one help me, i have used redhat enterprise server 4.0 for 3 months now i want to set up an oracle server what do i need to install such that he server can be accessed by every one in my network? Thank you,. |
| | Hi, I am wondering if anyone here has ever attempted to connect to the oracle 10g xe database from visual web developer? I have been trying to do this all day, however it is starting to get really irratating! I have downloaded the oracle dataacess dll, and imported it into …  |
| | Hi There. I am newbie. I need some helps on the below issues. Please help me! 1. How to create / delete user in Sql / Oracle? 2. How can I set privilages while create a new user? 3. How can I view all forms / tables? 4. How can … |
| | i need a source code of LIBRARY SYSTEM or a RENT A CAR System plz help me. the code should be written in oracle. thank you. |
| | I m trying to execute the sdo_migrate.to_current method like this : [CODE]execute sdo_migrate.to_current('tablename');[/CODE] but i keep getting invalid sql error, and i dont understand why. Please help |
| | Hello, I have developed a web based application using jsp and connection as Oracle 9i database. The problem encountered is that whenever I am opening any jsp pages, a session is being created in the database which even after being killed did not disappear. In fact it should be that …  |
| | I create an application with three threads(access oracle database by bde tquery) main program:random select,insert data;cycle:10S thread1:random select,insert,delete data;cycle:10s thread2:random select;cycle:60s thread3:random insert;cycle:20s five errors occur between 24 hours,longest interval:12hours;shortest interval:0.5hour, error as following: "Lost communication with SQL server.ORA-03113:..." "General SQL error. ORA-03114:..." ping database is ok during error; the … |
| | Hello, I am new to Crystal Reports with Oracle. I am trying to create a report ( in Crystal Reports) from an existing Oracle Database. The problem I am having is that I can get the tables but when I do a "browse Data" within the table, there are these … |
| | Hi Alls, I'm really need your's help... I develop console application as a engine to pull data from oracle to SQL...the connection to both database is ok..but when to insert got problem....somebody help me plz.... [CODE] 'Connection To Sql Dim sqlcn As SqlConnection Dim sqldr As SqlDataReader Dim sqlda As … |
| | Can anyone tell me .what will return this subquery.any help would be Greatly appreciated.kindly help me.it will return single row or multiple row if single then how.kindly let me know some idea. [code=oracle] select * from sub where job=(select job from job) [/code] |
| | Hi All, In my python script i use to run some oracle queries for this i require a library to connect to oracle which is [B]cx_Oracle[/B]. When we were using 9i(oracle).. my script was running fine.. and now when we migrated to 10 G its giving problem... Few lines of … |
| | Hi All, I created a table with blob datatype in oracle and store the .doc and pdf file in that column But when i try to access the data from that table i am faceing an error data is corrupted. i am using php 5.2 and adodb driver and oracle … |
| | Respected users, i am working on a small project in VB6 following are some requirements, i am attaching the screen shot also ... 1. it gets the sql files in a list once click it opens in rich text box. 2. when the query is run it should populate the … |
| | Hi all, I have a core java application, I am getting the below exception when ever i run this application. I have a java file named Oracpt.java which takes all variables like username password and url from setttings file which from config file. becoase of this below exception im not … |
| | First of all. Sorry if I don't have a good English... My operating system is Windows XP SP2 I'd created script files below for creating Oracle database manually: dbcamin.bat [code]mkdir C:\oracle\product\10.2.0\admin\dbcamin\adump mkdir C:\oracle\product\10.2.0\admin\dbcamin\bdump mkdir C:\oracle\product\10.2.0\admin\dbcamin\cdump mkdir C:\oracle\product\10.2.0\admin\dbcamin\udump mkdir C:\oracle\product\10.2.0\admin\dbcamin\dpdump mkdir C:\oracle\product\10.2.0\flash_recovery_area\dbcam in mkdir C:\oracle\product\10.2.0\admin\dbcamin\pfile mkdir C:\oracle\product\10.2.0\cfgtoollogs\emca\dbcamin mkdir C:\oracle\product\10.2.0\flash_recovery_area mkdir C:\oracle\product\10.2.0\oradata\dbcamin … |
| | Hi guys Iwant to connect java to oracle ,but Iam not familiarneither jdbc nor in setting classpath however depending on my little information,I used the following code [CODE=java] import java.sql.*; public class OraThin { public static void main(String[] args) throws ClassNotFoundException, SQLException { Class.forName("oracle.jdbc.driver.OracleDriver"); // // or // DriverManager.registerDriver // … |
| | hi I have 3 tables - table1,table2,table3 table1 has 3 columns named col1,col2 and col3 and has 1 dummy record with values 0,1,2 respectively. The other records are my master records col1 col2 col3 0 1 2 A B C AA BB C D E F table 2 has the … |
| | i have a database containing 100 questions . i want to select random 10 from it. how to do that? there is another database containing 100 questions. questions are stored along with an attribute level. there are 10 levels. so there are 10 records whose level value is 1 and … |
| | Am having problem calling a simple stored proc to insert data from a java program. The insert statement works fine when called directly with prepare statement. But when I use call it through a strored proc I get an error. jar file is ojdbc5.jar. - oracle10g. Then i tried another … |
| | Has anybody used this microsoft tool SSMA? I can connect the two databases OK, and can convert tables from ORACLE to SQLSERVER 2005, but the data refuses to go across. Any info will be helpful. Thanks, Jim  |
The End.