Skip to main content

Fully qualified table name for relational databases

Q: What is fully qualified table name pattern?
Ans: A fully qualified table name is an unambiguous name that specifies a table in a database.

It is advisable to use the fully qualified name of a table so that there are less chances of errors. Various databases have different patterns of fully qualified table names. Below given are the details of various databases and their fully qualified table name patterns


Database Fully qualified table Pattern

Oracle

SCHEMA.TABLE

DB2

CATALOG.TABLE

MySQL

SCHEMA.TABLE

Microsoft SQL Server

[CATALOG]..[TABLE]

PostGre SQL

"SCHEMA"."TABLE"

Comments

  1. Awesome,,I’d love to come back over and over again.

    ReplyDelete

Post a Comment

Have some feedback, comment or question ?
Post it here in comments section.

Popular posts from this blog

How to remotly debug java program using Eclipse

Eclipse provides a facility to debug your java programs remotely. To demonstrate how you can remotely debug java programs remotely, I will do the following: Create a .bat file that calls the java program Configure the arguments to the JVM so that the JVM will be capable of being remotely debugged Configure Eclipse to connect to the remote JVM 1. Create a bat file calling the java program I create a java class given below: public class RemoteDebugDemo { public static void main(String[] args) { System.out.println("STEP 1"); System.out.println("STEP 2"); System.out.println("STEP 3"); System.out.println("STEP 4"); System.out.println("STEP 5"); System.out.println("STEP 6"); } } Now I wish to run this program in batch mode.So I write a file called RemoteDebugDemo.bat file with following content. java -jar RemoteDebugDemo.jar I create a jar file named RemoteDebugDe...

How to convert a CSV file to XLSX

I wrote this utility for a friend of mine who wanted to convert large (~50MB) CSV files to XLSX. The CSV files had comma "," as a delimiter. I have used apache poi utility in this program. https://www.apache.org/dyn/closer.lua/poi/release/RELEASE-NOTES.txt This code uses SXSSFWorkbook class. The SXSSFWorkbook class uses "BigGridDemo" strategy, where only portions being processed are kept in memory. There are temporary files created which store the rest of the temporary data. setCompressTempFiles() method allows these temp files to be compressed. The size of these files can get quite large. The data to be converted was UTF-8 encoded data. So, we are using  OutputStreamWriter, where we specify the encoding of the data. If you do not need the encoding, just remove that parameter from the constructor call of OutputStreamWriter. The system where this ran, supported Java 7, so have not used features in java 8, such as try with exceptions. import java.io.*; im...

How to take a full webpage screenshot using AShot library

AShot library Ashot library by yandex.ru is something which I recently found. It can be used for multiple browsers. It is very simple to use. Just add maven dependency in your java code. < dependency > < groupId > ru.yandex.qatools.ashot </ groupId > < artifactId > ashot </ artifactId > < version > 1.5.2 </ version > </ dependency > </ pre > Then call the takeScreenshot() function,as shown below and you have a screenshot file. new AShot () .shootingStrategy( ShootingStrategies . viewportPasting( 100 )) .takeScreenshot(myWebDriver); You could even select specific html elements and take their screenshots. WebElement webElement = webDriver . findElement( By . cssSelector( "#element_to_be _captured" )); new AShot () .takeScreenshot(myWebDriver, webElement); All this can be found at below repository. https://github.com/yandex-qatools/ashot Know of any more libraries ...