2,359 Topics
Hi, I'm having a heck of a time getting this procedure to work. I've simplified the procedure down to basically just opening a cursor and closing it, but I'm still getting an error that the cursor is still open. I can install the procedure, but when I call it I …
got this simple web jsp system which was developed using netbeans IDE when i run this system its run able and successfully open the browser with the home page of the system..acording to the user manual of it says i must install oracle10g as database so how can i get …
hi all, I am very new to rdbms. I am using window7 os. how can i use sql in my system (sql *plus oracle). please help me where i can download this and all the pre-requisites for using it in my laptop. thanks in advance.
hi now a days im doig sql n im using oracle 9i for this. now a days my instructor teaching me about select command but im not able to use it on oracle 9i because i didn't create anything, so please can any body tell me that am i going …
Hi All, Really appreciate your help!!! I am new to java and this is my new project in java. for my application am trying to get DB results by calling a oracle procedure through JDBC.i was able to do that and was getting results back to the DAO class.am setting …
Can anyone provide me with a small code to [B]retrieve[/B] value either from [B]oracle 10G XE[/B] database or [B]MySql[/B] database using Java applets....... I searchd the whole internet but none worked fine for me.. Regardds Niks
Hi! I am new to this site. Can anybody guide me from where should I complete Oracle 10g Database Administration II so I can make a good carrier ? Thanks a lot !!! (In advance)
hey, i want to create trigger on delete operation of table say t1...and i want to delete entries from another table say t2 which are related to removed entry in t1....so i tried to create another trigger on delete operation of t2 to store entries from t2.. here is the …
Hello, i have created two tables account1 and log_table and tried to create trigger as follows:: create or replace trigger acc_history after update of balance ON account1 for each row begin insert into log_table values(:old.c_name,:old.balance,:old.acc_no,:new.balance,timestamp); end; but its giving errors such as:: SQL> show errors; Errors for TRIGGER ACC_HISTORY: LINE/COL …
hi all, I have downloaded sqldeveloper from oracle and installed it. to establish new connection it requires connection name, user name password and xe. where do i find these?( I saw the demo, tried my username and password of oracle, still did not work). kindly help me. thanks for the …
Hi, I m working in window 7 and how can I take backup of database through command prompt. Thanks
How to take oracle db backup by command prompt
What is the difference between oracle 10g and oracle 11g?
Hi All, I need to display my BLOB data directly into the IE Browser without saving a temporary file on the hard Disk. I have successfully implemented the method of retrieving the file from the blob. Please help me out or direct me to good articles on how to acheive …
Hi everyone! I have an installment payment program which have Hijri date (Saudi Arabia) and I already have the code for it's converter inside the forms (using datetimepicker for the Gregorian & maskedtextbox for the Hijri). I'd like to know how can I convert or produce the corresponding equivalent Hijri …
I keep on seeing Oracle as I delve into the world of IT. And apparently, by the looks, they no own Sun MicroSystems - IS that correct/true. So what do they do, there history, everything please. Thankyou very much fro your help.
I have a dropdown list on aspx page that is using a data source select command to pull from a database. The don't any data in the dropdown when I preview the page. I need help on what I am doing wrong. Here is my code for the dropdown list …
Oracle Certified Professional Java Programmer was formerly known as the Sun Certified Java Programmer certification. Does anyone know if the switch to Oracle has changed anything significantly, such as the questions that will be on the test? Or is it the same cert with a new name? The reason I …
hello! am an computer engineering student, & these days engaged in a project, the front end tool is vb.net 2008 & the back end tool is oracle10g... am using windows xp as OS.... the reason i need your help is, am not getting option of connecting oracle10g.. i guess, oracle10g …
Hi, I am working on a report where I need to split the rows and update put it on a different column. For e.g. Policy No DriverName 123 John 123 David 124 Matt 125 Phil 125 Peter I need to split the data as per the policy number and instead …
Greetings, What is the default directory to store oracle script files? (script_file.sql) I want to be able to execute script files without having to specify a path, (i.e., @script_file.sql) as opposed to (/dir1/dir2/dir3/.../script_file.sql).
Greetings to all, I've downloaded and installed: oracle-xe-univ-10.2.0.1-1.0.i386.rpm on Fedora 13 x86_64, using the following process: Step # 1: Install Oracle 10g XE [B]# rpm -ivh oracle-xe-univ-10.2.0.1-1.0.i386.rpm[/B] Step # 2: Configure the database [B]# /etc/init.d/oracle-xe configure[/B] [INDENT]Specify the HTTP port that will be used for Oracle Application Express [8080]: (Enter …
I need a query that will find for example in the given table Distinct Col1, with highest Col3 [CODE]A X 1 A Y 2 A X 3 B Y 2 B Z 4[/CODE] So the result should be: [CODE]A X 3 B Z 4[/CODE]
hi... I am beginner for Oracle. Please anyone can tell me how we can assign primary key in to a particular field???????
Greetings, I have table CUSTOMER: [CODE] mysql> describe CUSTOMER; +---------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+---------+-------+ | CUSTOMER_NUM | char(3) | NO | PRI | NULL | | | CUSTOMER_NAME | char(35) | NO | | NULL | | | STREET | …
Is it possible to get system utilization information in pl/sql? are there any routines to get them?
Hi, I have oracle table for Leave LeaveNo FromDt ToDt 1 01/01/2010 31/03/2010 2 01/02/2010 31/05/2010 3 01/04/2010 30/04/2010 4 25/04/2010 15/05/2010 5 01/05/2010 31/05/2010 I want find out who was leave on 01/04/2010 to 30/04/2010. how to write oracle sql? tks in advance kartheeee
Hi, I have a table, which contains multiple rows for a single set of records. It looks like - pk Value ValueType 1 123 XXXX 1 234 YYYY 1 345 ZZZZ 2 1234 XXXX 2 2341 YYYY 2 2345 ZZZZ The pk + Value + ValueType will be unique. I …
I need a little help with a query . I have attached an example table (roughly) in attached picture. The table has a serial number, a supplier_id and a weight column. We need to retrieve FOR each supplier the row that has maximum weight. There could be duplicate rows if …
I have 3 tables Camp , Register, Receipt Camp Register Receipt camp id Name Category camp name Camp Name Register No camp date Reg No Camp_name and Reg_no are primary key how do i group camp by its name and also display the no of category in that particular camp.
I am trying to execute a script, it gives me the error SP2-0640: not connected I then select to connect, type in my username, password, service, and select SYSDBA as the connect. I then get the error ORA-12505: TNS:listener does not currently know of SID given in connect descriptor. I …
when i am executing cmd commands through java ,even though we are having tns name its throwing the following error [COLOR="Red"]ERROR: ORA-12154: TNS:could not resolve service name Plz help!!!
Hi Frends, I m creating an project. In this project i need to store image in oracle database. I don't know how to store image in Oracle Using VB6 i want to add image by add Dilogbox How can it is possible? Please Send me answare and Coad if needed. …
Hi All, This is Vasu.I am new to this software field.Now I started learning Unix n Oracle. Daily we are doing the following job manually.But I am planning to automate it.So any one please help me to write a script for the following requirement.It's very helpful to learn new things. …
I want to store images in oracle ..without using of Blob. i want using RAW fprmat. how? pls give details...........
hello everyone, in this sem in our coll we have sql in syllabus that's why i decided to learn oracle...... i have oracle 9i as well as oracle 10g express edition. i want to know that which is better among them and have some more features. which one is good …
Hi, I have an sqlce query where I dynamically constructs the string by appending different strings. I have a field where I append a product name and its subname. Say for example main name "Pepsi" and Subname "Large", there are some instance where the Subname is empty and the subname …
Hello friends, I am working on my final yr project using Java Swing. Now for the database part can anybody tell me which I should use among Servlets, Oracle or JSP or anything others. I mean which is currently used in industry at large. Hope to get advice. Regards Supratim
Hi can you pls any one let me know" How to delete duplicate records from a table in oracle 9i
My name is Dany I am an It passionate I like to discover new things,find new solutions for problems like those when you get a virus and you can get ride of it and many other things. I would like to say that daniweb forums helped me a lot in …
i have a Problem to know how much time the server take to execute an SQL command . I user Oracle Db and SQL DB thanx
While compiling ProC application on AIX...getting the following error proc iname=v4_mcdr_6010 ProC/C++: Release 10.2.0.1.0 - Production on Fri Jul 2 11:15:52 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. System default option values taken from: /edw/ora10gclient/10.2.0/client/precomp/admin/pcscfg.cfg Parser error at line 756, column 32, file /usr/include/sys/thread.h: Error at line 756, …
[ATTACH=RIGHT]16891[/ATTACH]After a 2009 to forget, the server business is rebounding well, although some segments are doing better than others. [URL="http://www.idc.com/getdoc.jsp?containerId=prUS22467210"]According to market researcher International Data Corp. (IDC)[/URL], worldwide factory revenue for servers grew 11 percent year-over-year in the second quarter of this year to $10.9 billion and unit sales grew …
Greetings There are many topics on this issue over the internet but None of them addresses this issue properly, so I couldn't find a solution to the problem. I installed: *Oracle Database 10g Express Edition* After the installation was done, I opened SQL Command Line and I used the command …
hi there im new in oracle, i want to edit/update table ( emp ) , how can it done. thnk
Hi all ! I 'll a lucky guy if there 's someone who had experiences in using SQL Developer - connected with Oracle Database ( 10g Express ) ^^ I created a simple TRIGGER to print something out, for example : [CODE] create or replace trigger AUTO_OUT before insert on …
Hi, I have a table which stores 2 values as follow REC_TEST Id_Customer Id_Apply Id_Apply can take 2 values, "YES" or "NO" if he passes the test I've designed or not. I want to know if there is a way to take all "YES" and all "NO" from the same …
How to calculate no of days between two dates? eg: how i can calculate number of days between 1/12/2009 and 10/06/2010.(dd/mm/yyyy)
The End.