Skip to main content

consultas Oracle

Image
By

1.
select employee_id, first_name
from employees
where upper(first_name) like '%R%';

2.
select employee_id, first_name, job_id, department_id
from employees
order by job_id, department_id ;

3.
select employee_id, first_name, job_id, comission_pct
from employees
where comission_pct is null;

4.
select first_name
from employees
where upper(first_name) like '_L%';

5.
select distinct job_id
from jobs;

6.1
select first_name, job_id
from employees
where department_id in (10,60);

6.2
select first_name, job_id
from employees
where department_id like 10 or department_id like 60;

7.
select first_name, comission_pct
from employees
where comission_pct > 0.3;

8.
select first_name, salary, department_id
from employees
where department_id=50
order by salary desc;

9.
select first_name
from employees
where first_name like '____';

10.
select first_name, job_id
from employees
where employee_id in (148,149)
order by first_name;

11.
select first_name, last_name, salary, job_id
from employees
where upper(first_name) like '%L%' and job_id like 'SA_REP' and salary >9600;

12.
select first_name, employee_id
from employees
where employee_id between 170 and 177;

Comments

Post a Comment

Popular posts from this blog

boleta, cliente, nombre en Java

By
import java.util.ArrayList; public class Cliente { private String nombre; private ArrayList boletas; public Cliente(String nombre) { this.nombre = nombre; this.boletas = new ArrayList(); } public String getNombre() { return this.nombre; } public void agregarBoleta(Boleta boleta) { boletas.add(boleta); } public void imprimirHistorial() { Boleta b; System.out.println("Nombre: " + nombre); for (int i=0; i b = (Boleta)boletas.get(i); b.imprimir(); } } } public class Articulo { private String descripcion; private int stock; private int precio; public Articulo(String descripcion,int stock,int precio){ this.descripcion = descripcion; this.stock = stock; this.precio = precio; } public String getDescripcion() { return this.descripcion; } public int getStock() { return this.stock; } public int getPrecio() { return this.precio; } } import java.util.ArrayList; public class Boleta { private String fecha; private int total; private ArrayList ar...
4 comments
Read more

Biseccion C++ (codigo)

By
% f: funcion a la que se va a sacar el cero % a, b: limites del intervalo % delta: error absoluto maximo f = @(x)(x*sin(x)-1); a = 0; b = 2; delta = 0.00001; % ya: valor de la funcion en a % yb valor de la funcion en b % yc: valor de la funcion en c % err: error de la ultima iteracion % maxi: maximo de iteraciones ya = f(a); yb = f(b); if ya * yb > 0 disp "No existe una raiz en el intervalo" break end maxi = 1 + round((log(b-a)-log(delta))/log(2)); for k = 1:maxi c = (a+b) / 2; yc = f(c); if yc == 0 a = c; b = c; elseif yb*yc > 0 b = c; yb = yc; else a = c; ya = yc; end if b-a < delta break end end c = (a+b) / 2; err = abs(b-a); yc = f(c); % mostrar resultados printf("La aproximación al cero es: %10.6f\n",c); printf("Con un error absoluto menor a %8.6f\n",err); printf("El valor de la funcion en la aproximacion es %10.8f\n",yc);
Post a Comment
Read more

Hacker Test

By
_________________________________________________________________________________ Un pequeño juego de 20 niveles el cual te ayudara con tus habilidades en seguridad de php, javascript, HTML y graficos. lo recomiendo muy bueno para pasar un buen rato para aquellos que gustarian ser hackers aqui podria aprender cosas basicas. HackerTest COMENTEN !!!!
1 comment
Read more