there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?12 13619
Differences between UNIQUE and DISTINCT in select statements26 121295
What are the attributes of SQL*PLUS ?2 8360
Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.13 15451
i want to display 1 to 10 numbers using one select statement.18 33716
why use cursors?5 9375
how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c8 9857
What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?9 13761
How can i insert data inro a table with 3 columns using FORALL?2 8989
what is autonomouse transaction?3 6069
what are pl/sql collections?4 28319
How to create a view on a table which does not exists4 17213
how to write utl file pkg in SQL1 4952
wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?4 16957
what is the difference difference between procedure and packages2 8217
Compare the contents of the NetSim routing table with those of a IP/RIP based router
Why we check moisture,ash & AIA in product
What is an iterative algorithm?
Explain logical operators in sql server?
Explain the difference between map and flatmap stream operation?
What are the different ways of Textile Quality Control?
What is socket file in linux?
How does hydraulics work?
What are different types of arrays?
Explain a MSIL ? Why is it appreciated by all developers?
Explain the difference between sap r/2 and r/3?
What automation tools could be used for post-release validation with continuous integration?
Explain about processing table?
what is the difference between dynamic as well as non - dynamic data structures.
stripos — Find position of first occurrence of a case- insensitive string int stripos ( char* haystack, char* needle, int offset ) Returns the numeric position of the first occurrence of needle in the haystack string. Note that the needle may be a string of one or more characters. If needle is not found, stripos() will return -1. The function should not make use of any C library function calls.