[oracle] Forum Topics

Hi, we have pl/sql objects.for some pl/sql objects we found the object names in the scheduler list to run it.But we didn't found the some objects to run the jobs. the scheduler contains Object list. if you select one object and click on submit button then it will show u …

Hi, I have one Oracle standalone procedure.In this am doing truncating the data and loading the new data into the target table. The issue is , I want to know whether the table is callable from other procedure,if it it callable I want to know the Procedure or Packages list. …

I HAVE LOADED ORACLE 8i ON WINDOWS XP. IT HAD LOADED SUCCESSFULLY AND I HAD WORKED ON IT. BUT ON NEXT REBOOT WINDOWS IS NOT ABLE TO START THE SERVICE CALLED OracleServiceORCL. WHEN I TRY TO START IT AGAIN IT ENDS WITH AN [quote] ERROR:- Could not start the OracleServiceORCL …

Greetings, I'm having some trouble creating a trigger that, before I insert something in a table, it resets an existing record field to 0. Example I have in the table a field named "Name" and another named "Active". Each field has a diferent ID The last entry of a "Name" …

hi guys, thanks for viewing my thread. Being in oracle for database administration is something awesome. I would like to know on how a bulk of documents in .txt file could be cluster using oracle 10g. The documents all are report which are contain Speaker Name , Report ID , …

hi there... i need to know the difference between varchar and varchar2 datatype in oracle

I have heard that oracle 11i is an ERP,i want to know that what is an ERP??? Is it a database or something???

:?: how to delete all the tables in the a user at a time?

Hi, Is there anyway to insert/add a new column between two column in a table without deleting any other column???

i want the java methods or the mechanism which will work as that of COMPOSE and DECOMPOSE functions in ORACLE/PLSQL. please help me out. thanks in advance.. COMPOSE-ORACLE [CODE]compose('o' || unistr('\0308') ) [/CODE] would return ö DECOMPOSE-ORACLE [CODE]decompose('é') [/CODE] would return 'e´'

I want to find out days gap between two dates excluding sunday. How can i do this in oracle. Please help me.

hi can any one tell me how to export and import a table in oracle 9i? please be brief.

Hello fellows. I'm creating a new oracle database table. My table name is [B]tblTest[/B]. But it returns an error code ORA-00903: Invalid Table Name. I dont know why this happen. I think the table name is right. But what is the problem actually. [URL="http://img820.imageshack.us/img820/3946/nonametgm.jpg"]http://img820.imageshack.us/img820/3946/nonametgm.jpg[/URL] Thank you.

[CODE]I am making a website in which i have to add video tutorials. I was thinking of making a database in which i could put all my videos and connect it to the webserver. But i dont know the right procedure to do it. Can anyone help me please?[/CODE]

Hi, I am converting one query from SQLServer to oracle i get some error related to Exists clause. what i need to do. Date related change i tried in oracle. all subquery return row and i got error on first line. Thanks in advance [B]This is the SQL Server Code:[/B] …

I would like to know if I drop a constaint on a column whether Oracle will automatically change other constraints that involve that column? The reason I ask is because for two days in a row when I dropped constaints on a column that related constraint had the very same …

hello i m anup i want to know about what are steps to create database in oracle8i which is then used java program.in detail.plz help me

What is a transaction and how transaction is managed in DBMS?

create or replace function vdep (d departments.department_id%type) return boolean is b boolean; e departments.department_id%type; begin select department_id into e from departments where department_id = d; if e = null then b := false; else b := true; end if; return b; end; / set serveroutput on variable b boolean begin …

Please advise me on any good performance monitoring softwares for Oracle Database. Budget is no issue. I want to find and fix performance bottlenecks in Oracle Database (Oracle 9i Rel2), as well as generate graphs on statistics collected over a period of time. At present I am evaluating: 1) Spotlight® …

Hi, I want to take backup of all my tables in my system and i want to use in other system.Tell me how to take back up tables in oracle 9i and how to import or use those backup table in another system???

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 !!!

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 …