06-10-2011
Hi, thanks for reply.
Was a standard syntax error in the end.
Can post new code if anyone is interested.
7 More Discussions You Might Find Interesting
1. Programming
I have a stored procedure that is failing. The current query behind it is:
SELECT DISTINCT
<many, many values>
FROM
table1
LEFT OUTER JOIN table2 ON
(table2.key =
(select max (table2.key) from table2
where table2.key = table1.key) or
... (0 Replies)
Discussion started by: Elric of Grans
0 Replies
2. Programming
example sql:
select a.a1,b.b1,c.c1,d.d1,e.e1
from a
left outer join b on a.x=b.x
left outer join c on b.y=c.y
left outer join d on d.z=a.z
inner join a.t=e.t
I know how single outer or inner join works in sql.
But I don't really understand when there are multiple of them.
can... (0 Replies)
Discussion started by: robbiezr
0 Replies
3. Shell Programming and Scripting
Hi I'm looking to query a table on a database and then iterate over the results in a loop. I believe this is the last part of my script that I need (after finding out threads for passing variables to other scripts and calling functions in other scripts). I've searched the forums but the best... (8 Replies)
Discussion started by: Dird
8 Replies
4. UNIX and Linux Applications
Hi -- I have the following SQL query in my UNIX shell script -- but the subquery in the second section is very slow. I know there must be a way to do this with a union or something which would be better. Can anyone offer an alternative to this query? Thanks.
select
count(*)
from
... (2 Replies)
Discussion started by: whoknows
2 Replies
5. Programming
Am having a nightmare with a certain piece of code.. have tried almost everything and just cannot see what the issue is..
CREATE OR REPLACE VIEW TOP_EARNER_PER_LOCATION
AS
SELECT E.FIRST_NAME || ' ' || E.LAST_NAME AS EMPLOYEE_NAME,
L.REGIONAL_GROUP AS REGIONAL_GROUP,
... (1 Reply)
Discussion started by: U_C_Dispatj
1 Replies
6. Programming
I have some records to be updated in oracle table. I am using sql developer tool. could any one tell me how to update those records in oracle table. I am having excel sheet with those records. (4 Replies)
Discussion started by: ramkumar15
4 Replies
7. Shell Programming and Scripting
Hello,
This post is already here but want to do this with another way
Merge multiples files with multiples duplicates keys by filling "NULL" the void columns for anothers joinning files
file1.csv:
1|abc
1|def
2|ghi
2|jkl
3|mno
3|pqr
file2.csv:
1|123|jojo
1|NULL|bibi... (2 Replies)
Discussion started by: yjacknewton
2 Replies
LEARN ABOUT DEBIAN
make-sqldeveloper-package
MAKE-SQLDEVELOPER-PACKAGE(1) Oracle SQL Developer Debian package builder MAKE-SQLDEVELOPER-PACKAGE(1)
NAME
make-sqldeveloper-package - Oracle SQL Developer Debian package builder
SYNOPSIS
make-sqldeveloper-package [options] <file>
DESCRIPTION
make-sqldeveloper-package is a utility that builds a Debian package for Oracle SQL Developer.
The Oracle SQL Developer program is governed by the copyright holder (Oracle USA, Inc.), so you may be limited as to what you can do with
the resulting package (i.e. no redistribution, etc). This utility will simply help you create the Debian package, it is your responsibility
to use the resulting package acordingly with the OTN license, a copy of which is included in the created package, that you must agree on
when downloading the source.
This utility will require you to download the "Oracle SQL Developer for other platforms" archive from <http://www.oracle.com/technet-
work/developer-tools/sql-developer/> to create the Debian package from.
OPTIONS
-b|--build-dir <dir>
base directory to build package (autogenerated)
-e|--email <email>
local maintainer email (use DEBEMAIL or auto-generate)
-i|--install
install the generated package - needs root privilege (no)
-k|--keep-dir
keep the build directory (no)
-l|--revision <number>
local revision to append to package version (1)
-m|--maintainer <name>
local maintainer name (use DEBFULLNAME or leave empty)
-r|--root-command <command>
command to gain root privilege for package build (fakeroot)
-u|--upstream-version <version>
force the upstream version (autodetected)
-h|--help
display the help screen
-v|--version
show the program version
<file> the "Oracle SQL Developer for other platforms" archive from <http://www.oracle.com/technetwork/developer-tools/sql-developer/>
AUTHOR
make-sqldeveloper-package was written by Lazarus Long <lazarus.long@bigfoot.com>.
This manual page was written by Lazarus Long <lazarus.long@bigfoot.com>, for the Debian project (but may be used by others).
GNU
2012-11-13 MAKE-SQLDEVELOPER-PACKAGE(1)