[oracle] Forum Topics

Can anyone please help me with installation of oracle 11g on windows 7 home basic 64 bit? On prerequisite check its giving an error that "this version is supported by os version up to 6.0 only and not by this version 6.1"

[CODE] create table item_avail ( pro_id int primary key, mod_id int, color varchar(10) ); create table Laptop ( pro_id int primary key, mod_id varchar(5) not null check (mod_id like "L%"), color varchar2(10), comp_name varchar2(20), RAM number(5), spaceHD number(4), foreign key (pro_id, mod_id, color) references item_avail (pro_id, mod_id, color) ); create …

hi all i was wonder if its possible to join 3 tables, so i could see the result from the 3 tables. for example lets say that i have INVOICE(invoice_id, client_id,item_id) CLIENTS(id, client_name) ITEM(item_id, item_name) i want 1 table that shows: invoice_id, client_name,item_name is this possible? 10x!

Is it possible to store images in oracle db, if yes then what will be the data type of the field.? Please illustrate with example....thanx a lot.

I had a small issue. Can you pls check this... I have two tables TABLEA,TABLEB. TABLEA -------------- col1 col2 col3 TABLEB -------------- cl1 cl2 cl3 If col2 in TABLEA = cl2 in TABLEB, then i need to update cl3 in TABLE B with col3 in TABLE A. I tried running …

hello i am using oracle 9i enterprise edition i want to open isql plus in my browser please tell me how to do it. i am very beginner to oracle. please help me.

hi.. What are the significance and constraints of a primary key? Thnxx

hi guys... i use windows7 32 bit edition on my notebook recently i installed oracle 8 on this... the installation completed successfully but when i try to start database... i get the message that the database could not be started -> i tried starting in services.msc but failed -> when …

Hello everybody!!! I just want to ask some internet sites where I can download Oracle server like mysql and sql server because I want to learn about how to use it. I have already knowledge about sql and mysql and how to access them using vb.net, and for more improvement …

Hello Everybody I am doing oracle 10g d2k it means the front end is forms so can anybody suggest me a good topic for project development and what are the thing that are need to be included or taken care of when developing the project Thanks & Regards

hai its mahadevan,please reply how to connect oracle with vb.

Hi Friends I have a challenging task in SQL (Oracle). Let me know if you have any answer. I have 2 tables. 1. Dept 2. Employee Dept [B]Dept_No Dept_Name[/B] 10 Admin 20 Data Warehousing 30 HR Employee [B]Employee_No Employee_Name [/B]Dept_No[/B] E01 Sangeetha 10 E02 Michael 10 E07 Immanuel 20 E11 …

Hi i want my formatted output should be in a straight line : 1 2 3 4 5 6. Is this possible in PL/SQL ? declare n number:=0; begin loop n:=n+1; dbms_output.put_line( n ); exit when n>=6; end loop; end; / Output : 1 2 3 4 5 6 PL/SQL …

hi i am using oracle 9i and now a days i am learning sql. due to some problems i have to change my system and i will install oracle 9i in my new system, but problem is that after installing i need all that old tables that i have created …

hai i'm not understand trigger.anyone can explain this?

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 );

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

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?

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.