lucas.favaro
9f6201f0af
davinTI/app-dono-modulos/pipeline/head There was a failure building this commit
27 lines
568 B
SQL
27 lines
568 B
SQL
-- +goose Up
|
|
DECLARE
|
|
v_count NUMBER;
|
|
BEGIN
|
|
SELECT COUNT(*) INTO v_count
|
|
FROM USER_INDEXES
|
|
WHERE INDEX_NAME = 'IDX_FLASH_VENDAS_01';
|
|
|
|
IF v_count = 0 THEN
|
|
EXECUTE IMMEDIATE 'CREATE INDEX IDX_FLASH_VENDAS_01
|
|
ON TB_FLASH_VENDAS (NUMERO_LOJA, DATA_VENDA)';
|
|
END IF;
|
|
END;
|
|
|
|
-- +goose Down
|
|
DECLARE
|
|
v_count NUMBER;
|
|
BEGIN
|
|
SELECT COUNT(*) INTO v_count
|
|
FROM USER_INDEXES
|
|
WHERE INDEX_NAME = 'IDX_FLASH_VENDAS_01';
|
|
|
|
IF v_count > 0 THEN
|
|
EXECUTE IMMEDIATE 'DROP INDEX IDX_FLASH_VENDAS_01';
|
|
END IF;
|
|
END;
|