Hi I have installed oracle 10g express edition and i did not find the option to create schema..is there a option to create schema in oracle 10g express edition or esle i have to install other oracle 10g..To create schema which oracle 10g i have to install... Thanks in advance ...
Here's what I want to achieve: I have a number of categories, each one with products in it. I want to produce a report that shows various information about those products for each category. So I have a query that looks something like: select category, count(products), sum(product_price), from product group by category So far so goo...
I have installed jdk1.6.0_21 and sqldeveloper(using alien) on debian(lenny). Now when I run sqldeveloper it asks for J2SE installation path, after I type the jdk path it exits with the below error message. Oracle SQL Developer Copyright (c) 2008, Oracle. All rights reserved. Type the full pathname of a J2SE installation (or Ctrl-C t...
Coming from SQL Server, I am learning some Oracle syntax. This is my table DDL CREATE TABLE "CDR"."EXTDL_REPORTSETS" ( "ID" NUMBER(38,0) NOT NULL ENABLE, "SHORTNAME" NUMBER(38,0) NOT NULL ENABLE, "DESCRIPTION" NUMBER(38,0) NOT NULL ENABLE, "ASOFSTARTDATETIME" NUMBER(38,0) NOT NULL ENABLE, ...
Hi guys In a Proxy Service If for example the input is: [Employee] [Name]Test[/Name] [ID]ID[/ID] [Address]test add[/Address] [Email]test@test[/Email] [Department]Testh[/Department] [Department]Test 2[/Department] [Department]Test 3[/Department] [Department]Test 4[/Department] [/Employee] If there's mu...
I am trying to create empty tables on Oracle as a part of initial setup for one of the internal tools. Before, I had a SQL script that had the create statements separated using semi-colon and was executing them without checking for existence as follows: Setup.sql: CREATE TABLE ex.employees ( empID NUMBER, firstName VARCHAR(255)...
Using PHP, I'm trying to download a blob file that has already been uploaded to an Oracle 10g database. I've seen and imitated numerous examples I've found. When I access the page a File Download dialog appears allowing me to Open or Save. If I click Open, media player comes up as it should but never retrieves the file. If I choose Save,...
i have a table "DEPT" , let me know how to increase the size of a table. ...
I have a table in an Oracle database that contains actions performed by users in one of our systems. It's used for statistical analysis and I need to display the number of actions performed for a given date, grouped by hour of the day. I have a query that does that fine, however, it does not display the hours of the day that contain no ...
How to retrieve third row from any table using "rownum" key word ( i am using oracle-10g) ...
I'm working with an Oracle 10g database, and I want to extract a group of records from one table, and then use that for pulling records out of a bunch of related tables. If this were T-SQL, I'd do it something like this: CREATE TABLE #PatientIDs ( pId int ) INSERT INTO #PatientIDs select distinct pId from appointments SELECT * fr...
hi all, I'm trying to schedule a job in oracle 10g but it says: ORA-01846: not a valid day of the week. Heres my code: declare v_job_id1 number(19,0); v_job_id2 number(19,0); begin dbms_job.submit(v_job_id1, 'CTX_DDL.OPTIMIZE_INDEX(''PSO_KEYWORD_SEARCH_IDX'', ''FULL'', 45);', NEXT_DAY(TRUNC(SYSDATE), 4) + 13/24, NEXT_DAY...
I am trying to import into oracle using imp command and the output of the command is as below. invincible:/home/invincible# imp Import: Release 10.2.0.1.0 - Production on Thu Aug 12 22:19:00 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Username: n_data Password: IMP-00058: ORACLE error 1034 encountered ORA-01034: OR...
table 1 --- id , name table2 --- id , activity, datefield table1 'right join' table2 will return more than 1 results from right table (table2) . how to make it return only "1" result from table2 with the highest date ...
I have a database on Oracle 9i. Now I want to work on SQL Server 2008. I want to migrate the Oracle database to SQL Server, but how do I do that? Give me some syntax? Thanks for the help. ...
My system write some data to a SQL Server DB (2008), extracts it later and processes it some more, before writing it to an Oracle (10g) DB. I've wrapped my SQL Server interactions in a TransactionScope but when I try the same think with my Oracle interactions I get a `TranactionAbortedException - "The transaction has aborted". Remove ...
I am new at working with oracle, my only experience is in sql server. In SQL server you can right click a table and say export create script. I need that for Oracle, specifically 10g. Is there a way via GUI or sql command that can accomplish this? ...
Inventory Application built in four-layered model consisting of: applet-based graphical user interface; proprietary middle layer (Tomcat web application); Business logic in Oracle 10g stored procedures.; Data stored in Oracle 10g. The Problem: The middle layer is designed for transactional communication, and not for moving large data s...
I just observed a strange behaviour (of course Oracle is probably supposed to behave this way, but it didn't fit in my world view yet): I try to insert two rows into a parent and a child table, both within the same transaction: INSERT INTO V_Parent (ID, Name) VALUES (777, 'Hello World'); INSERT INTO T_Child (ParentID, Name) VALUES (777...
I'm trying to do something which should be fairly simple, but in my experience with Oracle, nothing ever is...! I'm trying to call an oracle procedure in C# using MS provider for Oracle. As far as I can tell, there are the correct number of parameters, and the type of each parameter is correct. More importantly, if I run the procedure ...