Skip to content
IT Nursery
  • Home
  • Programming
    • PHP
    • C
    • C++
  • DataBase
    • MySQL
  • CMS
    • WordPress

oracle

How SID is different from Service name in Oracle tnsnames.ora

by IT Nursery

Why do I need two of them? When I have to use one or another? 5 Answers 5

Tags administration, database, oracle, service, sid

How do I reset a sequence in Oracle?

by IT Nursery

In PostgreSQL, I can do something like this: ALTER SEQUENCE serial RESTART WITH 0; Is there an Oracle equivalent? 18 Answers 18

Tags database, oracle, sequence, sql

How do I turn off Oracle password expiration?

by IT Nursery

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

Tags oracle, security

Oracle find a constraint

by IT Nursery

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

Tags constraints, oracle, sql

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

by IT Nursery

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

Tags jdbc, oracle

GROUP BY with MAX(DATE) [duplicate]

by IT Nursery

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

Tags greatest-n-per-group, group-by, ora-00979, oracle, sql

How can I get column names from a table in Oracle?

by IT Nursery

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

Tags database, oracle, sql

What’s the difference between RANK() and DENSE_RANK() functions in oracle?

by IT Nursery

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

Tags oracle, sql, window-functions

When do I need to use a semicolon vs a slash in Oracle SQL?

by IT Nursery

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

Tags oracle, sql, sqlplus

What is the maximum length of a table name in Oracle?

by IT Nursery

What are the maximum length of a table name and column name in Oracle? 12 Answers 12

Tags name-length, oracle
Post navigation
Older posts
Page1 Page2 … Page5 Next →

Important Tag

.net admin ajax android arrays bash c categories comments CSS custom-field custom-post-types custom-taxonomy customization database filters functions git hooks HTML images ios java javascript jQuery menus multisite MySQL node.js permalinks php plugin-development plugins posts python Shortcode sql string theme-development themes uploads users woocommerce-offtopic wp-admin wp-query

Recent Posts

  • INSTALL_FAILED_DUPLICATE_PERMISSION… C2D_MESSAGE
  • How to sort by meta value?
  • WPF text Wrap vs WrapWithOverflow
  • How to retrieve the list of all posts ever published via the feed?
  • how to use javascript Object.defineProperty

android c categories CSS custom-post-types custom-taxonomy customization database functions git HTML images java javascript jQuery multisite MySQL php plugin-development plugins posts python string theme-development wp-query

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Content from: Stack Exchange

Important Link

  • About
  • Privacy Policy

IT Nursery

The Goal of ITNursery Engaging the world to foster innovation through aggregate information. Our Question Answer post, blog information, products and tools help developers and technologists in life and at work.

copyright © 2023 All Right Reserved | IT NurSery