Top "Oracle" questions

I have a constraint called users.SYS_C00381400. How do I find what that constraint is? Is there a way …

I am having a hard time converting stored procedures from SQL Server to Oracle to have our product compatible with …

In SQL Server we can use this: DECLARE @variable INT; SELECT @variable= mycolumn from myTable; How can I do the …

I'm getting this error: ORA-01950: no privileges on tablespace 'USERS' I have a default tablespace and I'm able to create …

I'm comparing three Oracle schemas. I want to get a list of all the functions and procedures used in each …

I'm sure this question has been answered already, however I was unable to find an answer using the search tool. …

I have some queries to find out the ddl of some objects from a schema. The result columns I am …

I would like to know if there are any differences in between the two not equal operators <> and != …

Just can't figure out why it gives me ORA-06512 Error PROCEDURE PX(pNum INT,pIdM INT,pCv VARCHAR2,pSup FLOAT) …

I need to debug in pl/sql to figure times of procedures, I want to use: SELECT systimestamp FROM dual …