it is possible to INSERT or UPDATE or even DELETE a row inside table through view ?
Question
Oraask Latest Questions
Question
please i want to know all differences between procedure and function in oracle pl/sql thanks in advance.
Question
suppose I want to find all tables and views that has column name "last_name" for example.
Question
how do I check before adding a new column to a table if it's exists or not ? thanks in advance
Question
suppose we have 55214 (number of seconds) and i want to convert this number to Hours:Minutes:Seconds format how to do this in oracle ?
Question
some people suggest to use this query : select * from employees where rownum <= 10 order by salary; but the problem with this will return a random set of ten rows ordered by salary which is not what I need.
Question
What are the PL/SQL Program limits ?
Question
I have two tables one ordinary table and other is log of this table test_table test_tab_log I want to insert new row in the log table for each insert statement executed for basic table even if there is rollback executed. simply every row inserted in the base table ...
Question
hi is there any approach in pl/sql to execute more than one procedure in one time like: BEGIN Proc1('first'); Proc1('second'); Proc1('third'); END; but ...
Question
how can I convert text column value to array like : i have the values " text1, text2, text3" thanks in advance.