background preloader

Development

Facebook Twitter

Sql - extract multiple values from string based on REGEXP_INSTR in Oracle. Do You Really Understand SQL’s GROUP BY and HAVING clauses? – Java, SQL and jOOQ. There are some things in SQL that we simply take for granted without thinking about them properly.

Do You Really Understand SQL’s GROUP BY and HAVING clauses? – Java, SQL and jOOQ.

One of these things are the GROUP BY and the less popular HAVING clauses. Let’s look at a simple example. For this example, we’ll reiterate the example database we’ve seen in this previous article about the awesome LEAD(), LAG(), FIRST_VALUE(), LAST_VALUE() functions: Before there were window functions, aggregations were made only with GROUP BY. A typical question that we could ask our database using SQL is: What are the top 3 average government debts in percent of the GDP for those countries whose GDP per capita was over 40’000 dollars in every year in the last four years Whew. SQL & PL/SQL » Timestamp in ISO 8601 compliant standard. Mjkreddy1982 wrote on Thu, 25 March 2010 05:27 Michel Cadot wrote on Thu, 25 March 2010 05:25 To store a timezone, no.

SQL & PL/SQL » Timestamp in ISO 8601 compliant standard

To do what you want, it depends on your environment, I told you about alternative ways in a previous post.Note: a lone interrogation mark is sufficient to indicate this is a question, you don't need to multiply them (unless you want to make a breeding).Regards Michel thanks michel, for the responce Hi Here i have done something please check and give me some comments..wethere is this helpfull for converting the existing timestamp to required timezone.

Convert_TimeZone(Date, From Timezone, To TimeZone) Function: Oracle sqldeveloper - sql developer hangs on startup - what can I do? Java - Using "like" wildcard in prepared statement. How to configure oracle to kill both sessions w... ALTER TABLE privilege and CREATE/DROP/ENABLE/DI... Hi, You may be confusing yourself.

ALTER TABLE privilege and CREATE/DROP/ENABLE/DI...

JDBC/UCP Download Page. ORACLE Transactions and Fishing on the Underground. It’s that time of year again.

ORACLE Transactions and Fishing on the Underground

Yes, it is the season to be snotty. “Man-flu”, was Nurse Debbie’s considered medical opinion. Admittedly, she’s feeling a bit under the weather herself and, as we all know, “Bird-flu” is a far more serious condition. I think I must have picked up this particular bug during my daily commute, which currently involves quite a lot of time on the Tube. In order to pass the time in the morning crush that is the Northern Line, I’ve taken on a challenge from Simon.

He claims that, apart from St. Whilst this may seem a somewhat esoteric fact, it’s probably quite appropriate to look for bits of fish whilst wedged into a Tube train like a sardine. The tube map itself includes station on the Overground Network as well as the DLR so, ironically, this does provide a bit of “wiggle-room” for my Mackrel search. How to remote debug PL/SQL with Oracle SQL Developer. There are quite a few posts (see the References section at the bottom) on how to debug PL/SQL remotely.

How to remote debug PL/SQL with Oracle SQL Developer

That is when you want to step through another session that is running some PL/SQL procedure. Still I didn't find it obvious to get it working. Mainly because none of the blog posts have a diagram on how all components are connected and which component tries to connect with the other component(s). Tech Team Lead News: How to remote debug PL/SQL with Oracle SQL Developer. Le blog Oracle d'Ahmed AANGOUR: ORA-02449: unique/primary keys in table referenced by foreign keys. L'erreur ORA-02449 indique simplement que vous tenter de dropper une table qui est référencée par une clé étrangère d'une autre table.

Le blog Oracle d'Ahmed AANGOUR: ORA-02449: unique/primary keys in table referenced by foreign keys

Pour résoudre ce problème il faudrait supprimer ces Foreign Key (FK) avant de dropper la table, mais comment déterminer les tables qui référencent cette Foreign Key ? La requête suivante peut vous permettre de répondre à cette question: Ask TOM "Dynamic SQL to reset sequence value" How to Start the PL/SQL Debugger. Tell Others About This Story: Starting the debugger CAN be as simple as hitting this button in Oracle SQL Developer: The second button on the PL/SQL Editor toolbar But But, you need to make sure of the following: You have compiled for debugYou have the privsYou have a breakpoint set OR you have set the debugger preferences to start with a ‘Step Over’On Database 12c, you’ve done setup the network access control list That’s a lot of buts.

How to Start the PL/SQL Debugger

Wait, wait, wait. Ok, now we can start. SQL Oracle : Types de données. Ask Tom "TIMESTAMP columns in DBA_OBJECTS" Followup April 22, 2013 - 2:23 pm UTC ...

Ask Tom "TIMESTAMP columns in DBA_OBJECTS"

The created is greater than last_ddl_time. Oracle/PLSQL String Functions. ORACLE-BASE - PL/SQL Enhancements in Oracle Database 10g. Home » Articles » 10g » Here.

ORACLE-BASE - PL/SQL Enhancements in Oracle Database 10g

Ask Tom "Assign return value to Unix Variable" Hi Tom,

Ask Tom "Assign return value to Unix Variable"

Dependencies Among Schema Objects. The definitions of some objects, including views and procedures, reference other objects, such as tables. As a result, the objects being defined are dependent on the objects referenced in their definitions. This chapter discusses the dependencies among schema objects and how Oracle automatically tracks and manages these dependencies. This chapter contains the following topics: Introduction to Dependency Issues Some types of schema objects can reference other objects as part of their definition.

If you alter the definition of a referenced object, dependent objects may or may not continue to function without error, depending on the type of alteration. Oracle automatically records dependencies among objects to alleviate the complex job of dependency management for the database administrator and users.