Top "Oracle" questions

Oracle Database is a Multi-Model Database Management System created by Oracle Corporation.

Oracle : receiving ORA-06550 and PLS-00905

i have a holiday table which contains the data are HOLIDAYDA DESCRIPTION --------- -------------------- 19-JAN-11 to 17-JAN-11 to 10-JAN-11 new …

sql oracle plsql ora-00933 ora-06550
What exactly does trunc(date, 'IW')?

For my project I need to have an absolute numerical correspondence between days of the week and 1...7 values. As you …

sql oracle oracle11g date-formatting
Running Total by Group SQL (Oracle)

I have a table in an Oracle db that has the following fields of interest: Location, Product, Date, Amount. I …

sql oracle cumulative-sum
Display results in output parameter in Toad

I have a stored procedure in Oracle and I'm using an out parameter in it.. I want to know how …

oracle stored-procedures plsql toad
WFMLRSVCApp.ear file not found

I am trying to install Oracle 11g in my laptop. Im downloading the setup files from here: http://www.oracle.…

java database oracle oracle11g installation
Need to find next and previous working day in oracle

My query is somewhat like this: select 1 from dual where :p1_task_date in (sysdate,sysdate+1,sysdate-1) and :p1_task_…

oracle weekday
Connection string to Oracle 10g DB using VB.net

Hey all i am VERY new to a Oracle DB and i am trying to connect to it via VB.…

vb.net oracle visual-studio-2010 connection-string ora-12560
SYS_REFCURSOR as OUT parameter

I have a table contains (username-primarykey,password,age,gender); have to create procedure like procedure(username in varchar,s_cursor …

oracle procedure sys-refcursor
Select the first 150 rows, then the next 150 and so on?

How can I select in oracle sql in a Table the first x rows, then the next x and so …

sql oracle select rows
Create Materialized view which refresh records on daily

Currently the Materialized view which I had created using REFRESH ON DEMAND so in this case I need to refresh …

oracle view refresh materialized-views