Difference between table function and pipelined function?
No Answer is Posted For this Question
Be the First to Post Answer
what is the difference between undefined value and null value? : Sql dba
I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?
type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...
What is difference between procedure and trigger?
How to find the count of letter "L" in HELLO
What are the types of index in sql?
I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????
What is the current version of sql?
How toimport .dmp file in lower version of oracle from higher version ?
What is bind reference and how can it be created?
What do you think about pl/sql?
difference between SQL and C
1 Answers Indus Software Technologies,
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)