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...
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...
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...
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...
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 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 ...
What does the OVER PARTITION BY do? I don't understand this SELECT statement and the OVER PARTITION BY.
SELECT
Field1, field2,
100 * field3/
...
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 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...
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 ...
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...
How do you run a query to show all table in Oracle?
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...
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...
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
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...
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 ...
Hi what is the left function in Oracle? The left function is something I would ordinarily use in MS SQL. Thanks.
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...
what is the equivalent of getdate() from sql server in oracle\I am tryingto get the current date
I am attempting to load a tab-delimited file into Oracle (9i) using SQL Loader. I am using the following control file script (which works flawlessly on the same data if it is comma-delimited)...
How do I convert a field of LONG datatype to one of a VARCHAR2 datatype?
I have a table in an oracle database that tracks table constraints in an application that I have written. I wish to...
