@Sai_kiran_rachakonda

elements of a list in single line

October 30, 2022 · Python 
num = [23,24,54,34]
for i in num:
    print(i, end = " ")

list with random data types

October 30, 2022 · Python 
x = [22, 'PythonLobby', 22.3]
print(x)

count

October 30, 2022 · Python 
x = '@pyThOnlobb!Y34'
count = count1 = count2 = count3 = 0
for i in x:
    if i.islower():
        count += 1
print('lower counts', count)
for i in x:
    if i.isupper():
        count1 += 1
print('upper counts', count1)

sorting lower and upper

October 30, 2022 · Python 
x = 'pytHOnloBBy'
em = []
em1= []
for i in x:
    if i.islower():
        em.append(i.lower())
for j in x:
    if j.isupper():
        em1.append(j.upper())
print(''.join(em+em1))

searching a word in string

October 30, 2022 · Python 
x = 'I am a boy'
if 'boy' in x:
    print("'boy' exists in string")

lower to upper and vice-versa

updated October 30, 2022 · Python 
x = 'PrOgRaMM'
for i in x:
    if i.islower():
        i = i.upper()
    else:
        i = i.lower()
    print(i)

occurrence of each character in a word

October 30, 2022 · Python 
x = 'programm'
d = {}
for i in x:
    if i in d:
        d[i] += 1
    else:
        d[i] = 1
        
print(d)

removing duplicates in a string

October 29, 2022 · Python 
x = 'pythonlobby'
em = []
for i in range(len(x)):
    if x[i] not in em:
        em.append(x[i])
    else:
        pass
for i in range(len(em)):
    print(em[i], end = "")

no.of vowels and consonants in a string

October 29, 2022 · Python 
x = 'python'
count = 0
count1 = 0
for i in x:
    if i == 'a' or i == 'e' or i == 'i' or i == 'o' or i == 'u':
        count += 1
    else:
        count1 += 1
        
print(count)

reverse a string

October 29, 2022 · Python 
x = 'python'
y = x[ : : -1]
print(y)

example-22222222

June 29, 2022 · SQL 
-- create a table
CREATE TABLE okok (
  c1 varchar2(2),
  c2 varchar2(2),
  c3 varchar2(2),
  c4 varchar2(2),
  c5 varchar2(2)
);
-- insert some values
INSERT INTO okok VALUES (null , 'R', 'a', 'a', 'g');

example-22222222

June 29, 2022 · SQL 
-- create a table
CREATE TABLE okok (
  c1 varchar2(2),
  c2 varchar2(2),
  c3 varchar2(2),
  c4 varchar2(2),
  c5 varchar2(2)
);
-- insert some values
INSERT INTO okok VALUES (null , 'R', 'a', 'a', 'g');

example-22222222

June 29, 2022 · SQL 
-- create a table
CREATE TABLE okok (
  c1 varchar2(2),
  c2 varchar2(2),
  c3 varchar2(2),
  c4 varchar2(2),
  c5 varchar2(2)
);
-- insert some values
INSERT INTO okok VALUES (null , 'R', 'a', 'a', 'g');

example (SQL)

June 29, 2022 · SQL 
create table emp(
     id int,
     name varchar2(20),
     dno int,
     h_date date,
     job varchar2(20),
     sal int
     );
     
insert into emp values(1, 'sai pavan',22, '29-06-2022', 'manager', 6000000);

example (SQL)

June 29, 2022 · SQL 
create table emp(
     id int,
     name varchar2(20),
     dno int,
     h_date date,
     job varchar2(20),
     sal int
     );
     
insert into emp values(1, 'sai pavan',22, '29-06-2022', 'manager', 6000000);

example (SQL)

June 27, 2022 · SQL 
CREATE TABLE palette_a (
    id INT ,
    color VARCHAR2 (100),
    favcol int
);

INSERT INTO palette_a 
VALUES (1, 'Red', 792);

INSERT INTO palette_a

example (SQL)

June 27, 2022 · SQL 
CREATE TABLE palette_a (
    id INT ,
    color VARCHAR2 (100),
    favcol VARCHAR2(20)
);

INSERT INTO palette_a 
VALUES (1, 'Red', 'black');

INSERT INTO palette_a

example (SQL)

June 27, 2022 · SQL 
CREATE TABLE palette_a (
    id INT ,
    color VARCHAR2 (100),
    favcol VARCHAR2(20)
);

INSERT INTO palette_a 
VALUES (1, 'Red', 'black');

INSERT INTO palette_a

example (SQL)

June 25, 2022 · SQL 
CREATE TABLE palette_a (
    id INT PRIMARY KEY,
    color VARCHAR2 (100) NOT NULL
);
CREATE TABLE palette_b (
    id INT PRIMARY KEY,
    color VARCHAR2 (100) NOT NULL
);
INSERT INTO palette_a (id, color)
VALUES (1, 'Red');

from the left table that do not exist in the right table.....

June 25, 2022 · SQL 
CREATE TABLE palette_a (
    id INT PRIMARY KEY,
    color VARCHAR2 (100) NOT NULL
);
CREATE TABLE palette_b (
    id INT PRIMARY KEY,
    color VARCHAR2 (100) NOT NULL
);
INSERT INTO palette_a (id, color)
VALUES (1, 'Red');