i face this error when trying to compile this pl/sql block Error: PLS-00103: Encountered the symbol "THEN" when expecting one of the following: := . ( % ; declare CURSOR abc IS select * from all_Objects; begin for rec in abc loop ...
Question
Oraask Latest Questions
Question
i have a table with some values in it basically i want to count how many number (2) present in this table : Col1 Col2 Col3 ----- ------- ------- 2 1 3 8 ...
Question
i want to update my table with data in another table in oracle sql for example Table 1: ID NAME DESC --------------------------- 1 ...
Question
i want to know whether partitioning enabled or not in my database
Question
i have two date columns and i want to get the number of days between those two dates
Question
please i want to read excel (.xlsx) from PLSQL ? is that possible or not ?
Question
i have a beginner question in SQL how to concatenate two string or two values in sql?
Question
Basically I want something as easy as WHERE something LIKE ('too%', '%noo%', 'sooo%') instead of WHERE something LIKE 'too%' OR something LIKE '%noo%' OR something LIKE 'sooo%' Is there any possible way to combine these two things without writing complicated sub-selects?
Question
please i want to know What is the difference between varchar and varchar2 data type in oracle?
Question
I have a cursor declared inside procedure into package and I want to use this cursor into another procedure or function inside the same package is that possible or not ?