Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Oracle General Interview Questions
Questions Answers Views Company eMail

how to get last monday of a month?

Multifonds,

2 4434

Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??

BirlaSoft,

1 4427

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

IBM,

1303

I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.

4 3724

i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions

CGI,

4 5025

what is insert all statement in sql

CGI, TCS,

2 4616

select trunc(round(156.00,-1),-1) from dual;

2 21505

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1058

primary key is foreign key for the same table?

Oracle,

2 5285

1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?

Accenture,

2 4839

how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?

Infosys,

1 2752

how to produce numbers from 1 to 10 using dual table

Genpact,

4 7863

two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)

2 3313

how may join possible between (requisition with purchase order)

1277

I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????

1 3435


Post New Oracle General Questions






Un-Answered Questions { Oracle General }

What is backup in Oracle?

177


What are the types of trigger in oracle?

168


What are the different types of database objects?

173


Explain what are clusters?

202


What is meant by raw datatype?

177






How to shutdown your 10g xe server from command line?

184


What is oracle and what are its different editions?

164


Does oracle charge for java?

152


How remove data files before opening a database?

174


What is a cursor in oracle?

200


What are joins, explain all types of joins?

1188


What is the difference between $oracle_base and $oracle_home?

171


What do you mean by a database transaction & what all tcl statements are available in oracle?

178


6. Display the client name and order date for all orders using the traditional method.

1289


How to unlock the sample user account in oracle?

171