Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Combining multiple rows to get a single one

User_UJ80KJun 10 2021 — edited Jun 10 2021

Source table :
--------------------------------------------------
| Employee Name | department | Emp Id |
--------------------------------------------------
| Sam | Sales | 101 |
--------------------------------------------------
| Sam | Finance | 101 |
--------------------------------------------------
| Dirk | marketing | 102 |
--------------------------------------------------
| Dirk | Research | 102 |
--------------------------------------------------

Output needed :

--------------------------------------------------------------
| Employee Name | Emp Id | department1 | department2|
--------------------------------------------------------------
| Sam | 101 | Sales | Finance |
--------------------------------------------------------------
| Dirk | 102 | marketing | Research |
-------------------------------------------------------------

Can you kindly help me with what functions or query should I use to get above mentioned output?

Comments

843810
Try this
String cmd = "java -jar \"" ++workingDir ++"\"/SwingApplication.jar";
Edited by: DynamicBasics on Jul 15, 2010 5:31 PM
User_64CKJ
A good case for using ProcessBuilder.
843810
String cmd = "java -jar \"" ++workingDir ++"\"/SwingApplication.jar";

doesnt seem to work, so i tried using process builder as suggested

ProcessBuilder pb = new ProcessBuilder("java -jar");
pb.directory(new File(workingDirPath + "/SwingApplication.jar"));
Process p = pb.start();

. but getting an exception

java.io.IOException: Cannot run program "java -jar" (in directory "C:\Run Application\SwingApplication.jar"): CreateProcess error=267, The directory name is invalid

Do I need to change the directory path in this?
User_64CKJ
javaquests wrote:
..ProcessBuilder pb = new ProcessBuilder("java -jar");
pb.directory(new File(workingDirPath + "/SwingApplication.jar"));
Process p = pb.start();

. but getting an exception

java.io.IOException: Cannot run program "java -jar" (in directory "C:\Run Application\SwingApplication.jar"): CreateProcess error=267, The directory name is invalid
While.. 
C:\Run Application\
..might be a directory, is.. 
C:\Run Application\SwingApplication.jar
?

I was thinking something more like this (untested).. 
String path = workingDirPath + "/SwingApplication.jar";
String[] command = {
	"java", 
	"-jar",
	path
};
ProcessBuilder pb = new ProcessBuilder(command);
Process p = pb.start();
BTW - when posting code, code snippets, HTML/XML or input/output, please use the code tags. The code tags protect the indentation anf formatting of the sample. To use the code tags, select the sample and click the CODE button.
843810
javaquests wrote:
String cmd = "java -jar \"" ++workingDir ++"\"/SwingApplication.jar";

doesnt seem to work, so i tried using process builder as suggested
The command to be finally executed is 
C:\Program Files\Java\jdk1.5.0\bin\java.exe -jar C:\Run Application\SwingApplication.jar
as the path has spaces, enclose in double quotes
"C:\Program Files\Java\jdk1.5.0\bin\java.exe" -jar "C:\Run Application\SwingApplication.jar"
This goes into the string variable like this
String cmd = "\"C:\\Program Files\\Java\\jdk1.5.0\\bin\\java.exe\" -jar \"C:\\Run Application\\SwingApplication.jar\"";
check the above command once.

Without the absolute path to the JAVA file, the control probably is searching for it in the current working directory.
843810
thank you so much it worked now.
843810
javaquests wrote:
thank you so much it worked now.
You are welcome, and it is a good practice to mark the question as 'answered'.

Edited by: DynamicBasics on Jul 15, 2010 10:38 PM
1 - 7

Post Details

Added on Jun 10 2021
#database, #oracle, #query, #sql, #table
4 comments
1,492 views
2 mentions