Top "Oracle10g" questions

How to find the privileges and roles granted to a user in Oracle?

I am using Linux, Oracle10g. I have created one user called test. and granted create session and select any …

oracle security oracle10g user-accounts

Checking oracle sid and database name

I want to check SID and current database name. I am using following query for checking oracle SID select instance …

oracle oracle10g

CASE .. WHEN expression in Oracle SQL

I have the table with 1 column and has following data Status a1 i t a2 a3 I want to display …

sql oracle oracle10g

How to insert date values into table

How can I insert into table with different input using / ,with date datatype? insert into run(id,name,dob)values(&…

sql oracle datetime oracle10g date-formatting

DBMS_OUTPUT.PUT_LINE not printing

When executing the following code, it just says the procedure is completed and doesn't print the infomation i want it …

plsql oracle10g sqlplus dbms-output

ORA-01861: literal does not match format string

When I try to execute this snippet: cmd.CommandText = "SELECT alarm_id,definition_description,element_id, TO_CHAR (alarm_datetime, …

sql oracle oracle10g ora-01861

Oracle date "Between" Query

I am using oracle database. i want to execute one query to check the data between two dates. NAME START_…

sql oracle oracle10g where-clause date-arithmetic

If statement in select (ORACLE)

Hi I have simply select and works great: select 'CARAT Issue Open' issue_comment, i.issue_id, i.issue_status, …

sql oracle select if-statement oracle10g

How to execute an oracle stored procedure?

I am using oracle 10g express edition. It has a nice ui for db developers. But i am facing some …

oracle plsql oracle10g ora-00900

How to check for null/empty/whitespace values with a single test?

I'd like to write a SELECT statement that uses just one test to return columns with no value (null, empty, …

sql oracle oracle10g