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.
