-
-
Query to retrieve one entire column data
Write a query to retrieve one entire column data of multiple rows into one single column of single row?
What is procedure and package
Hi ,can any one tel pls what is use ofprocedures and packages? why we use can anyone tell me with one real time example
How to update a rows with opposite gender in Sql?
In Emp table there is a column which consists of gender (Male or Female) ? How should one
Can update the Values of Male to Female and Female to Male with a single query ?How can we insert into a table by fetching data from more then one table by using only single command
I have 3 tables , same no of columns ,i want to insert whole the data from all these table into a single table,which also having same no of column and the same data type.
What is meant by instead of cursor?
Raviteja
- Aug 23rd, 2014
Instead of cursor is not there,, instead of trigger is used incase of complex views. when we use views with joins
Kumar
- Jul 25th, 2014
Its instead of trigger not cursor and it is used to apply trigger on views.
Why we have to perform calculation part in Functions?
Procedure also written the values using out parameter than why we need functions?
Rakesh057
- Jul 1st, 2014
Because procedure is pre compiler and function is not pre compiler so that the reason we go for an calculation part in function
Madhav
- Jul 1st, 2014
Procedure also written in out parameter but we can not use procedure in Sql statement.
But if we wrote function and ita cant contain DML operation then we can access this function in SQL queries.What is the main purpose of RETURN in functions?
What is the main purpose of RETURN in functions when we can calculate a value and pass it through using OUT mode in procedure or functions?
Deepika S Verma
- Mar 14th, 2014
Its a myth that function returns value whereas procedure does not, actually procedure also return value (i.e. 0 or 1 ) at the time of exiting which indicates the success or error. Whereas Function ret...
shivigupta
- Oct 9th, 2012
create or replace procedure proc1 as begin dbms_output.put_line(Before Return Clause); return; dbms_output.put_line(After Return Clause); end; set serveroutput on; begin proc1; dbms_output.put_line(I...
What is PL/Sql tables?Is cursor variable store in PL/SQL table?
Pixie
- Feb 18th, 2014
PL/SQL tables are PL/SQLs way of providing arrays. They are temporary tables in memory and thus are processed very quickly. They are not database tables, and DML statements cannot be issued against...
sbagai2001
- May 30th, 2006
DECLARE TYPE EmpCurTyp IS REF CURSOR; // Reference Cursor - weak TYPE NumList IS TABLE OF NUMBER; // Table of Number TYPE NameList IS TABLE OF VA...
Bind variabales
What are bind variables in sql? explain in detail?
pradipta
- Feb 8th, 2014
The way to get Oracle to reuse the execution plans for "the statements having different hard coded value in where clause" there should use bind variables. Bind variables are ?substitution? variable...
Aarti
- Jan 15th, 2014
Bind variable is session specific variable. It is declared using variable keyword. Bind variable cant be used in named block. It cant have default value.
Where would you use implicit & explicit cursors?
Malar somu
- Sep 10th, 2013
Implicit Cursor:- It is Oracle implicit type.. when we fetch only one record then we need to use implicit cursor i.e when ever we performing select query or any dml operations termed as implicit curso...
hira
- Aug 8th, 2013
When ever any query execute by the server in database sever itself create a implicit cursor ,which can not any control to the programmer but in case explicit cursor the programmer has to create it.and used for the data manipulation by following some rule......
What happens to the base table transactions when procedure has some error?
Procedure A calls procedure B. A updates table t1, t2. B updates table t3. If some error happens to B what happens to the updates in all those tables? Whether they will rollback or commit? If commits how far it will commit?
vishal.bhadange
- Aug 24th, 2013
CASE 1 (If you are not handling exception in Procedure B, none of the table gets updated) "sql PROCEDURE A BEGIN UPDATE TABLE t1; UPDATE TABLE t2; CALL PROCEDURE ...
What is the difference between procedure and function and package, which is the fastest
JILEY SINGH
- Aug 4th, 2013
Function can be called in select statement but procedure cant be called in select statement. function has return keyword but procedure not
Varun Tiwari
- Jul 4th, 2013
Function Procedure 1. Can be used as column Cant used in select statement in select statement 2. Can be used in where Cant used in where condition c...
Can we use function inside a trigger
What is the data type of Null?
rayavarapu
- Jan 23rd, 2013
Null is not a value and not a string. It is unknown it is maximum in descending order and minimum value in ascending order.
Sandeep
- Mar 7th, 2012
Char(0)
How can I get recent 10 records out of 100 records
HI all
table contain some 1000 records, today I inserted 100 records into table, so I want first 10 records data from 100 records
how can I retrieveCan e truncate some of the rows from the table instead of truncating the full table.
Vishal R Bhadange
- Aug 12th, 2012
Yes.
Yes we can truncate some of the rows from the table, But table should be partitioned & all the rows to be deleted should be present in one single partition...> Select Count(*) from T1 where a=10 3> Select count(*) from T1 where b=20 11Now, What will b the O/P of the following..select count(*) from T1 where a=10 or b=20..............................
ChevyBlazer
- Jul 2nd, 2012
The answer will be between 11-14 . You have to consider two extreme cases where 1. 3 rows with a=10 and 11 rows with b=20 are all distinct rows - then the answer will be 14 2. Where there are 11 rows...
Venkat
- Jun 30th, 2012
The accurate answer is "The result can contain max of 14 records", but this not guaranteed. It can be less also. (Minimum is 10 rows and maximum is 14 rows). It is because there can be some overlpa in the same row between "a" and "b" column.
Ans