DECLARE
seq_exists_ NUMBER;
sql_stmt_ VARCHAR2(2000);
CURSOR check_exists IS
SELECT 1
FROM all_objects
WHERE object_name = 'SEQUENCE_NAME_SEQ'
AND object_type = 'SEQUENCE';
BEGIN
OPEN check_exists;
FETCH check_exists INTO seq_exists_;
IF (check_exists%NOTFOUND) THEN
seq_exists_ := 0;
END IF;
CLOSE check_exists;
IF (seq_exists_ = 0) THEN
Database_SYS.Create_Sequence('SEQUENCE_NAME_SEQ', 'MINVALUE 1 START WITH 1 INCREMENT BY 1');
END IF;
END;
/
"All truths are easy to understand once they are discovered; the point is to discover them." - Galileo Galilei (rmaxonenote is a place for Oracle PL/SQL, C# and IFS related solutions, code snippets, and etc...)
Search This Blog
Wednesday, July 27, 2022
Create Sequence in IFS
Subscribe to:
Post Comments (Atom)
Read file content from an Oracle Directory in PL/SQL/ in IFS
Read single file DECLARE file_handle_ UTL_FILE.FILE_TYPE; directory_name_ CONSTANT all_directories.directory_name%TYPE := '...
Popular Posts
-
To export the created File Type and File Template fully there is an existing File Template named ExtFileInsCreate (NOTE: This uses the proc...
-
DECLARE t1 timestamp; t2 timestamp; BEGIN t1 := systimestamp; FOR i IN 1..1000 LOOP Dbms_Output.Put_Line(TO_CHAR(i)...
-
To demonstrate the functions, opening quick report window is used. WAY 1 - Using iURL private void menuFrmMethods_menuTest_Execute(objec...
No comments:
Post a Comment