-
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?
-
Truncate and Delete concept
Hi, Let us take a scenario such that I issue a delete on table emp and truncate on table emp1 which is exact replica (in terms of both structure and data) of emp table.Now , I issue a commit on both sessions. If I do a select * from emp and select * from emp1 now, which one should execute faster and why?
-
Display Time in SQL
How to display current system time in SQL.
-
TOAD
What does Toad mean? How it's work?
-
Different values for SYSTEM.MESSAGE_LEVEL
What are the different values for :SYSTEM.MESSAGE_LEVEL and its impact?
-
Index on coloumns
How to see on what coloumns the indexes have been created?
-
-
-
How to Create a table in SQL with a table name depending on the date the code is run ?
For e.g. Create table tempOCT as Select....If i run the code in any day of Nov the table name should be tempNOV.
-
SQL Query help
Needed a SQL query for this----------I have table with columns firstname, lastname and phone number and we have 2 entries in that table ...now I want to know the persons with this combination firstname of person = lastname of second person? ln phone----------------------------------john cubick 1223sam course 4556output:john course
-
-
-
-
-
-
-
-
-
-