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...
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 ...
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 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...
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...
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...
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 ...
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 what is the left function in Oracle? The left function is something I would ordinarily use in MS SQL. Thanks.
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...
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 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...
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...
in solaris system the the location of tnsnames.ora is searched
First: ".tnsnames.ora" at users's home directory
Second: TNS_ADMIN
third: /var/opt/oracle
Fourth: ORACLE_HOME/network/admin
...
what is the equivalent of getdate() from sql server in oracle\I am tryingto get the current date
Hi all,
I want to know the list of all tables names within Oracle schema. I tried : "select * from tab;" but it returns no row selected, although when I describe a specific table with : desc ...
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...
Hi:
I have the following script (partial) and I want to run this script using nohup directing out put to a file. Please let me know how I can print a comment (Something like "row is updated...
How do you run a query to show all table in Oracle?
Hi all,
Quite a simple on really, just gave it 500 for quick response.
I'm after a Oracle SQL command such as the following:
select *
from table1
where IGNORE CASE (field1 != fiel...
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 Everybody,
I want to know how to split a string in oracle ?
Say a string "Hello World", I want Hello in one variable and world in another.
Please help me out
Thanx
Padmasekhar
is there a function in oracle which serves the same functionality as isnumber() in vb6 i.e to find out whether passed parameter is umber or not
