How SID is different from Service name in Oracle tnsnames.ora
Why do I need two of them? When I have to use one or another? 5 Answers 5
oracle
How do I reset a sequence in Oracle?
In PostgreSQL, I can do something like this: ALTER SEQUENCE serial RESTART WITH 0; Is there an Oracle equivalent? 18 Answers 18
How do I turn off Oracle password expiration?
I’m using Oracle for development. The password for a bootstrap account that I always use to rebuild my database has expired. How do … Read more
Oracle find a constraint
I have a constraint called users.SYS_C00381400. How do I find what that constraint is? Is there a way to query all constraints? 3 … Read more
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
I have installed Oracle 11g Express Edition Release 2 in my windows 7 64 bit OS and tried to execute JDBC program, then … Read more
GROUP BY with MAX(DATE) [duplicate]
This question already has answers here: Fetch the row which has the Max value for a column (35 answers) Closed 4 years ago. … Read more
How can I get column names from a table in Oracle?
I need to query the database to get the column names, not to be confused with data in the table. For example, if … Read more
What’s the difference between RANK() and DENSE_RANK() functions in oracle?
What’s the difference between RANK() and DENSE_RANK() functions? How to find out nth salary in the following emptbl table? DEPTNO EMPNAME SAL —————————— … Read more
When do I need to use a semicolon vs a slash in Oracle SQL?
We have been having some debate this week at my company as to how we should write our SQL scripts. Background: Our database … Read more
What is the maximum length of a table name in Oracle?
What are the maximum length of a table name and column name in Oracle? 12 Answers 12