Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Why "an INTO clause is expected in this SELECT statement"

Dee102Jan 20 2021

Hello,
I have been a SQL Server developer for couple decades and recently started working on Oracle PL SQL. I have a simple query with a simple question. Maybe you can explain to me why I got that error, so I will understand the concept.Thanks.
declare p_start_dt date := '01-Jun-20';
p_end_dt date := '30-Jun-20';
BEGIN
SELECT *
FROM Table
WHERE date1 <= p_start_dt
and date2 >= p_end_dt;
END;

This post has been answered by mathguy on Jan 20 2021
Jump to Answer

Comments

unknown-7404

I want the uninstall tool to work with all popups suppressed so it just uninstalls the Java version installed with no user input. Are there such command switches available to do this?

Not that I am aware of.

You will also encounter several other issues with your plan.

1. the uninstall app won't work if your org uses any deployment rulesets. The irony is that such a ruleset is often used to try to control the use of Java and applets

Note:

The Java Uninstall tool will not run if your system administrator specified a deployment rule set in your organization.

A deployment rule set enables enterprises to manage their Java desktop environment directly and continue using legacy business applications in an environment of ever-tightening Java applet and Java Web Start application security policies. A deployment rule set enables administrators to specify rules for applets and Java Web Start applications; these rules may specify that a specific JRE version must be used. Consequently, the Java Uninstall tool will not run if it detects a deployment rule set to ensure that no required JREs are uninstalled.

2. admin users can just download and reinstall anything you remove again.

3. Local policy settings (e.g. on Windows) can prevent /hinder the proper removal especially of registry entries

I suggest you do what many other orgs do. They use a two-pronged approach:

1. create a corporate standard (and include it in a written document) about what is allowed on each machine based on each person's job or role

2. explicitly specify what additional software, if any, may be downloaded by employees

3. specify the administrative actions and penalties that will apply if software other than approved is found on an employees machine

4. require that all employees attend orientation to learn about the software standards, and sign a document acknowledging the standard and agreeing to abide by it.

5. deploy  virus detection tools that periodically scan employees PCs for viruses and unapproved software.

6. counsel an deal with any employee found to have unapproved software on their machine

Yours is a management problem and needs to be handled by management using the same tried and true methods that have been used for decades:

1. awareness

2. orientation/training

3. enforcement

4. remediation

In this day and age it is TRIVIAL to deploy scanning software that can detect any unapproved software and report the findings centrally.

.

1. create, distribute and orient ALL employees aboutdocumentationand handle this as part o using user training

3516752

I too was frustrated with this tool - seems like its not designed for enterprise deployment.

I was able to get it to work as a bodge/workaround - it isnt ideal but seems to do the trick. I put the code together below to stop the user from having to interact with the GUI, however it doesnt allow for hiding the GUI.

It can also be a little flakey if the user is clicking like mad elsewhere

Hope it helps anyway, put it into a VBS file in the same location as the exe:

Set WshShell = Wscript.CreateObject("Wscript.Shell")

WshShell.Run "JavaUninstallTool.exe", 9

Wscript.Sleep 2000

'setfocus

wshshell.AppActivate("Java Uninstall Tool")

WshShell.sendkeys "{ENTER}"

'AcceptEULA

Wscript.Sleep 500

wshshell.AppActivate("Java Uninstall Tool")

WshShell.sendkeys "{ENTER}"

'Version Selection

Wscript.Sleep 500

wshshell.AppActivate("Java Uninstall Tool")

WshShell.sendkeys "{ENTER}"

'CompletionDiag

Wscript.Sleep 50000

wshshell.AppActivate("Java Uninstall Tool")

WshShell.sendkeys "{ENTER}"

Regards

Minesh Pandya

Bibi77

I think you would have to create custom uninstaller. Are you by any chance using deployment tool kit written in Powershell?

1 - 3

Post Details

Added on Jan 20 2021
11 comments
26,925 views