Пікірлер
@MatthewF-w8m
@MatthewF-w8m 2 күн бұрын
You're a life saver man! Thanks so much
@tyreevongsaly
@tyreevongsaly 4 күн бұрын
You saved me! It was my network adapter that kept causing the error earlier!
@-pljfb-
@-pljfb- 25 күн бұрын
my man thank you so much indians always best
@darkoandric4096
@darkoandric4096 Ай бұрын
Works! Thanks!
@Marshal098
@Marshal098 Ай бұрын
Thanks
@aXsc6_l
@aXsc6_l 2 ай бұрын
good video short and useful
@manimeena-xh6xm
@manimeena-xh6xm 2 ай бұрын
Sir I need Oracle 11g report calling &coding video ,do you have this video?
@patrykbarankiewicz6186
@patrykbarankiewicz6186 4 ай бұрын
Can I do it on amd cpu?
@SubhroneelGanguly
@SubhroneelGanguly 3 ай бұрын
This is for MacOS for Intel.
@franciscocorbalan9341
@franciscocorbalan9341 4 ай бұрын
Thanks a lot, i have been spent a lot of my time finding any solution, your video help me. Great!!!!!!!!
@adlenemenai
@adlenemenai 5 ай бұрын
thanks for this solution
@Domanica
@Domanica 5 ай бұрын
Bro thanks so much!! I had to force restart my PC almost 7 times! LOL
@zenchen围棋1712
@zenchen围棋1712 5 ай бұрын
really great, Will try that thanks !
@2112pjfran
@2112pjfran 7 ай бұрын
Do you have the script for Mac OS Sonoma?
@SubhroneelGanguly
@SubhroneelGanguly 7 ай бұрын
Still not successful in installing Sonoma. Will update as soon as done
@YouTube2ndOfficial
@YouTube2ndOfficial 8 ай бұрын
bootlooping
@SubhroneelGanguly
@SubhroneelGanguly 8 ай бұрын
Keep on trying. If don't work. Go to disk utility and erase the disk and reinstall. Alternaly could increase you Ram
@YouTube2ndOfficial
@YouTube2ndOfficial 8 ай бұрын
booting into verbose mode on startup
@enescivelek3369
@enescivelek3369 8 ай бұрын
So how can we add an mssql database to mysql phpadmin?
@SubhroneelGanguly
@SubhroneelGanguly 7 ай бұрын
I didn't understood your question. You cannot add msssql database to mysql database and if you are trying to connect to mssql database through phpmyadmin it's not possible. Though you can connect it using mysql workbench or oracle sql developer using external driver.
@enescivelek3369
@enescivelek3369 7 ай бұрын
@@SubhroneelGanguly When I use Mysql workbench, I can transfer the database in MSSQL to MYSQL, but I do not know how to use the database in Mysql Workbench in a project.Or if phpmyadmin is used on a server, I have no experience on how to use Mysql Workbench. I solved my problem through 3rd party software, but they are also paid.
@SubhroneelGanguly
@SubhroneelGanguly 5 ай бұрын
MySQL workbench is an interface. Database don't reside in MySQL workbench. If you want to use MySQL in a project you have to use data adaptor, like MySQL connector or MySQL jdbc or odbc driver.
@mrissmann
@mrissmann 9 ай бұрын
Like that you kept the mistakes in your recording since we will run into the same issues.
@gowealth2478
@gowealth2478 9 ай бұрын
Hello there! Are you ready to unlock new possibilities with dblink? I'm seeking your expertise to navigate through a little challenge I'm facing. Your assistance could be the lucky break I need. Mind lending a hand?
@SubhroneelGanguly
@SubhroneelGanguly 7 ай бұрын
Expecting response if you are still on it.
@SteveF-nx2zd
@SteveF-nx2zd 9 ай бұрын
I tried to use fputcsv but it's almost impossible, mch easier this way!
@Rawaz3
@Rawaz3 10 ай бұрын
thank you, works perfectly
@mhenley
@mhenley 11 ай бұрын
This was super helpful. Very much appreciate you taking the time to document it.
@nastenkaoo
@nastenkaoo Жыл бұрын
godfather :)
@biswanathbiswas7977
@biswanathbiswas7977 Жыл бұрын
Irritating.
@PeintiumMHX
@PeintiumMHX Жыл бұрын
what is that comment
@MikeMike-is2hl
@MikeMike-is2hl Жыл бұрын
Thanks Sir... Getting the "Data Modeler" from within "SQL Developer" was not intuitive.... File->Data Modeler->Data Dictionary->Import (around 1:35). Also, at around 3:08, Import to: panel... Select "New Relational Model"... key to getting the modeler with the Schema and Tables selected.
@ajiramadhanis9411
@ajiramadhanis9411 Жыл бұрын
hello sir, after migrating successfully. How you can login using GREENPLY_16? have you already create it before?
@محمودابوبكر-ك8ح
@محمودابوبكر-ك8ح Жыл бұрын
perfect
@Danjames-w4r
@Danjames-w4r Жыл бұрын
Thank you, it helped me. Can you partition by month only? I mean table will have only 12 partitions always, dates in the same month but different years still in the same partition?
@freddymora1815
@freddymora1815 Жыл бұрын
Excelente Muchas Gracias lo que necesitaba.
@patricklee1326
@patricklee1326 Жыл бұрын
Will the pk of the table also get migrated?
@SubhroneelGanguly
@SubhroneelGanguly Жыл бұрын
Yes
@comptegmail273
@comptegmail273 Жыл бұрын
will that synchronize the data between the databases?
@SubhroneelGanguly
@SubhroneelGanguly Жыл бұрын
I didn't understood what you mean by synchronization. It's a remote connection directly to the database not any replica.
@1spunch
@1spunch Жыл бұрын
how to convert dateserial to date?
@SubhroneelGanguly
@SubhroneelGanguly Жыл бұрын
Depends in what format your dateserial is. Suppose your date serial is in format yyyymmddmiss then taking an example like 20230509125600, to convert it to date use to_Date function like this to_date(20230509125600, 'yyyymmddmiss')
@tanphuchong3102
@tanphuchong3102 Жыл бұрын
If i want to configuring Linked Server in SQL Server to connect to Oracle database from pc to another pc how can I do ?
@SubhroneelGanguly
@SubhroneelGanguly Жыл бұрын
Process will be same. Make sure the remote PC is accessible. Add firewall rules for the port number, configure the tnsnames.ora with proper service name.
@neerajtripathy6526
@neerajtripathy6526 Жыл бұрын
How to export the resultset of a query(joining multiple table) into excel file last day of each month using stored procedure and involve package
@SubhroneelGanguly
@SubhroneelGanguly Жыл бұрын
create a scheduler job, and call the procedure within the job. Inside the procedure you can set a condition like sysdate = lastday(sysdate) and if successfully executed add a flag into a table to check the export doesn't happens twice.
@arpankumarkar4895
@arpankumarkar4895 Жыл бұрын
Hello sir how to edit view SQL query
@SubhroneelGanguly
@SubhroneelGanguly Жыл бұрын
Use create or replace view viename. Replace keyword update the view when you execute the ddl
@sameerahmad7592
@sameerahmad7592 Жыл бұрын
Mr.Ganguly, kindly let me know how haad you connected different SQL Schemas (DB2/MySQL, etc..) to the one SQL Loader...? Please, I would be thankful to you... Thanks & Regards Sameer Ahmad
@SubhroneelGanguly
@SubhroneelGanguly Жыл бұрын
Database link is used to connect to oracle database from other instances. What you are talking about is connecting to different database for which you need to add third party driver in Oracle SQL Developer application. I am sharing two videos for connecting to SQL Server and DB2. Take a look if it helps. kzbin.info/www/bejne/rYm1f56kbcqVpbs kzbin.info/www/bejne/eGSUh4N9oNd4m8U
@mstechnical1937
@mstechnical1937 2 жыл бұрын
I want your WhatsApp
@fidafathima832
@fidafathima832 2 жыл бұрын
very easy to understand the concept
@rocknshake
@rocknshake 2 жыл бұрын
well explained and clear, thank you. I have a requirement to migrate from sql (sql server 2019) to oracle 12c, I tried to migrate using sql developer 19.2 but it is not working. As per the sql developer notes till sql server 2008 are only supported. Can you please help me in this regard? Thank you.
@SubhroneelGanguly
@SubhroneelGanguly 2 жыл бұрын
You suppose to use the compatible jar file. I will try to make a video on this give me some time
@rocknshake
@rocknshake 2 жыл бұрын
@@SubhroneelGanguly Sure, thank you. Sorry for the late reply I just saw the message as it automatically filtered to social in gmail. :(
@segicus
@segicus 2 жыл бұрын
Thanks!, it worked for me on the latest version of Microsoft SSMS to connect to Oracle database
@ahmadisultana6708
@ahmadisultana6708 2 жыл бұрын
hi
@barshi220274
@barshi220274 2 жыл бұрын
very nice video, can you please give me access to this code, sent request, thanks
@SubhroneelGanguly
@SubhroneelGanguly 2 жыл бұрын
Done!
@zhteja
@zhteja 2 жыл бұрын
Thanks dear, I stuck at this point, unfortunately there is no good stuff available on internet about oracle, today second time i come on your page and my issue is solved Thanks again
@mayurjackson3674
@mayurjackson3674 2 жыл бұрын
Hi Bro can you please send me the source code I have asked for permission
@SubhroneelGanguly
@SubhroneelGanguly 2 жыл бұрын
Done
@adileddaou593
@adileddaou593 Жыл бұрын
😊
@adileddaou593
@adileddaou593 Жыл бұрын
Hi mate, can you send me the source code please ?😊
@SubhroneelGanguly
@SubhroneelGanguly Жыл бұрын
drive.google.com/file/d/0BznrW3lgX0ozbUdkdEFmUGpHLWM/view?usp=drivesdk&resourcekey=0-V0n_GZudNmhs_50qM1GoyQ
@adileddaou593
@adileddaou593 Жыл бұрын
Thanks a lot bro👍
@Adam-gw8jt
@Adam-gw8jt 2 жыл бұрын
Was this recorded in a cave?
@SubhroneelGanguly
@SubhroneelGanguly Жыл бұрын
Sorry for your trouble.
@oscarmunoz8984
@oscarmunoz8984 2 жыл бұрын
Very nice, it worked very well! Thaks for your help!
@sivahanuman4466
@sivahanuman4466 2 жыл бұрын
Great video 👍
@userasdf1546
@userasdf1546 2 жыл бұрын
Error report - ORA-01031: insufficient privileges 01031. 00000 - "insufficient privileges" *Cause: An attempt was made to perform a database operation without the necessary privileges. *Action: Ask your database administrator or designated security administrator to grant you the necessary privileges
@SubhroneelGanguly
@SubhroneelGanguly Жыл бұрын
if you have access to system administrator your have to provide this privilege grant create database link to username, where username is the user who is creating the database link
@anudipray4492
@anudipray4492 2 жыл бұрын
Will the stored procedure and functions also get migrated
@SubhroneelGanguly
@SubhroneelGanguly 2 жыл бұрын
Yes incase of full export
@onyedikachiadigwe8995
@onyedikachiadigwe8995 2 жыл бұрын
How do I get my root password
@SubhroneelGanguly
@SubhroneelGanguly Жыл бұрын
If you are working from database server login to sqlplus using this command. sqlplus / as sysdba. After login in type the command password sys. Then type your new password, retype password. and it's done