Hi, I need a sample for using sys_connect_by_path in sql query please regards,
Question
Oraask Latest Questions
Question
oracle userExplorer
hello experts, what i want is : query to display 'job' & their counts & then display the no. of distinct 'dept no' under each 'job' & their counts ? consider i have these dataset : SQL> select * from dept; DEPTNO DNAME LOC ---------- -------------- ...
Question
it is possible to INSERT or UPDATE or even DELETE a row inside table through view ?
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
hello guys can someone explain to me what is the differences by easy way and with example if possible.
Question
hi i have data set that has ampersand symbol "&" and i want to insert this data but when i put this symbol into values of insert statements TOAD asking for substitution value i tried to escape this symbol but it ...
Question
i have a string like this String Oracle Forms 10G and i want result to be like this String OracleForms10G without spaces between words is there any oracle function to do this ...