1,488 Topics
 | |
| | Hello. I've got an exaple data base for hr account from Oracle. My goal is to create a view which contains empno,ename and deptno from EMP, but than i can only add rows with condition deptno=20. I've cameup with [CODE] create or replace view d20emp as select empno as num, …  |
 | Hi, I am developing an website in wampserver which was working fine but when I installed Oracle 9i ,Oracle working but wamp server sopped .I edited the httpd.conf as follows : chaged port no "Listen 80" to "#Listen 12.34.56.78:8080 Listen 8080" and restarted wamp server but didn't work then I …  |
| | Good Morning, I need some example with SQL plus code on various SET operation. But the query have to be with SELECT keyword. For example I am giving a code: [CODE]Create table student (s_id number(4), sname varchar2(10),constraint pk_sid primary key (s_id),blood_gp varchar2(4)); create table location(l_id number(4),location varchar2(20),constraint pk_lid primary key(l_id)); …  |
| | Hellow. I have 3 variables 1. string query; 2. public static OracleCommand oracmd; 3. public static OracleDataReader reader; I have used these variables in a function [CODE=C#] . . . public void PreviousValue() { query = " select * from....... "; oracmd = new OracleCommand(); .... .... reader = oracmd.ExecuteReader(); … |
| | How should I use SQL loader to load a .csv file as an Oracle Database ? [CODE] CREATE TABLE products( ProductID INTEGER NOT NULL, ProductName CHAR(30) NOT NULL, SupplierID INTEGER, CategoryID INTEGER, QuantityPerUnit CHAR(30) NOT NULL, UnitPrice INTEGER NOT NULL, UnitsInStock INTEGER NOT NULL, UnitsOnOrder INTEGER NOT NULL, ReorderLevel INTEGER … |
| | hello all My question is, At, the server side i m using 10 G and at the client side i m using 9i when i use export utility then it create the dump file but when i try to import it then my command prompt doesnt show any progress of … |
 | Hello All, I have a sorta unusual problem (not too sure where to post it either), it goes like this: I am currently using MS Visio 2007 to Reverse Engineer some tables in an Oracle database, MS Visio lists the tables using unprintable characters (lots of little squares). Because of … |
| | i want to know tht how to overwrite data(Tables) with existing tables in oracle database. first i imported some tables using .dmp file then some table_names was in tht .dmp file. then again i run tht import command with tht same syntax now tht showing some tables are already exist … |
 | Hi Guys, I have imported a CSV file into the database and i want to write some functions to ensure that when data is loaded in that all spaces are removed from certain columns. For Example: In the Phone No column the numbers can appear as follows 07712345678 077 1234 … |
| | Hi i'm a newbie in pl/sql and i need some help from the experts. I'm a vb programmer. Just want to ask you how do you do this in pl/sql? If I log in on my account my username should appear in a textbox. From this LoginForm I have 2 … |
| | I am having problem in connecting Oracle to Netbeans. I am using Oracle 10g EE 10.2.0.3.0 and NetBeans 6.9. I have attached an image that will explain the problem. Please help! Thanx |
| | [CODE] CREATE TABLE Query3Ans( dname char(20) ); CREATE VIEW deptNonPhDs(dept, numNonPhDs) AS SELECT dcode AS dept, count(*) AS numNonPhDs FROM instructor WHERE idegree != 'PhD' GROUP BY dcode; INSERT INTO Query3Ans( SELECT d.dname FROM deptNonPhDs dp1, department d WHERE dp1.numNonPhDs >= (select max(dp2.numNonPhDs) FROM deptNonPhDs dp2) AND dp1.dept=d.dcode ); select … |
| | i want to knw that how to decrypt stored password in oracle database..  |
| | Hi everyone!!! I wanted to know the incorrect values for oracle data types. like for example, string data type cannot accept ' value. What other values does string data type does not allow.? and what about other data types like number, float. Thanks in advance.. |
| | Hey buddies i want to know tht How can i redirect my sql query result to text file using sql command. |
| | [B]My project is Housing reservation system for University I design the interfaces by VB and connect to my oracle data base account Oracle 11g, VB express edition are used The proble is with the login form [URL="http://im20.gulfup.com/2011-12-23/1324652639153.png"]http://im20.gulfup.com/2011-12-23/1324652639153.png[/URL] when I debug and enter the ID & password for User : according … |
| | I need to know how to calculate in c++,using oracle.In this case i must know how to join table.Can I know how this can be done. Thanks. Anjana89 |
| | Hi, I am using SQL Plus Oracle 10g and sometimes when I ran a query such as: select * from employees; some of the columns were cut-off in the results because the table contains too many columns. So my question is: how can I let all columns be displayed in … |
| | My teacher has assigned us a HW to do and I can not seem to figure out how to group the results the way he wants them. What we have is a database of properties and owners. He wants us to generate a report that contains only the Owner names …  |
| | Unable to load DLL 'OraOps9.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E). Following is my scenario: 1 - Previoulsy I had Oracle 09 in my asp.net 4.0 applicaiton working fine on Windows XP. 2 - I updated the windows to windows 7 and installed Orcale 11g. … |
 | hy.... how to get year now and 10 year before with query result is 2009,2008,2007,2006,...... thanx.. |
| | hi can i reset my password and user name for oracle 10g i lost all users and user default it can not log using system . sys or scott at moment plz how i can rest password i have to do project and i cant acess to sql plus |
| | In going through some homework, I was able to do some of the problems, but not others. For example, one problem was "Produce a list of employee last name, first name, job function, department name and department location. Use appropriate, user friendly column aliases." I finished this with this code: … |
| | 1.Procedure named *ship_order* that will accept an order# parameter. It should verify that the ship date for the order# is null and each book ordered has a sufficient quantity on hand. If every book is available, the quantity on hand for each book should be decremented and the ship date … |
 | Netbeans is a free, open source IDE for developing software in Java. It's been around for almost 15 years, having gotten its start around the time Java began. Version 7.0 is about to be released, and I got my hands on the Beta release of this new version. In the …  |
| | Hi all, I really need help for fixing one of the issue in my project. We have a passenger table which is used for Airlines operation. We need to sort the passengers by their seat numbers. Seat numbers are in format <1/2digits><1Alphabet> eg: 1A, 1B, 1C, 22A, 11B, 24D, 9A, … |
 | I used to write PL/SQL programs in oracle 9i.Since windows 7 doesnt support it, switched to oracle 10g express edition. All my SQL programs are alright. But I cant put mutiple queries on a single run though. Like insert into many rows. But PL SQL programs are going crazy. Too … |
 | Hello all. I have never updated a single column in a specific record. I am using Apache derby embedded database. I have used the update prepared statement to up date a single field with the String value but it updates all the like of every record. How can I update … |
| | This is homework. I have to create two tables with certain constraints. However, I keep getting syntax errors, and I really have no clue exactly how to format it because there are so many different 'templates' out there. Here is what I have so far. [CODE] create table Departments (Department_ID … |
| | I'm having a issue of a variable I'm setting in my PL/SQL Program. I'm subtracting two Number Data types and dividing those by the lower number to get a percent change. Now, for instance, that number is a 2.5. How can I assign that to it's correct value in the … |
The End.