Home / user-160246

Wiska's questions

Martin Hope
Wiska
Asked: 2022-09-03 23:47:11 +0800 CST
  • 1

Apparently I just ran out of space in my tablespace and I don't know how to increase its size, I tried the following command:

ALTER TABLESPACE SANDRA ADD DATAFILE '/u01/oradata/userdata03.dbf' SIZE 3000M;

and I get:

ORA-32771: cannot add file to bigfile tablespace

I don't know what else to try. If someone could tell me what to do I would appreciate it.

plsql
Martin Hope
Wiska
Asked: 2022-09-03 13:24:38 +0800 CST
  • 4

I have the following data in one of the columns of my table and each data is supposed to be encrypted

1415131228
1415131215
1415914797
1415131174
1415131173

The thing is that I don't know what type of encryption it is, nor how to decrypt it, the column is type VARCHAR2 and what I am supposed to find when decrypting it is a date with time included, but I don't know with what procedure, query or function to obtain the data I require.

I am working SQL - PL/SQL - External Tables - Oracle 11g

sql
Martin Hope
Wiska
Asked: 2022-08-29 19:25:17 +0800 CST
  • 3

I have a food record:

pollo, carne, pez, res, zanahoria

What I would like is to use a cursor to separate each food and enter each one in a new record

pollo
carne
pez
res
zanahoria

I'm using Oracle 11g - temporary tables - PL/SQL and this is more or less the idea:

CURSOR MIC IS 
        SELECT UPPER(ALIMENTOS) FROM COMIDAS

BEGIN
FOR I IN MIC LOOP
sql
Martin Hope
Wiska
Asked: 2022-08-04 13:40:09 +0800 CST
  • 0

I have the code:

private ArrayList<Casa> casas = new ArrayList<Casa>();

And when I add the data I want it to be added in alphabetical order.

I have tried with

Collection.sort(casas);

But I get an error like this:

Required type: List<T

Provided: ArrayList<Home

And I don't know how to solve it.

java
Martin Hope
Wiska
Asked: 2020-03-05 05:38:30 +0800 CST
  • -1

Imagine that GenerateGreetings requires greeting more than 50 people. It would not be logical to create 50 or more lines of code, knowing that arrays are objects that have the forEach method.

function GenerarSaludos() { // ojo con la notaciónde mayuscula inicial para diferenciar de componentes HTML
let personas = [
    { nombre: 'Carlos', apellidos: 'Cuesta Iglesias' },
    { nombre: 'Jordan', apellidos: 'Walke' },
    { nombre: 'Brendan', apellidos: 'Eich' }
];

return (
    <div>
        <Saludo nombre={personas[0].nombre} apellidos={personas[0].apellidos}/>
        <Saludo nombre={personas[1].nombre} apellidos={personas[1].apellidos}/>
        <Saludo nombre={personas[2].nombre} apellidos={personas[2].apellidos}/>
    </div>
);

}

Make the necessary adjustments to make this improvement in the code.

javascript
Martin Hope
Wiska
Asked: 2020-02-28 11:55:16 +0800 CST
  • 0

How do I load an entire JSON file that is written in the form of dictionaries? It is also so that it remains as a graph. The constellations are the largest "group", they have the name, in this case "Donkey Constellation" and it has some stars, the main one and the others that are connected to it.

     "constellations": [
    {
      "name":"Constelación del Burro",
      "stars":[
        {
          "id": 1,
          "label": "Alpha1",
          "linkedTo": [
            {
              "starId": 2,
              "distance": 120
            },
            {
              "starId": 4,
              "distance": 87
            },
            {
              "starId": 5,
              "distance": 101
            }
          ],
          "radius": 0.4,
          "timeToEat": 3,
          "amountOfEnergy": 1,
          "coordenates": {
            "x": 25,
            "y": 34
          },
          "hypergiant": false
        }]
      ]
   ]
python