Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Get error ORA-01843: not a valid month for oracle **Date must updated to current date and time by default** Create table: Create table Report (

Get error ORA-01843: not a valid month for oracle

**Date must updated to current date and time by default**

Create table: Create table Report (
Date date DEFAULT SYSDATE not null );

INSERT INTO ExpenseReport
(Date)
VALUES ( '8/10/2002');

how do I fix this?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Systems analysis and design

Authors: kenneth e. kendall, julie e. kendall

8th Edition

978-0136089162

More Books

Students also viewed these Programming questions