Oracle Forms (MOSC)

MOSC Banner

Date ISSUE

edited Dec 3, 2013 2:32AM in Oracle Forms (MOSC) 2 commentsAnswered ✓
Dear Professionals,
I need to migrate data from a table to another table, the problem is FROM/SOURCE table having a field of varchar2 stored with date in format 'YYYY/MM/DD' and i need to migrate it to a table where date field is date, is there any way to convert the data from varchar to date before migrating, please help.

secondly, i have a field where employee full name is available from which i need to just take first name, is there any query to take first name out of full name by query, for example, "MALCOLM JOHNSON" is full name, i need to take only "MALCOLM", please help

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center