package com.ejie.t17i.dao;

public class PaisDaoSql {

	/**
	 * StringBuilder initilization value
	 */
	public static final int STRING_BUILDER_INIT = 4096;
	public static final String SEQUENCE_NAME = "";
	public static final String TABLA = " t17i.T17_PAIS ";
	public static final String ORDER = " ORDER BY NOMBRE";
	public static final String ALIAS = "PAIS";
	public static final String PK = "ID";
	public static final String SQL_SELECT = "SELECT  "
		+ PaisDaoSql.ALIAS + ".ID ID,"
		+ PaisDaoSql.ALIAS + ".DS_O NOMBRE";
	public static final String SQL_SELECT_COUNT = "SELECT COUNT(1)";
	public static final String SQL_FROM = " FROM "
		+ PaisDaoSql.TABLA + " "
		+ PaisDaoSql.ALIAS + " ";
	public static final String SQL_WHERE_ID = " WHERE "+PK +" = ?";
	public static final String SQL_WHERE_ALL = " WHERE 1=1";

	public static final String SQL_FIND = SQL_SELECT + SQL_FROM + SQL_WHERE_ID;
	public static final String SQL_FIND_ALL = SQL_SELECT + SQL_FROM;
	public static final String SQL_FIND_ALL_COUNT = SQL_SELECT_COUNT + SQL_FROM;
	
}
