i want to update my table with data in another table in oracle sql for example Table 1: ID NAME DESC --------------------------- 1 ...
Question
Oraask Latest Questions
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 ?
Question
I'd like to create pl/sql array variable to hold an ordered collection of data thanks.
Question
I want to order by a string in SQL query like Select * From employees ORDER BY names (mark, mac , jack, steve)