Search results
18 mar 2023 · Here is an example that loads a GIF into the datbase and displays it. You would of course change the mime type and the name of the procedure from .gif to .pdf. Then you will be able to use HTML like: <a href=/dcd/owa/image.pdf?p_id=55>Click Me</a> to retrieve "document 55" for example.
You can use get_pdf function which returns BLOB data of PDF. Example: select 'application/pdf', as_pdf3_v5.get_pdf() from dual. Elimina
18 wrz 2019 · IF NOT (EXISTS (SELECT * from table_name_1 where name='NAME_1')) BEGIN. IF (EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'table_1' AND COLUMN_NAME='NAME_2')) EXEC('insert into table_name_1 values (''value1'', (select max(column) from table_2), 20)'); ELSE.
8 lip 2022 · If you are a user of Oracle’s Smart View Excel Add-in, you may find yourself wanting to automate some of its data retrieval capabilities with VBA Code. This article will show you how to call some of Smart View’s built-in functions with VBA code.
13 mar 2023 · This tutorial explains how to use IF NOT logic in VBA to test if some condition is not met, including examples.
The IF statement allows you to either execute or skip a sequence of statements, depending on a condition. The IF statement has three forms: IF THEN ELSE. IF THEN ELSIF. PL/SQL IF THEN statement. The following illustrates the structure of the IF THEN statement: IF condition THEN . statements; END IF;
One of the conditions in CASE statements in PL/SQL must be true. If the database reaches the end of the statement without activating one, it raises CASE_NOT_FOUND.
