Hey does anyone know how to select a random time of the day in oracle?
im using
[code=oracle]
SELECT TO_DATE(TRUNC(D BMS_RANDOM.VALU E(2454467,24544 67+364)),'J')
[/code]
FROM DUAL;
to select a random date from 2008, but need to randomly select a time from the day too.
niz182
Last Activity: Feb 20 '08, 06:41 PM
Joined: Feb 12 '08
Location:
-
Select a random time
-
when i run that script i get the following error...
WHERE x.custid != y.custid
*
ERROR at line 5:
ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_X'
any idea what that means?... -
yeh, so it selects a caller from cust_details, then it selects a reciever from the same table....Leave a comment:
-
hey guys thanks for the help, the only problem im gettign with that code is that its selecting the same data for both the caller and the reciever
CALLER_CUST_ID CALLER_FIRSTNAM E RECEIVER_CUST_I D RECEIVER_FIRSTN AME
3 David 3 David
where im looking to have 2 diferent values selected.Leave a comment:
-
Selecting the Same Coloumn Twice
Hey all...first time to the site so excuse me for bein some what of a noob to how to properly ask questions.
Im looking to create a table which selects a cloumn from another table twice.
so i have a table of customers
Name Type
CUST_ID NUMBER
FIRSTNAME VARCHAR2(40)
and a table of calls
Name Type
CALLER_CUST_ID...
No activity results to display
Leave a comment: