1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
SQL PLSQL Interview Questions
Questions Answers Views Company eMail

how to write utl file pkg in SQL

Oracle,

1 5822

I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

 2 6515

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

Oracle, TCS, Tecnics,

4 18733

i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w

Scope International,

4 16435

i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???

Scope International,

3 8903

Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)

 5 9213

Write a query to get last 10 records from the table.

iNautix,

12 24114

how to see the oracle 9i/10g table in pc? or In my pc where the table is saved and how to see?

 1 3661

i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks i need 1st dd for evry wk

Aspire,

1 5660

IF i write before / after insert / update trigger and i do rollback what will happen?

KPIT,

5 10171

I want to create synonym for table emp but in my pc it is giving insufficient previliges.I am using user scott.Please suggest me.

 3 5372

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

 1 4781

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

Wipro,

5 8244

sql query to get zero records from a table having n no of records

CTS,

8 24049

How do we tune the code?

 2 5178

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is full join in sql?

622

What are the different types of tables in sql?

578

What is the largest value that can be stored in a byte data field?

615

Can we create index on primary key?

629

Which one is faster ienumerable or iqueryable?

584




What is sql select statement?

609

Is it important to partition hard disk?

651

Can I join the same table twice?

652

What is a join query?

652

What is sql server and ase?

640

What is clustered and nonclustered index in sql?

599

How do I write a sql query in pgadmin 4?

647

What is the file extension for sql database?

605

Why self join is used in sql?

605

how many ways to get the current time? : Sql dba

626

For More Un-Answered { SQL PLSQL } Questions Click Here