plugin notepad format sql

 https://www.sqlinform.com/download-free-notepad-plugin/

cursor PLSQL

declare
  cursor public cur is
    select col1, col2
    from tabla;
begin
  for v_reg in cur loop
    dbms_output.put_line ('Col1: '|| v_reg.col1 ||'  Col2: '|| v_reg.col2);
  end loop;
end;

https://es.wikibooks.org/wiki/Oracle/PL/SQL/Cursores

excepciones PLSQL

https://www.tutorialspoint.com/plsql/plsql_exceptions.htm

show errors trigger

http://www.java2s.com/Code/Oracle/Trigger/Showerrorsforatrigger.htm

Delete Oracle

2 3 4 5

DELETE FROM     table_name WHERE     condition;

trigger '' is invalid and failed re-validation

Revisar que al final no haya un /

CLEAR_BLOCK(NO_VALIDATE);

Se puede poner asi:

 GO_BLOCK('INGRESAR_NUEVO_ACTIVO_FIJO');
 CLEAR_BLOCK(NO_VALIDATE);

o

GO_BLOCK('INGRESAR_NUEVO_ACTIVO_FIJO');
CLEAR_BLOCK;

https://magicplsql.blogspot.com/2018/06/escribiendo-codigo-flexible-en-oracle.html

link a file markdown

Si quieres solo abrir el archivo
[Ver Documento de Pruebas](:\\dfd\asdf\adfdsf\fadsf\asdf\asfd\afddf\asdf\dfdsffadsf.xlsx)


