Questions tagged as 'oracle'

Tagged questions
1
answer

Encode64 in Oracle?

How do I do an encode64 to a query? This is my query select id_solicitud from sol_solicitud where id_solicitud=506 My query brings me 506, but I need the query to return me with encode64, that is to say that it appears like this NTA2...
asked by 25.07.2018 / 14:32
3
answers

Use LIKE or LTRIM - SQL

I am working with oracle and C # in Visual Studio 2015 and I have this query "SELECT * FROM TCTERCEROS WHERE TR_TERCERO = '" + TBNit.Text + "'" As I can apply a LIKE or LTRIM, TBNit.Text is what is said in the text box to see for example 12...
asked by 10.08.2018 / 15:35
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

Update of a table comparing or calculating with another [closed]

I need to do an Update of one table comparing or calculating with another. I have a table of jugadores with all your data including sueldo , rut , and other fields. Also, I have the table partidos with its respec...
asked by 27.11.2017 / 06:15
1
answer

The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception

I'm doing a program in C # that attacks an Oracle 12C database that is in another virtual machine, if I connect using SQL Developer I have no problems, I connect and I can work. Now I try to enter from code and I get the error indicated in...
asked by 01.06.2017 / 15:33
3
answers

Foreign key table - oracle sql

I have a table in Oracle SQL, and a field, I want it to be a foreign key of the same table, but Oracle gives me an error. create table Empleado_almacen ( cod_empleado_almacen int, dni varchar2(9), dni_jefe varchar2(9), nombre varchar2(30), dir...
asked by 09.06.2017 / 12:03
1
answer

Show the letters of a string and how many there are

I have a code that shows me the letters of a name and the number of letters in that name. But when he prints the letters and how many there are, he repeats the letters he has already read and tells me the spaces. Here the code: create or REPLA...
asked by 26.02.2017 / 03:15
3
answers

PL / SQL SMTP: 501 Error: attribute value too long

I am presented with an error when creating an automatic email through the database, I am creating the body and I get this error message:    ORA-29279: Permanent SMTP error: 501 Error: attribute value too long       ORA-06512: in "SYS.UTL_SMT...
asked by 11.02.2016 / 20:45
2
answers

Convert UNIX TIMESTAMP to DATE in Oracle

I need to convert a unix timestamp that is stored in a column of data type VARCHAR2 to a data type DATE. Example .. 1404316382 = 2014-07-02 15: 53: 02.000 Any ideas?     
asked by 26.04.2016 / 19:12
1
answer

Can many Tablespaces share a single datafile between them?

I understand that a Tablespace can have many datafiles but my question is whether among the Tablespace they can share only one datafile. Thanks     
asked by 06.10.2018 / 20:30