when trying to get a record in ORACLE and the value of the property which I then use to make a validation contains a null value query error
Informe de error -
ORA-01403: No se ha encontrado ningún dato
ORA-06512: en línea 38
01403. 00000 - "n...
I am doing a stored procedure on the HR data base in pl / sql which returns me records.
CREATE OR REPLACE
PROCEDURE HR.Mostrar_Paises (continente NUMBER)
IS
v_rut VARCHAR(100);
BEGIN
for c in(Select Country_Name into v_rut from HR.COUNTR...
I am working in a DB2 environment using Oracle SQL Developer, I know I can find the structure of a table using:
SELECT * FROM Sysibm.syscolumns WHERE tbname = '[NOMBRE_TABLA]';
but this only shows me the rows of the table and its i...
For some reason, when executing the following code, the result of the query is not shown by the output of dbms. The same code has been tested on another PC and it works. For the script output shows that everything went well:
PL / SQL proce...
I need to change the prefix of one field to another for all records before a date.
UPDATE tabla
SET campo1 LIKE 'YYYYYYY%';
WHERE (campo1 LIKE 'XXXXXXXXXXXXX%' AND FECHA<DATE('2017-04-05'));
The following error report appears:
Error SQ...
Guys I need to convert a data type date and another type varchar to string type and then both are in string type concatenate them. Can I do that in plsql ???
I have to do an exercise that is a for loop but delimiting the minimum the maximum and the jump, the thing is that both the minimum and the maximum is done but the jump is not how to define it, I hope someone helps me.
I leave you my exercise...
I would like to know how to change the port of oracle 11g and what to occupy, that is, to know one that is free, since port 8080 is occupied by sql server and the 8081 Mysql.
Greetings and thanks.
Recently I'm working on SQL Developer and 'messing around' with the creation of data types. For now this is the idea:
CREATE OR REPLACE TYPE actividad_t AS OBJECT(
nombre varchar2(50),
contenido varchar2(50),
plantilla varchar2(50)...