Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

i have a column which may contain this kind of value:
123*67_80,12*8889_5,34*8_874 ,12*7_7
(can contain space before a comma, and this string length can be anything)
now i want to split this value into two column like:
column1: 123*67,12*8889,34*8,12*7
column2: 80,5,874,7

use function for this

Question Posted / anonymous

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

Explain the difference between 'between' & 'and' operators in sql

0 Answers  

How to use distinct and count in sql query? Explain

0 Answers  

what are the authentication modes in sql server? How can it be changed? : Sql dba

0 Answers  

Is t sql a programming language?

0 Answers  

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

0 Answers   Prodapt,

Why primary key is required?

0 Answers  

Are stored procedures faster than dynamic sql?

0 Answers  

What is a join query?

0 Answers  

i want run a sql query query? which phases are run in a back ground? pls tell me the answer

1 Answers  

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

5 Answers   HSBC,

<<labele>> declare a=10 b=20, begin some statements declare a=30 c=40 end; what is the A value in nested block?

1 Answers   ITC Infotech,

Why do we create views in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories