2,627 Topics
 | |
| | 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] |
| | Hello, I have one asp.net application at server side, having oracle database, Now my question is what is minimum requirement at the client side i.e, should i install oracle at client side to access database from client side? Thanks |
| | 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 … |
| | Hi everyone... this is my first post... so I would be quite descriptive I am working on a Web App which is a Helpdesk Solution and is based on PHP and interacts with MySQL, MSSQL, Oracle, Postgres SQL... we also support Linux based and Windows based installation... There is quite … |
| | 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? |
| | [B][COLOR="Green"]Hello Guys I have learned c++ and some of java and I wish if anyone can help in starting the database design and how can connect it to a program , I mean by giving me some useful books and programs in which I will program in(MYSQL and ORACLE ) … |
| | 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 … |
| | hie ! i am using vb 6 front end nd oracle 9i bk end ... Prob: can we on execute two diff commands (the data environment one's) on the same data report ,instead of using 2 data reports for the 2 diff commands ????(please help wit this) and one more …  |
| | 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 …  |
| | My name is Janice Madlock and I am new to DaniWeb IT. I have been in IT all of my adult life and I love it. I started out prgramming in FORTRAN on an IBM 360 model 50 and now I am a Solaris Sys Admin on SUN/ORACLE SPARC T2000s … |
| | 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. … |
| | Hiiii Everyone !!!! My name is Vaibhav Grover . I am 21 years old studying Engineering in Delhi, India . My hobbies include Reading , Playing both indoor and outdoor , Listening Music , Going out with Friends and Working out . MY intrests include C,C++,Oracle(mainly dbms) I am CCNA …  |
| | hello everyone , i recently started working as a system analyst (not a programmer because we outsourced that to a third party company ). my Question is , are there any specific video tutorials for people like me ? in other words u can get almost all the video training …  |
| | I have a login page, which directs to Verification.jsp Login.jsp [CODE] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <body> <form action="Verification.jsp" method="POST"> <fieldset> <a rel="nofollow">FreeLancer? Sign up!</a> <br/> <input type="radio" name="r1" value="Admin" checked="checked"/>Admin<br/> <input type="radio" name="r1" value="Editors"/>Editor<br/> <input type="radio" name="r1" value="Staff"/>Journalist<br> <input type="radio" name="r1" value="Staff"/>Reporter<br/> <input type="radio" name="r1" value="Freelancers"/>Freelancer<br/> … |
 | I know many will start with ODBC, but slow down ;) I have searched for ODBC and all I find is UnixODBC. Is this the same as ODBC? Also how stable it is? I will be happy to know some apps/companies behind it! I need support for MySQL, PostGreSQL, DB2, … |
| | I wish to delete all the tables that I have made so far........What should I do ???? Please help !!! |
| | How would I write a code to read in this book.txt [CODE]title*Programming PHP author*Lerdorf, Tatroe and MacIntyre publisher*O'Reilly Media description*3 This book covers the PHP programming language. It assumes the reader has some programming experience. It covers connecting to Oracle and MySQL databases. title*Core PHP Programming author*Atkinson publisher*Pearson Education description*3 … |
| | Hi everyone I am a newbbie to writing on fourms and could use a little advice. I currently have a degree in CIS and Business Adm. but I am having a hard time deciding what kind of job I am qualified for. I have learned to program in COBOL,VB, Dreamweaver,Access, … |
| | I'm trying to print at a resolution other than 72 DPI, I managed this using the PrinterResolution (see the code below) but I am having a problem with the printable area. When I change the resolution to 300 DPI I just print everything smaller (ie the getImageableWidth() etc are still … |
| | 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 … |
 | Hello)) I have a text file with a script that can be used to create an Oracle database, but I want to use this script to create MySQL one) Unfortunately, not all commands are similar. I've already changed the commands for creating tables. And now I can not understand how … |
| | Hi there developers! I'm trying to develop my own online multiplayer game, using the DarkGDK. But I don't want everyone to have access to the media of the game, so I'm working on my own cache archive format. This is how it works: .idx0 = textures .idx1 = sprites .idx2 … |
| | Over the past few days I have been writing a bootloader/kernel in NASM... It loads perfectly fine when I write it to a virtual floppy using PARTCOPY, and then boot to it from Oracle VM VirtualBox. However, when I write it to a physical floppy and try to boot to … |
| | Hi guys, microsoft installed many things on my computer and most of them I don't know what they are. It make me feel so sick. I want to know what are they ( if anyone know ) and are they must be installed. Many thanks. Here is a list of …  |
| | 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 ???? |
| | |
| | [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 … |
| | Most of the posts here are from people with problems, looking for help. I thought I would try to talk a bit about ways to find your way out of "stuck". It's been on my mind lately, since I've been wrestling with Swing and it's been winning. Finally worked out … |
| | 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 … |
| | hello friends, can i change the port of oracle 10.i am using tomcat 6.0 and both are using same port 8080.so how could i use oracle with tomcat in windows 7.Reply plz.  |
| | 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. |
| | hi, my name is saad. i will start working at my graduation project. we should do a windows mobile application. the project is a mobile application interacting with a web-site to help people avoid traffic jam. description:- we should develop a mobile application which will work on (HTC) windows mobile, … |
| | Hey .. Everyone ... I'm now to java .. I'm trying to figure out .. how everything fits together .. well .. i have a project that I'm working on .. .. basically it a type of quiz working on java .. where a user takes a simple MCQ quiz … |
| | Hello Every body! I installed oracle 11g and toad 10.6 & when ever i click on the exe of Toad i get this error "[B]olepro32.dll is not a valid windows image[/B]" i browsed for this error but found no solution. i remember when i installed toad last time with the … |
| | Hello, I am a current Java student and am having a problem when I run my compiled program from an in chapter lab assignment called "Stock Tracker". I receive a message from a dialog box "Cannot locate sun.jdbc.odbc.jbcOdbc Driver. Class not found exception creating database object. Following are a list …  |
| | I am using a FileUpload control to allow the user to import the contents of an Excel spreadsheet into an DataAdapter and then import into an Oracle database table. This works great when I use a local filesystem project. However, when I try to run this on the server, I … |
| | I work for a government department that stores a fair amount of private data in a database.In an attempt to secure database access, we have created a database table that contains all of the database logins and passwords. We have also created a class called "db_connect.php" which contains the login … |
| | 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 … |
The End.