1,488 Topics
| |
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. … | |
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 can you pls any one let me know" How to delete duplicate records from a table in oracle 9i | |
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 | |
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) | |
hello every one I am a student of CS and in this semester i have a subject DBMS, i haven't do any programming with sql till now, i am completely new to it, here i want to know that about different DBMS software. in our coll we have oracle 8i, … | |
How to create database in oracle. Is the tablespace and database same? Do we need to install client from oracle 9i? I have the code as follows Create Tablespace SCT_DATA Datafile 'sct_data.dat' size 10M online; and i come across the error as follows Create Tablespace SCT_DATA * ERROR at line … | |
Hi i am new in oracle. i am having a problem. i need to collect datewise max time and min time from my table "dailyAtt" here is the data formate in my table.. ID Code Ptime 1 2570 14/10/2010 1:00 Pm 2 2570 14/10/2010 2:00 Pm 3 2570 15/10/2010 7:00 … | |
Hi everyone, I will be really thankful if someone could help me out. I am developing a gui application ( based on java jdbc and oracle10g), where a user can enter queries retrieve data from that can perform selection projection join union. Till now I could perform only selection queries … | |
Hi everyone, I will be really thankful if someone could help me out. I am developing a gui application ( based on java jdbc and oracle10g), where a user can enter queries retrieve data from that can perform selection projection join union. Till now I could perform only selection queries … | |
Hi guys, can anybody tell me where can i download oracle 9i, please send me some links, Thanks in advance. | |
I'm going into my last year of a computer science degree, and after looking around at job postings for software developers I've noticed that *many* of them require knowledge of Oracle - something that I haven't yet learned very much about. So I was wondering if anyone could point me … | |
Hi I am new to the database concept and I have to make a college project such as hospital management, Transport management system etc. in DBMS. Our college is teaching us MYSQL. Please can anyone advice me as what to use in making these projects. What database type to use … | |
the totally mess is going out here.............nobody is giving a perfect suugestion to anybody...........i have log in here to get som project ideas but.... i don't need the code i just need good idea n help in our problems of project i wanna to create dbms project in oracle 9i … | |
I am rewriting in Visual Studio 2008 c++ an application written in VB.NET that successfully connects to an oracle 10g database using OracleDataAccessClient.dll. I am trying to utilize the same dll in the c++ app though very unsuccessfully. In the project's Property Pages, I have successfully referenced the dll. In … | |
i want to connect plsql server with asp.net using C# and want to show data of server in grid view. using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.OracleClient; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object … | |
Please how can I write a query to display only the top three earners in a table in desc order e.g Emp Sal John 100 Jam 120 Abi 90 Jo 170 the query should display Emp Sal John 200 Jam 170 thanks | |
I am not a developer, but I am trying to learn SQL to write reports for auditing our data. I want to extract empoloyee contact information, because I feel we are missing some CREATE_MIRROR_FLAG. I found the contact information on the per_contact_relationships table, but now I need to find the … | |
Hello all I am new to the community and have been stumbing across a problem with my code. I have a program that is connecting to an oracle database. I am using the table adapter to fill a combobox to select a model. Then I am connecting to the database … | |
Hi, I have Oracle 10g installed in my laptop. I have currently inserted a Gridview and in this Gridview when i choose "Oracle Database" as my Data Source, I come across a form where I have to fill out the server name, username, and password. I do not know what … | |
Hi All, I am planning to write OCA 10 G this september. I am referring book PL/SQL programming by SCOTT URMAN. Other than this I want study material/dumps. If some one has please help me out with the same. Thanks in advance. | |
how to get server's ip address in store procedure in oracle | |
Hello mods!!This problem is really frustrating me now!! i already know about ur tutorial on MVC Connection but i do not want to follow it since it is very complicated for me to understand and implement. So i have written a code (Ora.jsp) to connect to Oracle XE on my … | |
i want to display 0.00 in field where the field is empty... Empty because there is no data in the table/records for particular input. and the report is display based on joins.. so please help me... |
The End.