If server is in US and client is in india there is timezone
is diffrence, How can we display date in indian time when
data is displayed from US server timezone?
Answer / nithya
u can use 'to_char' function.
to_char('us date','indian date format model')
Is This Answer Correct ? | 1 Yes | 4 No |
what is the use of system.effective.date variable in oracle?
what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?
what is load balancing and what u have used to do this?(sql loader)
if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.
What is tns name?
7. Repeat query (7) but also display all clients who have never ordered anything.
What happens to the current transaction if the session is ended?
What are advantages fo Stored Procedures?
what is the output of select * from emp where null=null & select * from emp where 1=1
What is a user role in oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?