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"
Labels:

Comments

  1. php developmentApril 03, 2014

    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...
2 comments
Read more

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...
Post a Comment
Read more

How to detect browser closing events and warn user before closing

Recently I came across this problem.I was creating a web application where users were supposed to save their work before logging out.While testing, it turned out that many users closed their browsers instead of logging out. To solve this, I googled the problem and found out that this was a very common problem. I just used below java script code in my webpage's header. Q. How to detect browser closing event and save your data Ans: The onunload event gets fired when the browser is closed or refreshed(using F5 or the refresh button). So now It turns out that the data was getting saved unnecessarily on refreshing the page. For that I stumbled across a forum where I found the solution.(It works for IE only) Q.How to disable function key F5? Ans: document.attachEvent("onkeydown", my_onkeydown_handler); function my_onkeydown_handler() { switch (event.keyCode) { case 116 : // 'F5' event.retur...
Post a Comment
Read more