Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Date update problem

Kam__apexJan 14 2022

Hi Friends
I have a table where 4 fields are created
att_day, att_month, att_year, attend_date
These att_day, att_month, att_year datatype is varchar2 and attend_date is date
att_day, att_month, att_year, attend_date
01 01 2022
02 02 2022
I want above varchar fileds data to be update in attend_date as date like 01/01/2022, 02/02/2022.
Please help how can i do this.
Regards
Kam

Comments

Billy Verreynne

SQLCL is a client application. It does not have users and passwords to use.
SQLCL connects to database servers (db instances). The database typically requires a username and password for authentication. SQLCL may prompt for these credentials to supply to the database.
There are no default usernames and passwords to use in today's Oracle database. Most schemas are also locked by default when the database is created.
Ask your DBA for the details of the database and user schema to use.

User_21BG6

i have installed sqlcl-21.3.3.322.1724..but it is asked user name and password in command prompt..please give the solution

Mike Kutz

What database are you trying to connect to?

User_H3J7U

Use /nolog parameter.

thatJeffSmith-Oracle

If you don't know your username and/or password, you need to talk to the person responsible for your database. If you don't know who that is, we can't help you.

1 - 5

Post Details

Added on Jan 14 2022
8 comments
384 views