si quieres descargar el archivo al abrirlo:
[Ver Documento de Pruebas](file:///\\dfd\asdf\adfdsf\fadsf\asdf\asfd\afddf\asdf\dfdsffadsf.xlsx)

link url :

My favorite search engine is [Duck Duck Go](https://duckduckgo.com).

Comments

https://www.vojtechruzicka.com/stop-using-javadoc-author-tag/

item property enable

https://stackoverflow.com/questions/24593751/enable-disable-item-based-on-the-value-of-the-list-item

notepad++

https://thomas.vanhoutte.be/miniblog/notepad-remove-new-line-and-add-comma/

and you want this outcome:

Apple, Orange, Strawberry, Banana, Kiwi

Then do this: CTRL + H to open the Replace window. Then select Regular Expression in Search Mode. In the Find What, enter [\r\n]+. Then in the Replace with, enter the comma (,) and maybe followed by a space if you also want to add that.

PDE PER 001

Reiniciar forms builder

PLS-00103: Encountered the symbol "CURSOR_NAME" when expecting one of the following:

El cursor debe declararse antes del beginPACKAGE BODY PKCON_DEP
IS

PROCEDURE procedure ( )
IS
 valor NUMBER := 0;


--DEFINICIÓN DE CURSORES

BEGIN
NULL;
END;

execute query where clause oracle forms

http://robertodiazg.blogspot.com/2014/02/ejemplo-de-setblockpropertybloquedefaul.html

acordarse de quitarle la propiedad al boton de mouse navigator dejarla en NO

disabled item failed validation FRM-40222: Disabled item 'item_name' failed validation.

http://en.glufke.net/oracle/viewtopic.php?f=4&t=2958

EXECUTE QUERY BASED IN A RELATION ORACLE FORMS 6I

You have to create the relation in the main block.

QUERY SINCE ENTRANCE IN THE FORM ORACLE FORM6I

WHEN_NEW_FORM_INSTANCE

GO_BLOCK('CON_ACTIVOS');
EXECUTE QUERY;

Forms 6i Datos claves primarias

Display

Show description of a field in oracle forms 6i

post-query
when_validate_item


SELECT NOMBRE 
INTO : NOVEDADES.NOMBRE_CONCEPTO
FROM  CONCEPTOS
WHERE ID_CONCEPTO_CNC= : NOVEDADES.CONCEPTO_NVD;

summation in forms 6i

Choose the column
control+c
Control+v
f4
numb items display 1
Database: remove column name
database item:no
calculation mode: summary
sum function=>sum
sum block
sum item
go to block: properties
query all records





Elije columna
Control+c
Control +v
f4 properties
numb items display 1
Database: quitar column name
database item: no
calculation mode: summary
sum function =>sum
sum block
sum item
vamos al bloque: properties
Query all records

Scroll bar in forms 6i

Hello,
You cannot attach scroll bars to a content canvas, but you can show both horizontal and vertical scroll-bars for a stacked canvas.
Also, you can show horizontal and vertical scroll-bars for any window,
independently of the scroll-bars belonging to a stacked canvas or to any block displayed
on that canvas.

The block object itself can only have one single scroll-bar, so you should use stacked canvas and/or window scroll bars for having both a vertical and a horizontal scroll-bar displayed.

Best Regards,
Iudith 

https://it.toolbox.com/question/how-to-attach-a-horizontal-scroll-bar-and-vertical-scroll-bar-for-a-block-in-forms6i-070511

FORMS

https://www.youtube.com/watch?v=61g-OaOQ9jc 

DB EXAMPLE

CREATE USER usuario IDENTIFIED BY password; grant create session, grant any privilege to usuario; grant connect to usuario; GRANT CONNECT, RESOURCE, DBA TO usuario; grant create any table to usuario;
CREATE TABLE "USUARIO"."EMPLEADO" ( "ID" NUMBER NOT NULL ENABLE, "NOMBRE" VARCHAR2(20 BYTE), "EDAD" NUMBER, "SEXO" VARCHAR2(20 BYTE), "FECHA_NACIMIENTO" DATE, "ID_TIPO_EMPLEADO" NUMBER NOT NULL ENABLE, CONSTRAINT "PK_EMPLEADO" PRIMARY KEY ("ID") , CONSTRAINT "FK_TIPO_EMPLEADO" FOREIGN KEY ("ID_TIPO_EMPLEADO") REFERENCES "USUARIO"."TIPO_EMPLEADO" ("ID") ENABLE ) ; CREATE TABLE "USUARIO"."DEPARTAMENTO" ( "ID" NUMBER NOT NULL ENABLE, "DESCRIPCION" VARCHAR2(20 BYTE), CONSTRAINT "PK_DEPARTAMENTO" PRIMARY KEY ("ID") ) ; CREATE TABLE "USUARIO"."EMPLEADO_DEPARTAMENTO" ( "ID_EMPLEADO" NUMBER NOT NULL ENABLE, "ID_DEPARTAMENTO" NUMBER NOT NULL ENABLE, CONSTRAINT "PK_EMPLEADO_DEPARTAMENTO" FOREIGN KEY ("ID_EMPLEADO") REFERENCES "USUARIO"."EMPLEADO" ("ID") ENABLE, CONSTRAINT "PK_DEPARTAMENTO_EMPLEADO" FOREIGN KEY ("ID_DEPARTAMENTO") REFERENCES "USUARIO"."DEPARTAMENTO" ("ID") ENABLE ) ; CREATE TABLE "USUARIO"."TIPO_EMPLEADO" ( "ID" NUMBER NOT NULL ENABLE, "DESCRIPCION" VARCHAR2(20 BYTE), CONSTRAINT "PK_TIPO_EMPLEADO" PRIMARY KEY ("ID") ) ;

INSERT INTO "USUARIO"."TIPO_EMPLEADO" (ID, DESCRIPCION) VALUES ('1', 'ING. SISTEMAS') INSERT INTO "USUARIO"."TIPO_EMPLEADO" (ID, DESCRIPCION) VALUES ('2', 'ING. INDUSTRIAL') INSERT INTO "USUARIO"."EMPLEADO" (ID, NOMBRE, EDAD, SEXO, FECHA_NACIMIENTO, ID_TIPO_EMPLEADO) VALUES ('1', 'SILVIA QUIROGA', '29', 'F', TO_DATE('1989-07-17 21:57:42', 'YYYY-MM-DD HH24:MI:SS'), '1')
INSERT INTO "USUARIO"."EMPLEADO" (ID, NOMBRE, EDAD, SEXO, FECHA_NACIMIENTO, ID_TIPO_EMPLEADO) VALUES ('2', 'CARLOS CENTENO', '21', 'M', TO_DATE('1996-08-16 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), '2') INSERT INTO "USUARIO"."DEPARTAMENTO" (ID, DESCRIPCION) VALUES ('1', 'ADEI') INSERT INTO "USUARIO"."DEPARTAMENTO" (ID, DESCRIPCION) VALUES ('2', 'ISA') INSERT INTO "USUARIO"."EMPLEADO_DEPARTAMENTO" (ID_EMPLEADO, ID_DEPARTAMENTO) VALUES ('1', '1') INSERT INTO "USUARIO"."EMPLEADO_DEPARTAMENTO" (ID_EMPLEADO, ID_DEPARTAMENTO) VALUES ('2', '2') INSERT INTO "USUARIO"."EMPLEADO_DEPARTAMENTO" (ID_EMPLEADO, ID_DEPARTAMENTO) VALUES ('1', '2')

Bluefish instalación

https://adellefrank.com/blog/review-how-to-use-install-bluefish-text-editor-windows-vista-windows-7

1. Un-install any flavors you have of GTK on your computer (this assumes that, like me, you've been trying to fix this yourself for a while).
2. Download and install version 2.14 of GTK for Windows (which is NOT the most current, stable version).
3. Download and install the latest version of Bluefish for Windows.