1,488 Topics
 | |
| | I have a problem whit load of xml file into Oracle using StringBuffer. I get a java.sql.SQLException error “setString can only process strings of less than 32766 characters”. My problem a cure when I try to bind the CLOB with the prepared Statement in the StringBuffer. There are no problem … |
| | 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 , … |
| | |
| | I have heard that oracle 11i is an ERP,i want to know that what is an ERP??? Is it a database or something???  |
| | |
| | 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] |
| | Checking data for login form with oracle xe database  |
| | 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] … |
| | Is there any free migration tool for mySQL to Oracle ?  |
| | 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 !!! |
| | 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.