Oracle SQL PLSQL Interview Questions Answers, Oracle Placement Papers, Oracle Technical, HR Interview Questions, Oracle Aptitude Test Questions, Oracle Campus Placements Exam Questions

Company Name Starts with ...

# A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Oracle SQL PLSQL Interview Questions

Questions Answers Views Company eMail

there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?

12 19839

Differences between UNIQUE and DISTINCT in select statements

26 135499

What are the attributes of SQL*PLUS ?

2 10456

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 22407

i want to display 1 to 10 numbers using one select statement.

18 47556

why use cursors?

5 12824

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c

8 13881

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 18383

How can i insert data inro a table with 3 columns using FORALL?

2 10833

what is autonomouse transaction?

3 8207

what are pl/sql collections?

4 32102

How to create a view on a table which does not exists

4 21025

how to write utl file pkg in SQL

1 6545

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?

4 19782

what is the difference difference between procedure and packages

2 10383

Post New Oracle SQL PLSQL Interview Questions

Oracle SQL PLSQL Interview Questions

Oracle SQL PLSQL Interview Questions (40)

Un-Answered Questions

What is the job of the network layer under the osi reference model?

280

Who is considered the father of accounting?

1204

explain end to end scenario's for online Money transfer in Banking Domain?

1977

i have passed my +2 i am getting admission biotechnolgy in govt college chd afflited to punjab universty, but beside that i am getting admission in b.pharma in punjabi universty patiala where should i go in which field

2000

In Crystal Report, I created one report and i change the modification due to user request. Normally the crystal report document will be saved in .rpt file. ->Now i saved the Modification document on pdf Format and saved in my Desktop. ->Normally what ever we change the modifications it will reflect and update in Data base. * Now my question is How user will see the modification requirement in crystal report and where the document saved in crystal report? Kindly suggest

1492

how do you pass parameters in cl?

1806

Explain the working of fir filters?

1011

What is keyword in python?

902

Explain how does the report manager work in ssrs?

948

What is rundll32 windows host process?

838

Differentiate between data science, machine learning and ai.

What are the varieties of homo sapiens sapiens?

2153

What is the difference between kafka and mq?

504

How can you optimize AI models for edge deployment?

103

Which interface need to implement so that you can use lightning component as quick action? : salesforce lightning component

526