Do not use on any
shared computer
August 30, 2008 04:39am pdt

Over 40 Experts attended the first Annual Core Conference! Take a look at what happened throughout the week...

2008 Core Conference

 

Welcome! If you have any general questions about Experts Exchange, feel free to ask me.

 
Time Tested Oracle Solutions: 1 - 25 of 5796
 
Oracle 8i, HP UX server.  Can someone tell me the difference (if any) between the oracle UNIQUE and DISTINCT keywords?  They seem to work exactly the same.  If I say: SELECT UNIQUE(COLUMN) ...
The question below comes from this site.  It's an accepted answer.  However, this syntax doesn't work for me.  I get an error on the comma (after carts c,) that I'm missing the SET keyword.  1...
1). Im looking at an example here: SELECT P.PublisherCode, P.PublisherName, B.BookCode, B.BookTitle FROM Publisher P LEFT INNER JOIN Book B ON P.PublisherCode = B.PublisherCode how th...
I have two tables ALPHA and BETA. I need to update the BETAID to the ALPHAID. The BETAID is currently set to the ALPHADESC so I am joining on this column. The following update statement wor...
How can I list all tables in a schema?  I would like to build a reporting tool, which I can run and it will list all tables in a schema.  It would have to be done via a query (odbc). In t...
I was to trying to use the solution provided by mszacik for convert long raw into varchar2 data type in oracle 8i. I am using it in Oracle 9i. Mostly it works fine. In some cases I got the er...
I haven't been able to figure this out.... I need a where clause that will  all the records from the previous year and up to todays date.   Since its the first of the year I want all of ...
Guys the following code returns information between dates but I want it to return information between exact dates What I mean is if I have a date range   01/10/05      to     10/10/05   ...
Hi There, simple question i imagine.. i want to drop my table if it exists so that i can rebuild it.. It fails on the drop command, it doesn't like specified where it is..  Can you tweak o...
Hey Guys, I have a sql statement as: Select nextno from numtable for update; NOTE: NOWAIT is not specified. But when I execute this query, I get a ORA-00054 error. So my question i...
What does the OVER PARTITION BY do? I don't understand this SELECT statement and the OVER PARTITION BY. SELECT                               Field1, field2,     100 * field3/         ...
I have a development Oracle 8i database that I'd like to create a new schema in.  I have 40 tables that I'd like to add to it.  I'm using PL/SQL Developer to help me along with any of the DDL ...
Kindly list the differences between 9 i / 10 g / 11 i start from 9i and go till 11 i Any urls are welcomed in this regard
Looking for a code example (pl/sql and SQL query ...) to read, update and insert clob column types (external and internal) with Oracle9i. I've heard it was simplified in Oracle 9i compare to...
Hi, I am just trying to execute stored procedures that are already built, and i get error messages when i try to execute. I have several IN parameters that i assign, but my IN OUT parame...
Q1: first thing i am not sure what is the difference between the "*.sql" file and the "*.dmp" file Q2: Second what is the difference between                                Export Table da...
I want to make sure i created a table in the oracle 8i DB I need the simple command to show me all the tables in the DB. I use the system/manager to create the table and it should be there I...
In the following SQL, I want to order a CLOB field. SELECT * FROM <table name> ORDER BY <a clob field name>; However, directly order by a clob field would not work. I have to convert ...
I'm trying to import a copy (DMP file) of the Millennium schema from the A0218174 into the Oracle database on my Laptop, but I'm confused about how to use the TOUSER parameter.   I'm looking...
I have installed Oracle 8i Database in to a Win2000 Server and installed SQL Navigator 4 to a WinXP Client. When I tried to connect to the database it gave following error (using SQL Navigator...
Hello I am trying to move data between schemas and tablespaces in an oracle 9i database. Say I have a schema 'bob'. bob has a table named 'X'. X lives in the tablespace 'one'. what ...
what is the diff in two? i know that to_char used to change into character format and to_date in numeric format but what is the logic? for eg select to_char(sysdate) from dual sel...
Hi, I need to insert a lot of records using 'Insert into my_table select ...' The question comes here: How to disable indexes before and enable them after data inserting? Are these steps...
How do you run a query to show all table in Oracle?
Hi what is the left function in Oracle?  The left function is something I would ordinarily use in MS SQL.  Thanks.