Code:
CREATE INDEX emp_first_name_idx ON copy_emp(first_name DESC);
Code:
SELECT * FROM copy_emp ORDER BY first_name DESC;
CREATE INDEX emp_first_name_idx ON copy_emp(first_name DESC);
SELECT * FROM copy_emp ORDER BY first_name DESC;
SELECT last_name, TO_CHAR(hire_date, 'DD-Mon-yyyy') from employees WHERE TO_DATE(hire_date, 'DD-Mon-YYYY') < '01-Jan-1990'; Output: LAST_NAME TO_CHAR(HIRE_DATE,'DD-MON-YYYY') -------------------------------------------------- King 17-Jun-1987 Kochhar 21-Sep-1989 De Haan 13-Jan-1993 Hunold 03-Jan-1990
class ArrCreate { public int[][] createArray() { int[][] s = new int[3][]; s[0] = new int[4]; s[1] = new int[2]; for(int i = 0; i < s.length; i++) { for(int j=0; j < s[i].length; j++) { s[i][j] = j + 1; } } return
class SwitchTest { public static void main(String args[]) { int x = 5; switch(x) { case 1: System.out.println("In 1st case"); return ; case 3: System.out.println("In 3rd case"); return ; case 5: System.out.println("In 5th case"); return ; case 7: System.out.println("In
using namespace std;
System.out.println(3.2 + " 4.5");
# include <stdio.h> void main() { char str[] = "Zingle Bell Zingle Bell"; printf("%.#s %.2s", str, str); }
Leave a comment: