Top "Oracle" questions

Number of days in a month

I have a monthly amount that I need to spread equally over the number of days in the month. The …

sql oracle plsql date-arithmetic

Oracle SQL - change decimal dot for a comma

I'm on Brazil, and our currency format is something like 'R$ 9.999,00'. I'm trying to select a field, and change …

oracle currency comma

Oracle: How to count null and non-null rows

I have a table with two columns that might be null (as well as some other columns). I would like …

oracle select null grouping

How to correctly make a public synonym

This is a pretty silly one, but I need help. I have a table owned by mydbowner. It is named …

oracle database-administration

to_date function with sysdate

select TO_CHAR(to_date(sysdate, 'DD-MON-YYYY'), 'DAY') FROM DUAL; When I run this query the output was : SUNDAY. But …

oracle oracle10g oracle11g sysdate

Subtracting n Days from a date using SQL

I am quite a beginner when it comes to Oracle. I am having trouble figuring out how to do something …

sql oracle date-arithmetic oracle8i

How to write to a text file from Pl/SQL, PLS error 00363

I am trying to write to a file from a procedure: out_File := Utl_File.FOpen('C:\test', 'batotest.txt' , …

oracle plsql utl-file

... where count(col) > 1

I have a table like this: +-----+-----+-------+ | id | fk | value | +-----+-----+-------+ | 0 | 1 | peter | | 1 | 1 | josh | | 3 | 2 | marc | | ... | ... | ... | I'd like …

sql oracle group-by having

Superkey, candidate key & primary key

Can any kind soul clarify my doubts with a simple example below and identify the superkey, candidate key and primary …

sql oracle primary-key relational

Remove all characters after a specific character in PL/SQL

How do I get a substring from this example value: john.abc_1234 I want it to return john.abc.So …

sql oracle plsql oracle9i substr