SQL: External Table Part-1

Hey how can I like my local database table with a cloud server to read data from the cloud?

Thanks in a million! Very well explained. This is the nth time that I am watching this again. Great content. Awesome. Grade: A++ 💥

cant see your whole screen

Please, check video before publishing

Hello Sir,

I have a scenario where in particular folder we have 2 file with different format and 2 external table created to read those file. Now I got multiple files with same format and file name except timestamp is different for all so how can I read all those same file format file with same naming convention except timestamp is different for all using external table.
I don't want to create new external table and with subfolder option .

Can we read all same file format files with wild card.

Please help me here

Hello Sir,
I am seeing all your videos and all are very knowledgeable.
I have below query could you please help me with these.

I have 1 external table conatins 10 columns which reads data from processing blob file .But external table unable to read the blob file because few rows has 9 files and few have 10 and this is happening because last column if no data then no delimeter coming for that from Source .So how can we assign last filed as NULL if not present through external table.

Thanks in advance

pls make it clear not visible proper

Kindly reuplod the video please..

that is very good really like it but before upload you video once check it properly

Feel free to record again. Focus goes off screen.

Working Perfectly.... TY sooooooooo much

HI, can you pls tell me the command to grant directory permission to other user, the command you have typed in the part1 is not visible, thanks

receiving error as:

conn sys as sysdba

Error report -

Connection Failed

USER = sys

URL = jdbc:oracle:thin:@localhost:1521/orcl

Error Message = Listener refused the connection with the following error:

ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

Commit



is there any way to reset password

SQL>
SQL> SHOW USER
USER is "SYS"
SQL> PASSW SYS
Changing password for SYS
Old password:
New password:
Retype new password:
ERROR:
ORA-01005: null password given; logon denied

any help