2,627 Topics
 | |
| | [COLOR="Green"]hi friends myself Nikhil....... M in final year BCA m interested in doing a project work based on web........... so can anyone help me to get through this project work smoothly....... i need good project....[/COLOR]....the project should b based on asp.net or vb.net and oracle.........it should b interesting n new … |
| | Hello all! I need that awesome knowledge I know you have!! In your opinion, how would you create the following? Here are the specs. Database driven website Multiple users <200 from all over U.S. Intranet based < 700 different fields Server side will be mssql (IT requirement). Same record edit …  |
| | i want to get the [COLOR="Red"]ROLE [/COLOR]of an user by entering the username and password in login form.... for example:: username password role ramesh xxxxxxx manager loginform:: enter username: enter password: [U]plllllzzzzz any one post the required query of the above problem[/U]  |
| | Hi folks, I'm Derek in the UK and I stumbled on this site via the angel of mercy that is Google whilst trying to fend off some malware. Seems like a good place to be so here I am! I'm older than I care to admit and spent most of … |
| | I need to automatically and dynamically generate an organization tree. The Data comes from an Oracle Database, where the hierarchy is well defined. But I can't seem to find any good way of generating the Tree Structure. Using a tree-view won't work as there are some designations having 2 or … |
| | My browser keeps opening by itself every few minutes. Also have a spyware Guard 2008 program which keeps opening up. I saw a similar posting from before - I followed the instructions there - downloaded HijackThis, clicked on "Do a system scan and save a log file" button. Below is … |
| | Hi, just a quick question from a newbie! I have recently inherited an asp.net website from an ex-colleague and I have a question regarding db connections. I am using vb.net for code behind with an oracle 9 database. The site at the moment, sets up a database connection GDBConn in …  |
| | I'm on a Solaris Sun 10 box and I'm trying to install syslog-ng-2.0.9 and I keep getting this error whenever I run ./configure: configure: error: Glib headers inconsistent with current compiler setting. You might be using 32 bit Glib with a 64 bit compiler, check PKG_CONFIG_PATH I just installed Glib-2.18.0 … |
| | hi all, can some one help me how to display the fields which enter in current week,current month like that  |
| | Hello guys, Just need to know - wats making oracle to stuck when i run this simple pl-sql module declare counter number; begin <<outer>> for counter in 1..10 loop <<inner>> loop insert into lines values(counter); exit when counter=6 or counter=8; end loop inner; end loop outer; end; / |
 | [B]Can someone let me know how the date syntax work. example working with "greatest" 01-oct-02 and 20-may-2003, it accept 20-may-2003 to be the greatest instead of 01-oct-02 which the oldest (greatest) can someone explain this to me. please let me know the logic behind. I have alot of problems with … |
| | status teacher build exam (question and answer) and student take the exam form build_pre_exam add data into pre_exam table when form run , user(teacher ) have to insert question and four cooses then choose from list item which one i correct answer (to enable to check exam for student) ,after … |
| | Hi, Can anyone help me how to retrieve data from table in the following manner. In my application I have five button namely First,last,next,previous,and Query. When I will press the query button, it should show me last data that I had feed to the table. When I press first button … |
| | I am doing a project using oracle10g XE and JSP. Here i am using a table where data type of a field is autonumber. It is working fine when i insert or update record. but it does not continue its sequence when i delete a record. For example i have … |
 | Does anyone know how Oracle's PL/SQL handles subtraction with a negative number? Really what I need to know is, given the following: (NOTE: this is NOT the code I'm working with. It's just an example to give and idea of what I'm trying to do.) [CODE] DECLARE number1 NUMBER; number2 … |
| | 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 … |
| | Hi guys, i've a problem when running java application connected with sqlite database the connection is done with netbeans IDE, but when i trying to run the application i get the following error [COLOR="Red"]init: deps-jar: compile: run: 06/12/2008 04:42:49 ص org.jdesktop.application.Application$1 run [COLOR="Green"]SEVERE: Application class desktopapplication3.DesktopApplication3 failed to launch javax.persistence.PersistenceException: …  |
| | Thank God i found this site. my first day in VB and i was given an assignment to simulate how a lift runs in VB with 4 floors. pls can any one help me so fa i have been able to design the interface. please i need help in writing … |
| | G'Day all, I've got a plugin for an application. When it's installed it runs the following:[CODE]Alter table DocketItem ADD Optimised BIT DEFAULT 0 NOT NULL[/CODE] However, when the plugin is uninstalled it tries to run the following: [CODE]Alter table DocketItem DROP COLUMN Optimised[/CODE] When the plugin is uninstalled, I get … |
| | 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. |
| | I currently have an Oracle database, a Java Program, and a text file. Text files are being read by the system, which automatically updates the database. How would I make a JTable to make the database be displayed nicely in a JFrame?  |
| | 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' … |
| | Hi everyone, greetings My name is Peter Fofuh from cameroon central african region. I am new to the programming world and just happen to stumble on this site while browsing. It's a great site and my encouragements to the whole forum. Well I'am one who likes challenges and i am … |
| | 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, … |
| | Working with multiple database I was always wondering if there's a way to simply transfer tables structures and data from one database to another. Looking over the internet I found that using a database migration SQL script is often the best way to migrate a database. Then I found SQL … |
| | My name is Neil and I'm about to start a Java programming module on-line with the University of Liverpool for an MSc in IT. I've worked in IT for 16 -odd years now as an Oracle DBA and Server Admin type. and am taking the degree because it;s proving almost … |
| | Hi Experts, i have this code -- [CODE] <%-- Document : index Created on : Nov 10, 2008, 3:25:29 PM Author : namish --%> <%@page import="java.sql.*"%> <html> <head> <title>Obtaining a Connection</title> </head> <body> <h1>This Page Obtains a Connection to a Database and executes a query</h1> <% Connection conn = null; … |
 | Hello guys I was just wondering what Oracle is : is it a database or a language.  |
| | 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.  |
| | hey buddies i am arun and studing in school in 12 th standard but i am the best in vb as well as oracle programming in my school but i want to learn some hacking and experimental languages like python etc. |
| | 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 … |
| | Hello to all at daniweb.com. I'm really hoping someone here can help me out. I need to complete a final year project at uni to graduate, i have taken database design and administration last year as a module which covers microsoft enteprise manager, creating tables, relationships, stored prcedures and triggers … |
| | Hi guys, i have a ksh script that gets some info on processes and puts it into a temp file: [code] /usr/ucb/ps -auxxx|awk '{print $3," "$4," "$2," "$1," "$11}'|grep -v 0.0|sed 1d > $TMP [/code] It gets the following data [code] 0.8 6.2158230724046144 9918 oracle 0.3 6.2158200964043168 15298 oracle 0.2 …  |
| | Hi. I am building an intranet directory to list all the websites in our organization. We have built the directory in JSP working with Oracle. Idea is to have by default the directory ordered alphabetically and grouped by the first letter of the site name, as an example: A Asia … |
| | 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 … |
| | I'm hoping somebody has some sage wisdom to offer me regarding these two questions. First.. I've been working as desktop support for 6-8 years now, some of that time can be explained in either a "Systems administrator" or "Network engineer/administrator" light as well. I'm looking to break away from the … |
| | |
 | 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 |
The End.