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: