New answers tagged

-1

oracle SQL statement "CREATE DIRECTORY Mydir AS 'C:\Users\osman\Desktop\Export';" can't create any direcotry on Windows or Linux, it's just a mapping between variable Mydir and directory 'C:\Users\osamn\Desktop\Export' so you need to make sure your windows has 'C:\Users\osman\Desktop\Export' hope this can help you !


8

A .bacpac file = Schema + Data. Note that Data is BCP'ed out using Native format (not readable by Human). You can rename the .bacpac to .zip to see the actual contents. You can use ...DAC\bin\sqlpackage.exe commandline to extract the .bacpac contents programatically. It is a snapshot that includes User data + Schema from SQL Server or Azure SQL ...


1

PostgreSQL can't do this natively, but you can convert the CSV output to an XLSX file with a simple perl script. csv2xlsx: For this script to work, install Excel::Writer::XLSX and Text::CSV perl modules, either through apt-get/yum, or through sudo perl -MCPAN -e 'install Excel::Writer::XLSX' and sudo perl -MCPAN -e 'install Text::CSV'. #!/usr/bin/perl -w ...



Top 50 recent answers are included