Questions tagged as 'oracle-sqldeveloper'

Tagged questions
1
answer

The default constructor does not work for me (Relational Object Database)

I would like to know if you see the error, is that I do not understand why I can not insert records with the constructor by default, only by the constructor that I have defined create or replace type MiembroEscolar force as object ( co...
asked by 01.04.2018 / 13:23
1
answer

What is the syntax to add a field to a column?

I need to know the syntax to add a field to a column, that is, I have to create an anonymous block where I ask the user to write me a name, after that I have to create a procedure to add the name that has given me past. Here I ask the user to...
asked by 07.04.2018 / 20:13
1
answer

Use a case with data from a table and have the results of that case save them in a table

I have 1 table called 'CFACTURACOMISION' which has the columns. CLFILIAL, CLCLIENTE, CLASESOR, FOFACTURA, DACHAFACTURA, MNFACTURA, MNDESCUENTO MNIVA, MNTOTAL, FEVENCIMIENTO, CONDICIONESDEPAGO, PROMVENTA. The main objective of this table is...
asked by 20.03.2018 / 19:36
2
answers

Convert string to decimal in oracle

I try to convert a decimal number contained within a string to a decimal and I get the following error: Oracle Database    ORA-01722: invalid number   01722. 00000 - "invalid number"   * Cause: The specified number was invalid.   * Action:...
asked by 03.02.2018 / 05:34
1
answer

Error trying to connect to sql plus from the Ubuntu terminal

I'm trying to connect to the sql plus from ubuntu but I get this ERROR ubuntu@ubuntu6:~$ su oracle Contraseña: oracle@ubuntu6:/home/ubuntu$ lsnrctl start oracle@ubuntu6:/home/ubuntu$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Productio...
asked by 05.01.2018 / 23:45
0
answers

ORA-12505, TNS: listener does not currently know of SID given in connect descriptor

Good afternoon, what happens is that I have an error when trying to create a connection in SQLDeveloper "Status: Fail: Failed to test: Listener refused the connection with the following error: ORA-12505, TNS: listener does not currently know of...
asked by 03.12.2017 / 21:14
2
answers

Create a view in sql that collects employee and salary data

I am doing a job for the school, in which they ask me to make a view that collects the following data: ID of the employee, name and surname, salary, maximum salary and% of the current salary with respect to the maximum (I do not understand th...
asked by 15.10.2017 / 11:37
0
answers

I need help Bloques-PL / SQL

Hi, could you help me solve this exercise please, I do not understand what control structure I could use, very kind for your time     
asked by 23.10.2017 / 17:58
1
answer

Status: Failure: Failure to test: I / O error: The Network Adapter could not establish the connection

I just installed Oracle Database 12c Release 2 (12.2.0.1.0) on my pc with windows 10. The problem is that I can not create a connection from the Oracle SQL Developer and the message appears in red (see image). When testing the connectiv...
asked by 16.09.2017 / 08:19
1
answer

Sum of oracle columns from php

I have this query from PHP , which does not return values but if I execute it from Oracle SQL Developer it shows me data. $sucursalesaño=[]; $ventasaño=[]; $query ='SELECT S.SUCURSAL , SUM(V.TOTAL_VENTAS) FROM T_VENT...
asked by 08.09.2017 / 18:14