1,488 Topics
 | |
| | Dear friends, I'm doing a PROJECT work in ATTENDENCE... i need to check, HOW MANY DAYS employee IS ABSENT... I need a PL/SQL PROCEDURE to ACCEPT 4 DATES: DATE 1: When he gave the LETTER for LEAVE DATE 2: When he was GRANTED leave DATE 3: FROM - DATE. which …  |
| | I was wondering if anyone could help me where to start on this? Consider the following schema containing data for a particular air base: Pilots {PID, Name, HomeTown, HomeState, Rank} AirCraftTypes {Model, Aname, MachSpeed} Aircraft {AID, Model, DateInService, HID} FlightSkills {PID, Model, HoursLogged} Data for this schema can be found … |
| | 1.Create a table with the following details Table Name - dictionaries_<XXXXX> dictionary_id NUMBER NOT NULL, -- Primary Key dictionary_name CHAR(50) NULL, dictionary_owner CHAR(50) NULL, dictionary_owner_id CHAR(50) NULL, src_intfc_inst NUMBER NULL, dictionary_type CHAR(2) NULL, update_date DATE NULL 2. Write a function that returns the number of different dictionary types used by …  |
| | Create the table with the following details: Table name--- Employee_XXXX EMPID NUMBER(3), ENAME VARCHAR2(15 BYTE), HIREDATE DATE NOT NULL, ORIG_SALARY NUMBER(6), CURR_SALARY NUMBER(6), JOBTITLE VARCHAR Department Project_name Char(4), EMPID NUMBER(3), REGION VARCHAR2(1 BYTE) As the company is expanding people working under a given project are shifted from Chennai to Coimbatore. … |
| | I wish to delete all the tables that I have made so far........What should I do ???? Please help !!! |
| | Hi I want to make my career in Oracle and there are different streams in Oracle like : FUNCTIONAL , TECHNICAL AND DEVELOPMENT. I am quite confused choosing a stream,which will help me in getting my dream job and will offer me good growth in an Organization, so that i …  |
| | I made 10 tables for a project. But the first 9 tables along with the values that I entered, are saved in the database. But the last table is not able to save it's values. I have to enter the values every time I run SQL. It always shows "No … |
| | I have made 8 tables, that are connected with primary keys among each other......What command should I use, to delete all tables at once ???? |
| | Hi, How audio and video files are stored in database in Oracle? Can anyone please explain in details with more real time example and SQL statements. |
| | [CODE]create table items_avail ( pro_id varchar2(10) primary key, mod_id varchar2(5), comp_name varchar2(25) ); [/CODE] I wish to remove the primary key constraint......and add make the prod_id and mod_id as primary keys together. i.e. primary key(prod_id, mod_id) But he thing is this table is already connected to three more tables by … |
| | 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 am in the process of designing a Database structure for a project. And i am stuck at a particular design decision. Ive searched quite a lot on google but not able to find a satisfactory answer. I am looking out for something like “TableSpaces” (like in Oracle) to use … |
| | 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 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 … |
| | Well i can see lot of career related questions are posted here So i thought i could contribute something for youth. with more than 5 years of Experience in above subjects I have decided to take classes. Location : Mumbai . Subjects: C Java: Java Basic. Advance Java. C#. VB … |
| | 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 … |
| | dear sir madam i give oracle permission to folder this way [root@srvr1 ~]# chown -R oracleinstall /oracle/* [root@srvr1 ~]# chmod -R 775 /oracle/* so what it did each every file, it attached filename* (asteric * in last) now each file shown under /oracle directory looks with * can someone give … |
| | According to Codd's Tweleve rules which are considered as a basics of the relational database system, which one of the following three systems: Oracle, DB2 and SQL server is most applied and relational than the others? Please give me your opinion and why.  |
| | 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 |
| | I have made a project in vb with oracle 9i at back end....its almost complete... however i can't code the previous button on d form... i used rs.moveprevious property but it generates an error... help!!! |
| | 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 … |
| |
The End.