background preloader

Development

Facebook Twitter

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. Datamodel4reprpt.htm; filename "datamodel4reprpt. Datamodel4reprpt.htm; filename "datamodel4reprpt. 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.

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.

Ask TOM "Dynamic SQL to reset sequence value" Hi Tom, I'm trying to create a dynamic code to reset a sequence number, like that... declare v_initial number := 1; temp number := 0; cmd varchar2(100); begin cmd := 'alter sequence SEQ increment by -1'; execute immediate cmd; while true loop cmd := 'select SEQ.nextval from dual'; execute immediate cmd; select last_number into temp from user_sequences where sequence_name = 'SEQ';

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.

How to Start the PL/SQL Debugger

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 10g includes many PL/SQL enhancements including: PL/SQL Native Compilation The process of PL/SQL native compilation has been simplified in Oracle 10g.

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

The compiled shared libraries are now stored in the database and extracted as necessary. This means they form part of the normal backup and recovery process, require no manual maintenance and are available in Real Application Cluster (RAC) configurations. The PLSQL_NATIVE_LIBRARY_DIR parameter is the only one which must be set to use native compilation. Native compilation is switched on and off using the PLSQL_CODE_TYPE parameter which can be set at instance and session level using the ALTER SYSTEM and ALTER SESSION commands respectively. -- Set the PLSQL_NATIVE_LIBRARY_DIR parameter.

FORALL Support for Non-Consecutive Indexes (Sparse Collections) Oracle 10g introduces support for the FORALL syntax with non-consecutive indexes in collections. New IEEE Floating-Point Types -- Create package specification. Ask Tom "Assign return value to Unix Variable" Hi Tom, I am running some sql in unix.

Ask Tom "Assign return value to Unix Variable"

I am planning to transfer some array into a PL/SQL array. var_list is the collection name. I have created str_array as follows: create or replace type str_array as table of varchar2(2000); I have an array by name sql_string formed in my unix script. Var_list(variable1):=${sql_string[1]}; ==> This works. Dependencies Among Schema Objects. The definitions of some objects, including views and procedures, reference other objects, such as tables.

Dependencies Among Schema Objects

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.