How to export your connection information to a file?
No Answer is Posted For this Question
Be the First to Post Answer
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
What are the Characteristics of Data Files ?
How to use regular expression in pattern match conditions in oracle?
Are truncate and delete commands same? If so why?
What are inner join and outer join?
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
can we pass two out parameters at a time in function?please answer to my question
what diffrence between function and procedure?
How to turn on or off recycle bin for the session?
Can we create trigger on materialized view in oracle?
how many columns can a plsql table have