Questions tagged as 'oracle-11g'

Tagged questions
1
answer

Because length returns the value of the mask and not the actual result?

I was trying to make a pad to the left of spaces to a number, so that in my view they were all formatted (in the view they can not be formatted). When I try the function that follows: LENGTH (TO_CHAR(a.variacion*100,'999990.99')) oh by c...
asked by 14.07.2017 / 20:44
2
answers

Oracle SQL SubConsulta

I'm doing a table query / modification exercise. I have two tables: CREATE TABLE CURSOS ( Codigo NUMBER, Nombre VARCHAR2(20), Cod_Profe NUMBER, Max_Alumn NUMBER, Fecha_Inic DATE, Fecha_Fin DATE, Num_Horas NUMBER, CONSTRAINT...
asked by 24.04.2017 / 11:47
1
answer

Automate Oracle SQL Developer script

I would like to know if it is possible to automate a script in the Oracle database manager. What happens is that I have to run 3 lines or queries, every day. And I would like to know if there is a way to make automated. The queries are 3 s...
asked by 03.01.2017 / 18:05
0
answers

ORA-01927 privilege is not revoked: can not REVOKE privileges you did not grant

With the user SYS it is required to revoke the privilege EXECUTE of the table AWRRPT_HTML_TYPE however when executing the statement REVOKE EXECUTE ON AWRRPT_HTML_TYPE FROM PUBLIC; Displays the following message:   ...
asked by 21.02.2018 / 20:37
1
answer

configure memory variables for Oracle 11 and 12 linux

I am currently trying to install an Oracle database (11g or 12c) on a virtualized opensuse, within the guidelines I followed request modifying the memory variables in the file /etc/sysctl.conf the variables are kernel.shmmax kernel.shm...
asked by 27.07.2018 / 04:18
0
answers

Oracle Backup with RMAN, runs slowly

Experts, I have an Oracle Database version 11g Release 11.2.0.3.0 - 64bit Production With the Real Application Clusters and Automatic Storage Management. Linux Red Hat operating system 2.6.18-348.12.1.el5. Database name: dbname Database...
asked by 04.04.2017 / 17:28
3
answers

how to do a SELECT of two different fields of the same table in a single column in Oracle 11g?

Good morning, I'm making a query I need to make a selection of 2 fields from the same table but within a single column column, that is SELECT desc_equipo, serialnro, serialmac from producto desc_equipo is let's say the field that stores the...
asked by 07.11.2016 / 16:44
2
answers

Error connecting SQL Oracle g11

Complete error: Status: Failure: Failed to test: Litener refused the connection with the following error: ORA-12505, TNS: listener does not currently know of SID given in connect descriptor the port in the web interface is " 1158 ",...
asked by 27.04.2017 / 04:59
1
answer

Migrate SQL Server database to Oracle

I'm trying to migrate a database from SQL Server to Oracle , for this I'm using Oracle SQL Developer as suggested by the following Oracle Tutorial , which has the following sections: Connection: 1. Install Oracle SQL D...
asked by 02.06.2016 / 00:37
2
answers

Query Oracle SQL HR schema, how to get a query referring to dates?

1. I want to show the employees that were hired in the month of May. select FIRST_NAME from EMPLOYEES where HIRE_DATE=????? 2.There is another query that employees ask me that do not have a commission but where I do COMMISSION_PCT = null or...
asked by 21.05.2018 / 17:35