Greetings!
This is an excerpt from the Oracle documentation:" ...ORACLE SQL*Plus BREAK command creates a subset of records and add space and/or summary lines after each subset. The column you specify in a BREAK command is called a break column which suppresses duplicate values. For example
SQL> BREAK ON DEPTNO SKIP 1 // To insert a blank line
SQL> SELECT DEPTNO, ENAME, SAL
...
DTV12345
Joined: Jun 14 '07
Location: Los Angeles, California
-
DB2 equivalent for ORACLE SQL*Plus BREAK???
-
DB2 equivalent for Oracle's PMON??
Greetings!
Imagine 2 hosts: host A runs Oracle 10g , host B runs IBM DB2 v9.
I have to write a shell script (bask/Korn...) that checks if a database instance is up and running and does a bunch of other stuff...
For instance, I can do something like this on host A (the host for the Oracle 10g database):
...Code:export ORACLE_SID=<instance name> ... check_db=`ps -ef|grep ${ORACLE_SID}|grep -
Never mind...all I have to do is use CURRENT_DATE instead of CURRENT_DAY.
It works fine now. -
SQL0206N, case statement and time calculation
Hello!
I am attempting to create a query that calculates a time value from GMT to
Pacific time. It is, of course, based on the calendar date that I will
have to figure out whether or not daylight savings applies (i.e. subtract
7 or 8 hours to get Pacific time).
In this query below, "LVDURATION.STA RT_TIME" is expressed in GMT time: I have to present it in the query output as Pacific time.... -
How can I bulk-load a typed table?
Hello!
I have been assigned to bulk-load data into several typed tables of our ODS. I am not clear as to whether it can be done.
Here's my homework ===>>>
The easy way is to perform INSERT statements manually, like this
...Code:insert into callbacks ( account_info, nbr_clbk, load_date ) values ( account_obj() ..account_number('123456') ..account_status('ACTV')
No activity results to display
Leave a comment: