1,488 Topics
 | |
| | hi anyone please tell me that how do i connect to oracle database using vb.net through the application config and how to retrieve the data from the oracle database? what is the procedure that i need to do to enable connection to oracle database? currently the server is not on … |
| | Author Table INSERT INTO Author VALUES (12,'James Smith' ); Using join conditions Find memebers (by name) who have ever borrowed a book written by certain authour (JAMES SMITH) |
| | hi, I need to know how to get only the upper case currency from a table using oracle. e.g:- data for currency will be as follows USD AUD EUR SGD AUd uSD EuR I need to get only the upper case currency among all the other currency such as USD …  |
| | In a table containing records of all customer with there orders and status of deliveries. Now I wish to find only last the entry of each customer available this table, it can be their last order or delivery status. What would be the ideal query for this? Please help me. |
| | hi every one how to update one column using join condition,for example i am having two table, first table one column is to update the second table using join, please give me idea thanks |
| | I currently have a table in oracle which I have created, but need to take a text file (which I have used a fileChooser for) and then use this file to update the records in the oracle database. How would I go about this? Thanks.  |
| | Hi there! Ive been working on my relational schema for a while now and just recently managed to implement it. I wanted experiment a little with it so ive decided to produce a report displaying relevant information. At the moment my schema only consists of 3 tables : a 'student' … |
| | Hello, I am trying to nest some CASE statements into INNER JOINs (one CASE per INNER JOIN). The current code is: [code=sql] SELECT a.zone, a.ifield, a.iwhse, a.idesc, a.iposition FROM schema.itable a [/code]<---This is where I would like to place the INNER JOIN w/ CASE [code=sql]LEFT OUTER JOIN ( SELECT x.icode, … |
| | Hi Everyone, I need some suggestions from you guys. I am totally unaware of JSP or java and trying to learn a bit , as i need to develop a sample application using web services.I am in need of some help from you guys. If there are some errors in …  |
| | i am bscit student and i am doing one project. so i want to urjently know how to connect vb6.0 to oracle 9i |
| | Hi ,I am Sravani. I saw a query in this site that VB6 can be linked with oracle 9i. I am using oracle 10g in my office.what i want t oknow is cant we use oracle 10g to connect to VB6? Pleasse try t oanswer to my query. Its urgent. … |
| | Hi Guys I need a hand from a kind SQL*Plus guru to create Oracle abstract data types and collections using SQL*Plus I. Using Oracle’s SQLPlus create Abstract Data Type definitions for the Client and Child member entities called Client_Type and Child_Type respectively. Attributes for Client_Type include client number, name, address, … |
| | I have created my tables in a database using a .bat file but when I try to insert data/values into it using toad there is prompt occurring that says that table i just created does not exist but when you look at the schema browser tab the table is there.. … |
| | how are you every one?? I am student and i just started to study SQL,and now i will start studyabout Oracal . so i want ur advice to be a good student.  |
| | First off, I'm not really a DBA... I'm learning as I go. The office I work in has a lot of problems when it comes to the integrity and reliability of data stored in our Oracle database. One of the little things I'm wanting to resolve is the duplication of … |
| | Hi, My project requires, auto suggest textbox in jsp where we retreve data from database(oracle) |
| | Hello all, I work for a S/w MNC as an system eng support but I wanted to move into database. I am new to databse. can anyone suggest me how to start with this. It's a new field for me but I want to make my career in this. Do … |
| | what is the Major difference between Oracle,Sql Server,Mysql?WHat can do in ORACLE,SQl SERVER,MY SQL?what can't do in ORACLE,SQl SERVER,MY SQL? it is my big Doubt in DB. |
 | Hi All, I am having problems trying to write unicode characters to a version 10 Oracle database, using C++ and OLE DB (the same code works with MS SQL). If I insert a unicode string directly from PL SQL it works, otherwise I get nonsense when trying from my code. … |
| | what is the maximum limit for int in data type.suppose in our table im specifying ID as int type and assigning it as auto increment.After the int limit what will happen?what we will be auto increment? |
| | hi what is difference between NOT EXISTS and NOT IN and also EXISTS and IN at subquery thanks |
| | Hi Friends, I'm new to daniweb as well as to the world of programming. I'm creating one project using visual basic 2008 and oracle 10g. Now I want to create some reports using crystal report. But when I run the report. No data comes up. Only the heading. Can any … |
 | Ok, so I'm learning about procedures and functions in Oracle and I'm stuck here with my procedure. I have the function part down pretty good, but the whole returning variables with procedures through OUT mode is confusing me. My task is this: "Write a procedure that accepts a zipcode & … |
| | |
| | hi i am creating stored procedure using cursors, i am using two cursors in my procedure, i takes the two fields in one table that fields are stored first cursor, and second table fields are stored in second cursor, and i check the condition for first table one field is … |
| | Hi friends, Please send me the process of connecting and accessing database to Ms Access/Oracel . Pardeep |
| | hi please give me idea for how to avoid duplicate key in a table thanks |
| | Hi friends, I m creating a software with backend of ORACLE 9i. I need to Generate backup ORACLE "ADDFILDP" table to ACCESS "ADDFILDP" table(Simply Copy the data to one table to another[ORACLE to ACCESS Table]):$ An access File is already Created. I was code for it as Follows [ICODE] Private … |
| | Currently I am working on one form development using Java. In JSP page I retrieved the data from table using F9 keys i.e for any input field variable available in JSP page, once I pressed the F9 key, all the related data is displayed in the popup window. Once I … |
| | HI , I want to develop a new site whcih should store videos, images and docs.. What is the best method ? store this in database or as external file in disc ? Could you please point out pros and cons of both As performance is my main concern for … |
The End.