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 … |
The End.