1,135 Topics
| |
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??????? | |
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 … | |
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 … | |
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 … | |
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 … |
The End.