1,488 Topics
 | |
| | Hi friends, I would like to introduce myself, I am Manim from Singapore. Currently working in Olam International singapore as Oracle DBA. Also interested in web development and seo topics. I have created few websites (SNIP SNIP SNIP ha..ha.. i'm not promoting my sites, just for info.) and learnt something …  |
| | hello world; i want to know how i represent or write "IN" in relational algebra; lets if i have the following query; then how i write in relational algebra select CourseTitle, Amount from DegreeCourse, Fee where DegreeCourse.FeeType = Fee.FeeType and Amount IN ( select MAX(Amount) from Fee );  |
| | Hi I am learning SQL at school. I need to work with Oracle 8.0 or any other version before 9i. I have tried to do it, but just came to know that its antique. Hence I need your help to download it. Kindly give me the link. |
| | For an ER diagram, I have to: 1. Produce a set of relations. Indicate all primary and foreign keys. 2. For each relation give the minimal basis for all FDs on the relation, and state whether the relation is in 3NF or BCNF and why. I am fine with doing … |
| | i need a simple project on dbms ...... with vb as front end ....... no fixed project title ....... if you have any pls mail to me............. my id is [removed]  |
| | 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 … |
| | 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 … |
| | 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 |
| | |
| | |
| | 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. |
| | 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??????? |
| | 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 … |
| | |
| | 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 … |
| |
The End.