Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    Index MIN/MAX Optimization

    Dear Team, I have a logging table with the following structure: SQL> desc t Name Null? Type ----------------------------------------------------- -------- ------------------------------------ LOG_ID
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    How to convert only HH24:MI:SS from SYSDATE?

    Hello. I have a quick question about Oracle 11g SQL command. I need to get only HH24:MI:SS data from SYSDATE; for example, select TO_DATE(SYSDATE, 'HH24:MI:SS') from dual; I tried it then error is like below. ORA-01861: literal does not match format string 01861. 00000 - "literal...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    How does Oracle know whether the index belongs to the primary key?

    Consider the following two tables and their primary keys: create table testuser.test1 ( col1 number not null, col2 number not null, col3 number not null ); alter table testuser.test1 add constraint test1_pk primary key (col1); create table testuser.test2 ( col1
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Oracle application containers

    I have created application root container and two applicatioon PDBs. In application root created a table products ar follows: CREATE TABLE products SHARING=EXTENDED DATA (prod_id NUMBER(4) CONSTRAINT pk_products PRIMARY KEY, prod_name VARCHAR2(15)); ALTER TABLE hr_app_owner.produ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Oracle dump into csv file have a empty line at start.

    I am executing a sql-plus session to dump a table's data into a .csv file. I need header details along with the data in the dumped csv file. When I use the "set heading on" option, I am getting header details along with the data plus one empty line at the start. I tried multiple ...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

Free training, how-tos and Q&A with Oracle experts, every month! Learn more