Archivo de la categoría: ORACLE

Display the ok Prompt OpenBoot PROM

set /HOST/bootmode script=”setenv auto-boot? false” reset /SYS Choose the appropriate shutdown method from the following table to reach the ok prompt. Caution – When possible, reach the ok prompt by performing a graceful shutdown of the OS. Any other method used might result in the loss of system state data. System State What To Do… Leer más »

Precendence Rules OracleDB

paren = override = explicit 1. Arithmetic 2. Concat 3. Comparisons 4. IS (NOT) NULL, LIKE, (NOT) IN 5. (NOT) BETWEEN 6. NOT EQUAL 7. NOT 8. AND 9. OR   Ordering Query Results 1. SELECT _____ 2. FROM ______ 3. WHERE _____ 4. ORDER BY _____

Accessing X11 Display

Accessing X11 Display The X server controls which clients can access the server. Clients with access to the server can display windows or images on your screen, receive keyboard input, monitor mouse movement, and interact with the other clients on the system. The Trusted Extensions feature of Oracle Solaris adds security features to prevent labeled… Leer más »

apuntes

DESCRIBE : describing table structure DESC

How To Unlock HR user in Oracle Database 12c

I have been asked several times about how one can unlock HR schema or user in oracle database 12c? In this blog I will try to answer your question along with some common errors which you may face during or after unlocking the HR schema in Oracle Database 12c. So let’s go ahead and see… Leer más »

usefull commands

list SQL> define DEFINE _DATE = “06/04/15” (CHAR) DEFINE _CONNECT_IDENTIFIER = “orcl” (CHAR) DEFINE _USER = “SYSTEM” (CHAR) DEFINE _PRIVILEGE = “” (CHAR) DEFINE _SQLPLUS_RELEASE = “1201000100” (CHAR) DEFINE _EDITOR = “Notepad” (CHAR) DEFINE _O_VERSION = “Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application… Leer más »

change language sqlplus

51 down vote accepted Try to set user.language and user.country properties in sqldeveloper.conf file located in sqldeveloper\bin\ folder. Sample for set french language: IncludeConfFile ../../ide/bin/ide.conf SetJavaHome D:\jdk1.6.0_25 AddVMOption -Doracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG=true AddVMOption -Dsun.java2d.ddoffscreen=false AddVMOption -Dwindows.shell.font.languages= AddVMOption -Duser.language=fr AddVMOption -Duser.country=FR AddVMOption -XX:MaxPermSize=128M AddVMOption -Doracle.jdbc.mapDateToTimestamp=false IncludeConfFile sqldeveloper-nondebug.conf To switch off language try to remove its support by editing oracle.translated.locales… Leer más »