Recent posts under tag oracle

Post under tag oracle

+1 vote

1 answer

How can I get the source code for a function or a procedure or a package from the database?

posted Dec 2, 2014 by Archana

+1 vote

2 answers

Can some body give me some example of INSTEAD OF trigger?

posted Dec 2, 2014 by Archana

+2 votes

1 answer

Can you call a stored function in the constraint of a table?

posted Dec 1, 2014 by Archana

+2 votes

1 answer

What are the various types of parameter modes in a procedure in PLSQL ?

posted Dec 1, 2014 by Archana

+2 votes

1 answer

Can you have two functions with the same name in a PL/SQL block?

posted Dec 1, 2014 by Archana

+3 votes

1 answer

Can we define exceptions twice in same block in PLSQL?

posted Dec 1, 2014 by Archana

+2 votes

1 answer

What are the various types of Exceptions?

posted Nov 26, 2014 by Suchithra

+1 vote

1 answer

Can one read/write files from PL/SQL?

posted Nov 26, 2014 by Suchithra

+1 vote

1 answer

What DBMS package should I use to manipulate the long column in Oracle 7

posted Nov 24, 2014 by Archana

+1 vote

1 answer

How does one get the value of a sequence into a PL/SQL variable?

posted Nov 24, 2014 by Archana

+1 vote

0 answers

Polish char is getting changed to a differerent char when loading into Oracle

posted Nov 24, 2014 by Amit Sharma

+1 vote

1 answer

What are the two ways to specify a column alias?

posted Nov 19, 2014 by Suchithra

+1 vote

1 answer

How can I view the dependencies of a PL/SQL block?

posted Nov 19, 2014 by Suchithra

+1 vote

1 answer

Can one only retreive rows X to Y from a table?

posted Nov 18, 2014 by Archana

+2 votes

2 answers

What is a Result Set? when is it created?

posted Nov 18, 2014 by Archana

+1 vote

1 answer

what are INSTEAD OF triggers?

posted Nov 18, 2014 by Suchithra

+1 vote

1 answer

Can we use select in FROM clause of SQL select?

posted Nov 18, 2014 by Suchithra

+1 vote

1 answer

What are Explicit Cursor attributes?

posted Nov 13, 2014 by Suchithra

+1 vote

1 answer

How an Explicit cursor works?

posted Nov 13, 2014 by Suchithra

+1 vote

1 answer

How an Implicit cursor works?

posted Nov 12, 2014 by Vidhya Sagar

+1 vote

2 answers

Explain Implicit and Explicit cursors.

posted Nov 12, 2014 by Vidhya Sagar

+4 votes

2 answers

What is Commit, Rollback and Savepoint in context of SQL/Oracle?

posted Nov 11, 2014 by Archana

+2 votes

1 answer

How does a syntax error differ from a runtime error in Oracle SQL?

posted Nov 11, 2014 by Archana

+1 vote

1 answer

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

posted Nov 11, 2014 by Archana

+3 votes

1 answer

Explain three different rules that apply to NULLs when doing comparisons?

posted Nov 11, 2014 by Archana

+3 votes

1 answer

What special operators does Oracle provide for dealing with NULLs?

posted Nov 11, 2014 by Archana

+1 vote

1 answer

Trigger Infa workflow based on the status column in oracle table

posted Nov 7, 2014 by anonymous

+1 vote

1 answer

can anyone tell me about SQL tuning tips?

posted Nov 7, 2014 by Archana

+2 votes

1 answer

unable to connect to the DB using Taod ORA-12571 TNS packet writer failure

posted Nov 7, 2014 by Archana

+1 vote

2 answers

can any explain about SQL TRUNCATE TABLE?

posted Nov 5, 2014 by Archana

+3 votes

1 answer

can any one explain about SQL Unions Clause in detail ?

posted Nov 5, 2014 by Archana

+2 votes

1 answer

What is lock escalation?

posted Oct 29, 2014 by Vidhya Sagar

+2 votes

1 answer

Explain Active/Active and Active/Passive cluster configurations ?

posted Oct 29, 2014 by Suchithra

+2 votes

1 answer

What's the maximum size of a row in Oracle?

posted Oct 29, 2014 by Suchithra

+2 votes

1 answer

Explain different isolation levels in Oracle?

posted Oct 29, 2014 by Suchithra

+2 votes

1 answer

What is a transaction and what are ACID properties in Oracle?

posted Oct 29, 2014 by Suchithra

+2 votes

0 answers

What are user defined datatypes and when you should go for them in Oracle?

posted Oct 29, 2014 by Suchithra

+3 votes

1 answer

Difference between TRUNCATE, DELETE and DROP commands?

posted Oct 27, 2014 by anonymous

+2 votes

1 answer

what is clustered index in Oracle?

posted Oct 22, 2014 by Vidhya Sagar

+2 votes

1 answer

Is space acquired in blocks or extents in Oracle?

posted Oct 22, 2014 by Archana

+1 vote

Oracle Software Professional at Capegemini

posted Oct 21, 2014 by anonymous

+3 votes

3 answers

How many columns can table have in Oracle?

posted Oct 21, 2014 by Vidhya Sagar

+2 votes

1 answer

What is pseudo columns in Oracle and what are their names?

posted Oct 21, 2014 by Suchithra

+1 vote

1 answer

Can we disable database trigger in Oracle, if yes then how?

posted Oct 20, 2014 by Vidhya Sagar

+2 votes

1 answer

What is the Difference between a post query and a pre query?

posted Oct 20, 2014 by Suchithra

+1 vote

2 answers

What is Normalization in Oracle?

posted Oct 17, 2014 by Suchithra

+2 votes

1 answer

What are Codd Rules in Oracle?

posted Oct 16, 2014 by Vidhya Sagar

+1 vote

1 answer

What are mutating tables in Oracle?

posted Oct 16, 2014 by Archana

+1 vote

1 answer

What is the difference between deleting and truncating of tables in Oracle?

posted Oct 15, 2014 by Suchithra

+1 vote

1 answer

What is a 2 Phase Commit in Oracle?

posted Oct 15, 2014 by Suchithra

Page:

« prev
1
...
6
7
8
9
10
11
12
next »

...